CODEWITHSUNDEEP
mysql
testingmysql
testingmysql

Reputation: 433

Generating SQL script from MySQL database table

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.

Upvotes: 1

Views: 4284

Answers (2)

Byron Whitlock
Byron Whitlock

Reputation: 53861

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

Upvotes: 3

Dark Castle
Dark Castle

Reputation: 1299

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

Upvotes: 5

Related Questions