A client has a large MySQL database and the existing backup & restore options provided through vBulletin are timing out as the database is large (596MB). The hosting console has limited features - it's cpanel or direct admin or anything. We don't have shell access but will be able to use PHP's exec(). Prior to software upgrades we need to be backing up the database and able to restore it if need be. Any recommendations?
Hello. I think that you have to keep somewhere over your current server. I think that it is not a deal to have DB on your laptop or desctop computer. So in this case I would suggest you for solutions something like RazorServers.com offers. I guess few bucks for backup is not to many.
ya if you have the sql files.. just do this: connect to the server via shell... type mysql -u USERNAME -p DATABASENAME < dumpfile.sql you will be prompted for the password for the database user, after inserting the proper credentials the database import will begin, and it will not timeout like it is doing for you now. It should complete in a few minutes depending on the available resources on the machine. Sebastian Rametta
You may try this script as well. http://www.ozerov.de/bigdump.php I've imported a fairly large database using this. Works in seconds.