If you’ve ever tried to use phpMyAdmin to import a large sql database, then you’ve no doubt had fun slicing the file into smaller parts, or changing apache’s request timeout, or …etc…
There’s an easier, and faster way. Just upload the sql file to your server and use mysql from the command line to import the data. It’s as simple as issuing the following command:
mysql -u USER -p DBNAME < dump.sql