Search by tag: mysqldump

1 article

MariaDB / MySQL: backup and restore a specific table

Apr 7, 2014 by dixDel

mariadb mysql backup mysqldump

We just have to specify the name of the table we want to backup in the usual mysqldump command:

$ mysqldump -h hostname -u username -p database_name table_name > backup_table_name.sql

Then, to restore it:

mysql -u username -p database_name

Source