Pun intended.
Cpanel db backup, mysql export, they're all rubbish with large databases (i.e. >10mb). I don't know why they bother.
To do it properly, you *need* ssh access to the server, or some other shell access. If you dont have it, get it. Seriously.
Once you're in the shell:
~> # mysqldump -u [your cpanel login] -p [FULL_dbname] > backup.sql
Then you have yourself a proper reliable sql file.
Remember to turn off the foreign key check before you import!
No comments:
Post a Comment