Jump to content


Photo

Best way to Import multiple tables with PHPMyAdmin

phpmyadmin import export

  • Please log in to reply
1 reply to this topic

#1 davidannis

davidannis

    Freak Dr.

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

Posted 13 July 2014 - 09:41 AM

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

Ch0cu3r

    Advanced Member

  • Moderators
  • 2,145 posts

Posted 13 July 2014 - 10:18 AM

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

Cheap Linux VPS from $5
SSD Storage, 30 day Guarantee
1 TB of BW, 100% Network Uptime

AlphaBit.com