How to import multiple tables using Phpmyadmin

Have you got a whole bunch on individual tables and need to import them using phpmyadmin? Rather than importing them one by one, all you need to do is:

  • Concatenate the files running the following command in Linux:

cat *.sql > filename.sql

  • Now import your single ‘filename.sql’ using phpmyadmin – simple!

Update

Your sql file will probably be pretty big! To make life easier why not archive it before uploading to Phpmyadmin? Try running this command first:

gzip filename.sql

Leave a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Scroll to Top