开发者

Exporting entire table structure, but data ONLY from certain tables via phpMyAdmin

I have access to phpMyAdmin, but NOT the MySQL command line.

I need to recreate the table structure elsewhere along with certain tables that need to be 'pre-populated'. I can, of course, export the empty table structure and then export 开发者_StackOverflowthe tables one-by-one, but is there a better way to export a bunch of table data together?


If you click on the database name at the top left and then click the Export tab you can select which tables you want to export at the left. You will still do 2 exports, first for all the structures, and then a second one for the data with only the tables that you need.

0

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜