How do you mysqldump specific tables?

Nigel · Jan 24, 2017

I've got a question for you experts here. How do you mysqldump specific tables?

I had found some answers in a search but they didn't seem to work.

eva2000 · Jan 24, 2017

checked official mysql docs https://dev.mysql.com/doc/refman/5.6/en/mysqldump.html ?

Code:

shell> mysqldump [options] db_name [tbl_name ...]
shell> mysqldump [options] --databases db_name ...
shell> mysqldump [options] --all-databases

LJSHost · Jan 24, 2017

Hi Nigel,

Try this to export an individual table

Code:

 mysqldump -u mysqlusername -p databasename table_name > tablebackup.sql

Nigel · Jan 25, 2017

Thanks for the replies guys. I'll try these two possibilities out and see if they work.

Dr. McKay · Feb 23, 2017

eva2000 said:
checked official mysql docs https://dev.mysql.com/doc/refman/5.6/en/mysqldump.html ?

Code:

shell> mysqldump [options] db_name [tbl_name ...] shell> mysqldump [options] --databases db_name ... shell> mysqldump [options] --all-databases

LJSHost said:
Hi Nigel,

Try this to export an individual table

Code:

mysqldump -u mysqlusername -p databasename table_name > tablebackup.sql

I am wondering there is a difference between this way with clicking on the tables on PHPmyadmin and export them?
or using mysqldump is faster?

HostingWaves · Feb 26, 2017

phpMyAdmin is also easy to take backup of specific table, but the backup file will be saved on local machine.

If you use below command to take backup of mysql table, the tablename.sql file will be generated on server itself and you can easily restore it too.

mysqldump -uuser -ppassword databasename tablename > tablename.sql

How do you mysqldump specific tables?

Nigel

Member

eva2000

Well-known member

Mujkanovic

Well-known member

LJSHost

Well-known member

Nigel

Member

Dr. McKay

Well-known member

HostingWaves

Member

Nigel

Member

Latest posts New threads

Latest posts

New threads

Latest Hosting Offers New Reviews

Latest hosting offers

Popular Contributors - Past 30 Days

Sponsors

Tag Cloud