MySql Database To Large

[Kat]

@ Bxflow - ya i dont like using phpmyadmin it always fails restoring larger database's
i just thought i would try and see since everything else failed .

[KingOfDCP]

@ Donhopkin - Sorry i did try that .

@ Time - Yep to big for bigdump its the first database i ever come across that is to big for anything and its only 500MB

Now i did try the Mysqldumper and this is one error i got so far

Fatal error: Maximum execution time of 30 seconds exceeded in /inc/functions_files.php on line 460

i was just testing it and using the converting option just to test it out

The database was working perfect when i backed it up .
*confused*

i got a couple more ideas to try and we will see what comes up

Again thank you for the help its much appreciated .

Raise your php timeout config

[Kat]

@ KingOfDCP - That was it right there . just before you posted this i went and found that setting and adjusted it . thinking i already did when i configured a bunch of settings for the vps .

i also took donhopkin's advice and did this mysql -u username -p databasename < database.sql again . i must have did this line 3 times . so after ruffly 3-5 min it was finished this time .

So now thanks to the help i got here its now up and running

Thanks everyone for your help .

now to make a backup with mysqldumper and save it . i do like that program.

Again . Thank you .


Edit : i used mysql -u username -p databasename < database.sql not mysql -u username -p databasename < database.sql.gz or database.gz .

[Lock Down]

For information for you and anyone else in this situation.

mysql -u username -p databasename < database.sql.gz

You can't do zipped file directly into mysql.
first

gunzip database.sql.gz

then

mysql -u username -p databasename < database.sql

then it will work like a charm in a minute or so after you enter your password.

[Kat]

sorry lock down i made a typo . i meant to put on the end sql .

ill fix that .
i was trying to type really fast because i was excited that the @$%#$% database finally went in like it was suppose to with help from all you guys of course


Edit :

i did try this like 5 times before so after doing it once more it worked . thats why i was confused . ive added the database 1000's of times via ssh . this one doesnt have errors or anything .guess its just stubborn lol

[Lock Down]

No problem. Just didn't want any desperate members trying to get that to work.

Nice job of being persistent and getting the job done.

[Kat]

Thank you Lock Down

Usually the db's are not such a pain . they generally go in nice and easy for me .
Just glad its over with .

Again everyone thanks for the help