Best IT Recipes

Duplicate phpMyAdmin table

Is there a way to get phpMyAdmin to spit out the SQL needed to duplicate a table in another database?

I saved it when I initially made the table, but since then I changed it a little. This is a pretty big table and it really helps.

+44
database php phpmyadmin
Nov 03
source share
2 answers

Yes, you can go to the desired table, and then go to (tab) Operations> Copy the table to (database.table) :, which is a field on the right side. There you can determine in which database and under what name you want to copy the table. By doing this, you get the SQL "spat out."

Since I'm not quite sure about your question, if you want to have a table in the dump file, you can also click the Export tab, where you can also get SQL, or download the dump file right now.

+74
Nov 03 '12 at 15:25
source share

You can use the Export tab to select which table to export. In the chart below

  • album table indicated
  • Checked structure
  • No data marked - not to generate data with export
  • SQL radio disabled
  • ...
  • Click the Go button below to create the generated SQL

enter image description here

+2
Nov 03 '12 at 15:33
source share


More articles:


All Articles