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

Filed under:
|
|

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

Related posts about mysql

Related posts about backup