Splitting a SQL insert from PHPmyAdmin to Adminer

Question

I am trying to move my database to another server.

My Adminer has a 2MB SQL max dump (upload) limit.
I currently have one table that is about 10MB big.

I was wondering what approaches I can take to split this 10MB table (or modify the dump file) in order to import it via Adminer.

Answer 1

There are following options:

• Upload the file by FTP as adminer.sql (or adminer.sql.gz) and then run it from server.
• Gzip or Bzip2 the file - maybe it can squeeze in 2 MB.
• Increase the PHP limit - upload_max_filesize and post_max_size.
• Export the table by parts - limit the result set and export it from select.