DBA Hub

📋Steps in this guide1/1

Backup a specific table

SYNATX:

mysql configurationintermediate
by MYSQL
15 views
1

Backup a specific table

SYNATX: In this example, we backup only the ta2 table from sampledb database.

Code/Command (click line numbers to comment):

1
2
3
mysqldump –c –u username –p databasename tablename > /tmp/databasename.tablename.sql
root$
mysqldump –u root –p sample ta2 > /tmp/nwedb_ta2.sql

Comments (0)

Please to add comments

No comments yet. Be the first to comment!