phpMyAdmin Error - Script Timeout

Hello,

I keep getting the following error when uploading a 12mb SQL file into our database:

So I tried to continue uploading it and then i get the following error:

So, I have went into my WHM since it is a VPS and set the upload_max_filesize to 25mb and max_execution_ time to 1000 yet i am still getting the errors. SOmeone please help.

 

Check this:

http://stackoverflow.com/questions/3302476/mysql-1050-error-table-already-exists-when-in-fact-it-does-not

Code (markup):

 

This is not the answer, as it is timing out, the timing out is the issue.

 

Use bigdump or something other than phpmyadmin to import large sql file

 

Sorry,i just see >> #1050 - Table 'wp_commentmeta' already exists
to import large sql files,use "bigdump" or "SQLDumpSplitter2".

 

For large and very large SQL dumps, the best approach is to log in your server via SSH and directly import it in the database by this command line after uploading the file via FTP:

mysql -h localhost -u db_user -p db_name < sql_file.sql

Code (markup):

And enter the db_user password when it prompts you. It will then start importing sql_file.sql into the db_name database.