marciayudkin
Member
- Joined
- Sep 13, 2014
- Messages
- 34
- Points
- 8
There are many tools to backup and restore databases like MySQL Dumper, Dumper Spydex, Bigdump or using wordpress plugins like BackWPUp, BackupBuddy and they are really very good. However if your database is too big upto several tens of GB then more common tools will get errors and could not handle them. So I would suggest to backup and restore databases by Mysqldump through the statements.
1. Backup database:
Access with Root account into SSH Server, run this command:
For example: if you backup database with user is root and pass is yourpassword and have the path to your database is /home/example.com/public_html/backup_folder/
Using this command:
2. Restore database:
For example, you want to restore database with user is root and pass is yourpassword then using this command
If you have other ways to backup and restore big databases easily, please write down.
Good luck!
1. Backup database:
Access with Root account into SSH Server, run this command:
Code:
mysqldump -u username -p[username_password] databasename > /path_to_your_db/databasename_backup.sqlUsing this command:
Code:
mysqldump -u root -pyourpassword databasename> /home/example.com/public_html/backup_folder/Your_DB_backup.sql
Code:
mysql -u username -p[username_password] databasename < /path_to_your_db/databasename_backup.sql
Code:
mysql -u root -pyourpassword databasename < /home/example.com/public_html/backup_folder/Your_DB_backup.sqlGood luck!
One thing i will say is ask a staff member of webmastersun to move this to the Web Hosting Tutorials section. That way users will know its a tutorial, instead of thinking it was a question on "moving large databases" like i thought 
