Backup and restore MySQL database without system access
Posted
by Sencerd
on Server Fault
See other posts from Server Fault
or by Sencerd
Published on 2010-04-27T17:56:19Z
Indexed on
2010/04/27
18:04 UTC
Read the original article
Hit count: 284
Hi guys,
I am trying to move a database from 1 provider to another, the problem is that I don't have system access at either end (ie, no ssh), so I cannot use a mysqldump.
I have already tried using MySQL Administrator, the backup took about 45 minutes, but when it came to restoring it was moving at a snails pace, and estimating 12+ hours. This is a live app so I need to keep the downtime to an absolute minimum.
The database consists of 35 tables, a mixture of MyISAM and InnoDB, the whole thing comes to about 4.4GB. The source and destination databases are both running on very powerful servers.
Any suggestions on a quick way of doing this will be gratefully received.
Thanks
© Server Fault or respective owner