Is there some way to get phpMyAdmin to spit out the SQL needed to duplicate the table in another DB?
I saved it when I initially made the table but I've changed it quite a bit since then. It's a pretty big table and this would really help.
To perform the corresponding operations on a database table, you should select the desired table in phpMyAdmin and click on the Operations tab. The Move table to section allows you to move the table with a new name under the current database or to move it under a different database.
Step 1: Install a chrome extension which is called ColumnCopy. Step 2: Enter the following command in the SQL query section in phpmyadmin, and then click go. DESCRIBE "name_of_table"; Step 3: Highlight the word 'field', and then right-click and choose ColumnCopy and then click to copy this column.
Yes, you can navigate to the table you want and then go to (tab) Operations > Copy table to (database.table):, which is a box on the right hand side. There you can define into which database and under what name you'd like to copy your table. After having done than you get the SQL "spat out".
As I'm not completely sure about your question, if you'd like to have the table in a dump file, you could alternatively click the tab Export, where you can get the SQL as well, or download the dump file straight away.
You can use the Export tab to select which table to export. In the diagram below,
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With