CODEWITHSUNDEEP
mysql
Michael
Michael

Reputation: 6405

Export a table under different name

I would like to know if it's possible to export a table using mysqldump (along with the data) but under a different name. For example I have tablex but I want to export it as tabley

Upvotes: 1

Views: 2748

Answers (1)

Gavin Coates
Gavin Coates

Reputation: 1425

All MySQLDumper does is create a text based file filled with SQL statements to recreate the database structure and insert each record.

Simply perform an SQL Dump, then open up the text file, and do a search + replace on the table you wish to rename.

Upvotes: 3

Related Questions