All geek questions in one place

Backing up MySQL on shared hosting on Windows that prevents remote connectivity

after a long google search, I decided to ask a question:

I uploaded the site to shared hosting, which does not allow remote database connection due to security problems (in accordance with them). the data is very important to me, and I would like to back up automatically on a daily basis (in addition to the daily backup of hosts).

I am writing code in ASP.NET and using MySQL DB. Win 2003 server and PHPmyAdmin. as mentioned in the header - I cannot connect to it remotely.

How can I schedule an automatic backup for the database? Thank you very much!

+3
source share
2 answers

I found a solution for this problem: http://www.phpmybackuppro.net/

This is a free tool that does not require a real installation. you upload files, configure according to the instructions, then you can call the backup procedure on demand from the web page or manipulate it as you like. great tool!

+2
source

Depending on your host, you can run a crane (scheduled tasks in windows) on the box. If so, and if you have access to mysqldump, you can mysqldump the contents of the database with a command such as ...

mysqldump -u database_username -pdatabase_password -h 127.0.0.1 > ~/database.backup.sql

, , , . , , , , , - . .

, - - ? , cron (, ) , .

+1

Source: https://habr.com/ru/post/1758611/

More articles:


All Articles