How to import a big database when phpmyadmin can't?

[topvip]

if you have SSH access then you can use the following commands to backup / restore databases

mysql -u[Username] -p[Password] [Database Name] < filename.sql - Dump a SQL file into a MySQL database. Note the "<".
Replace "[Username]" with the database username (generally controlpaneluser_databaseuser). Replace "[Password]" with the database password and replace "[Database Name]" with the database name. Finally change "filename.sql" to the correct filename/location.

eq.. to be done from the folder where you want the file to be saved

mysql -umyusername -pmypassword mydatabasename < myfilename.sql

mysql -u[Username] -p[Password] [Database Name] > filename.sql - Dump a MySQL database to a SQL file. Note the ">".
Replace "[Username]" with the database username (generally controlpaneluser_databaseuser). Replace "[Password]" with the database password and replace "[Database Name]" with the database name. Finally change "filename.sql" to the correct filename/location.

eg.. to be done from the folder where the sql file is

mysql -umyusername -pmypassword mydatabasename > myfilename.sql