Why is our 1000 MB database file not uploading completely via phpMyAdmin?
Try this

For Export:

mysqldump -u [user] -p [db_name] | gzip &gt; [filename_to_compress.sql.gz] 


For Import:

gunzip &lt; [compressed_filename.sql.gz]  | mysql -u [user] -p[password] [databasename] 


Note: There is no space between the keyword '-p' and your password.