Welcome to WebmasterWorld Guest from 188.8.131.52
Forum Moderators: open
How do you restore your database?
$mysqldump -uname -ppass --opt dbname > dbname.sql
then you can zip it, scp it to your home computer, whatever.
Then to restore:
$mysql dbname < dbname.sql
There is no limit on file size with this method (unless you're approaching the 2GB limit of some linux operating systems).