mysql backup and restore

Howto backup and restore your MySQL databases

Backup

mysqldump -u root -p[root_password] [database_name] > dumpfilename.sql

Restore

mysql -u root -p[root_password] [database_name] < dumpfilename.sql

 

 

Share

Leave a Reply

Your email address will not be published. Required fields are marked *