开发者

Export a table under different name

开发者 https://www.devze.com 2023-02-15 06:13 出处:网络
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 tableyA

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.

0

精彩评论

暂无评论...
验证码 换一张
取 消