Jump to content


Best way to Import multiple tables with PHPMyAdmin

phpmyadmin import export

  • Please log in to reply
1 reply to this topic

#1 davidannis


    Freak Dr.

  • Members
  • PipPipPip
  • 620 posts
  • LocationOkemos, MI USA

Posted 13 July 2014 - 02:41 PM

I have 5 tables that I changed on my development server (laptop) that I'd like to upload to my test server. I can export just those tables from PhpMyAdmin but on import it drops all of the other tables first. Short of editing the SQL before I upload it (finding the drop and deleting it) is there an easy way to uncheck a box and change that behavior that I am just not seeing?

#2 Ch0cu3r


    Advanced Member

  • Moderators
  • 3,223 posts

Posted 13 July 2014 - 03:18 PM

When exporting databases/tables PHPMyAdmin does provide a wide range of options. Make sure you have unchecked any options which could end up truncating/dropping the table on import.

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users