Posts Tagged ‘ mysql ’

To create a dump file use the following syntax:

/var/lib/mysql # mysqldump -u root -p mysqldatabase > backup.sql

You will be prompted for the password and the backup file will be created.

————————————————————————-

To restore a backup dump file use the following syntax:

/var/lib/mysql # mysql -u root -p mysqldatabase < backup.sql

You will be promted for the password and the backup will be restored.