Thursday, January 5, 2017

Backup Database



$ mysqldump -u root -p database_name > /home/admin/nasa-temp/db_backup.sql

Then, you need to enter db root (or db user) password

Use this for export:
mysqldump -u username -p databasename > filename.sql
Use this for import:
mysql -u username -p databasename < filename.sql


No comments:

Post a Comment