how to backup and restore mysql database

Posted on June 4, 2013 by aaaminnn — Leave a comment

This is the command line for backup and restore Mysql database.

it is recommended that you perform database backup before doing something you don’t really know.

# mysqldump -u <user_name> -p <database_name> > <backup_filename>

example : % mysqldump -u amin -p amin_database > amin_database_backup.sql

#mysql – u <user_name> -p <database_name> < file_name.sql

example: % mysql -u amin -p amin_database < amin_database_backup.sql

Tagged with: backup, mysql, restore
Posted in mysql