Backup:
mysqldump -u user -p database_name > dump.sql (Enter password)
Restore:
mysql -u user -p new_database_name < dump.sql (Enter password)
Backup and restore a MySQL database
October 18th, 2009 — Never forget
Everything that glitters is not gold. But I definitely am.
October 18th, 2009 — Never forget
Backup:
mysqldump -u user -p database_name > dump.sql (Enter password)
Restore:
mysql -u user -p new_database_name < dump.sql (Enter password)