Mysql – Dump Just 1 table from SSH

dumpMySQLsql

With this command :

mysqldump -uuser -ppass dbname > 1.sql

You can dump dbname to 1.sql

I want a way to dump and restore just 1 table of dbname from ssh and command line

Best Answer

You can just add a tablename to your command

mysqldump -uuser -ppass dbname tablename >1.sql

To recover

mysql -uuser -ppass -e "create database dbname;"

mysql -uuser -ppass dbname <1.sql

You may want to look at the mysqldump and mysql man pages for further information.

Related Solutions

Mysql – ERROR when restoring MySQL data dump

Looks like an unescaped apostrophe error to me. Just find it, fix it, then go on to the next one and hope there aren't too many.

Mysql – the fastest way to optimize a MySQL table

OPTIMISE TABLE will be faster as the data will not have to be converted to a textual format used by mysqldump and then digested by the mysql command line client.

If you are using InnoDB then you can do another trick,

ALTER TABLE $table ENGINE innodb;

This will rebuild the table by copying all the rows to a new table space and replacing the current table once done. However, while this is happening, the original table will not block readers. Writers will, of course, be blocked from updating until the operation is complete.

Best Answer

Related Solutions

Mysql – ERROR when restoring MySQL data dump

Mysql – the fastest way to optimize a MySQL table

Related Topic