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