By default, most PHP uploaders limit the import file size of a MySQL database to 50MB. You may not always be able to change the limit yourself (depending upon your host) so the alternative way to import the database is to use SSH.

Start by uploading the .sql file onto the server using your regular FTP/FTPS/SFTP client.

Log into the server using SSH and navigate to the directory where your .sql file is.

Run this command:

mysql -p -u username database_name < file.sql

 

Notes:

The -p will prompt for your account’s password.

Replace username, database and file.sql with their appropriate values.