mysqldump exports only one table

Question

I was using mysqldump to export the database  like this   mysqldump -u root -ppassword my database  gt  c  temp my database sql   Somehow  it only exports one table  Is there something I m doing wrong

User · Accepted Answer

try this  There are in general three ways to use mysqldump     in order to dump a set of one or more tables   shell gt  mysqldump  options  db name  tbl name        a set of one or more complete databases  shell gt  mysqldump  options  --databases db name       or an entire MySQL server   as shown here   shell gt  mysqldump  options  --all-databases

User · Answer

Quoting this link  http   steveswanson wordpress com 2009 04 21 exporting-and-importing-an-individual-mysql-table    Exporting the Table   To export the table run the following command from the command line   mysqldump -p --user username dbname tableName  gt  tableName sql   This will export the tableName to the file tableName sql    Importing the Table   To import the table run the following command from the command line   mysql -u username -p -D dbname  lt  tableName sql   The path to the tableName sql needs to be prepended with the absolute path to that file  At this point the table will be imported into the DB

User · Answer

Here I am going to export 3 tables from database named myDB in an sql file named table sql mysqldump -u root -p myDB table1 table2 table3  gt  table sql

User · Answer

In case you encounter an error like this  mysqldump  1044 Access denied when using LOCK TABLES  A quick workaround is to pass the    -single-transaction option to mysqldump  So your command will be like this  mysqldump --single-transaction -u user -p DBNAME  gt  backup sql

[mysql] mysqldump exports only one table

Examples related to mysql

Examples related to innodb

Examples related to mysqldump