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

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.

Up vote 1 down vote favorite share g+ share fb share tw.

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 the tables one-by-one, but is there a better way to export a bunch of table data together?

Mysql phpmyadmin link|improve this question asked Oct 26 '10 at 6:48matt74tm601117 81% accept rate.

Oh crap... that was exactly what I needed! Shucks - and it was RIGHT in front of me! – matt74tm Oct 26 '10 at 12:37.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.

Related Questions