I have a database backup of a MySQL database that is about 250MB. I made it with mysqldump
I was trying to load it on another server like so:
mysql -u xxxx -pxxxx data_mirror < dbdump.sql
I was not satisfied with this process because
- It did not give me any feedback on the (lengthy) progress
- It failed with a "Server went away" message
What method would you recommend for backing up and restoring large MySQL database?
I am doing this on Windows 7 - based servers.