DBA Hub

📋Steps in this guide1/1

Restore a mysql database from backup

If the valid backup file is available with you, then you can restore the same using below command.

mysql configurationintermediate
by MYSQL
12 views
1

Restore a mysql database from backup

-- If  dbdump.sql is the backup file , then restore command will be

Code/Command (click line numbers to comment):

1
2
3
4
If the valid backup file is available with you, then you can restore the same using below command.
SYNTAX mysqldump –u root –p[password] [databasename] < dumpfilename.sql
[mysql@localhost]#
mysqldump –u root –pmysql sampledb > dbdump.sql

Comments (0)

Please to add comments

No comments yet. Be the first to comment!