Its true, don’t waste your time with strange scripts and such if you’re trying to upload an .sql file that exceeds the limit. Just give up and use source. Note: don’t be confused that I don’t capitalise my MySQL commands. Its my silent protest against standard MySQL syntax: I think capitalising commands you have to type over and over is dumb. SOURCE is the same as source.
- Upload the .sql file to your server somewhere, preferably with lftp
- ssh to your server:
$ ssh username@username.hostname.com - Start mysql:
$ mysql -u username -p password - Find the correct table:
$ show databases; - Access the database you want to import to:
$ use databasename; - And finally the source command:
$ source path/to/filename.sql
I used several sources for this, but John Andrews was the angriest.