Generating SQL script from MySQL database table

Question

Hi,

Is there any application that will read a MySQL database table and generate a SQL script of INSERT statements (so that I can copy tables from one db to another db)? OR how can I transfer content from db1.table1 to db2.table2 where table1 and table2 is same.

Thank you.

Answer 1

You should take a look at mysqldump. You can specify the --nodata option to export the schema only.

Answer 2

mysqldump [options] db_name [tbl_name ...]

Will generate the script file including the create and inserts necessary for the tables selected. To import the dump you can simply do:

mysql -u <user> -p dbname < mys.dmp