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
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.
精彩评论