Large Mysql restore file - timeout

[jeroman8]

Hi,

how do I restore a mysql database from a backup file if the file is
over 150 MB ? It just won't do it, it takes forever and then I get a
error of some sort. I guess the file is to big but there must be another
way doing this and not split the files upp in 50 pieces.

Oh, I tried doing this in PHPMyadmin.
Can I do it in SSH or something and if so how ?

Error:
Fatal error: Maximum execution time of 300 seconds exceeded in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/read_dump.lib.php on line 186


Thanks guys !

Regards Jerry

[ChemicalWH]

Hey,

It's pretty easy to restore a MySQL Database in ssh,

just upload the SQL file to the server and run the following command in ssh:

mysql -uUSERNAME -p newdbname < /path/to/dump.sql

Replace the USERNAME, newdbname and the path/to/dump.sql to your own details
it'll ask you for the database password and after filling that in it'll restore the db

Good Luck,

Ruud Goedhart

[damainman]

there is no space between the -u and USERNAME .. is that a typo is that suppose to be like that?

Also for the new database name do I need to create it as username_databasename.sql or username_databasename or just databasename

Thank you in advance

[Silver_2000]

when doing restore from ssh you can make the db name whatever you want BUT if you want it to be accessible from a certain account you will want the accountname in the dbname

No need to put .sql at the end

[AlexV.]

Hi,

how do I restore a mysql database from a backup file if the file is
over 150 MB ? It just won't do it, it takes forever and then I get a
error of some sort. I guess the file is to big but there must be another
way doing this and not split the files upp in 50 pieces.

Oh, I tried doing this in PHPMyadmin.
Can I do it in SSH or something and if so how ?

Error:
Fatal error: Maximum execution time of 300 seconds exceeded in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/read_dump.lib.php on line 186


Thanks guys !

Regards Jerry

Was the mysql dump file compressed? phpMyAdmin should support gzip imports.