DBA Hub

📋Steps in this guide1/1

Backup a mysql database

Backup a single database:

mysql configurationintermediate
by MYSQL
13 views
1

Backup a mysql database

Backup a single database:

Code/Command (click line numbers to comment):

1
2
3
4
Syntax : mysqldump –u root –p[password] [database_name] > dumpfilename.sql
This example takes a backup of sampledb database and dumps the output to dbdump.sql
[mysql@localhost]#
mysqldump –u root –pmysql sampledb > /tmp/dbdump.sql

Comments (0)

Please to add comments

No comments yet. Be the first to comment!