Latest Announcemnent
New thread

MySql Database To Large

Status
Not open for further replies.
Kat

Kat

Banned
Banned
187
2011
54
0
Hello all ,

Ok ive got a small issue i have a very large database i would say 500MB
so its really hard to upload via
  1. PhpMyadmin
  2. Bigdump
  3. Wget

Now ive gotten it to work before but i have moved servers and the settings are not the same as the last one .

and for the life of me i can not remember what setting it was so it will not time out so easy .

i also have a modded version of bigdump ive modded myself and it worked great on other servers . now this is ment as no offence to my new host because there just F*ckin awsome so far ! . just different settings .

if it helps i am on a VPS for now .

Thanks Guys/Gals for your help .
 
16 comments
I dont think 500MB is that large, I have uploaded 2GB.

Back them up using SSH/GZIP

can you upload it to your server using FTP then use SSH to import it into the database?
 
500MB is just a large database not very or too. My site database is 500MB around and I use mysqldumper to restore after upload it to server
 
@ Bxflow - it has allot of data for being 500mg i have both files gzip and sql sorry i forgot to mention that . both time out . times out in bigdump as well .

@ thanhlangso - thanks ill give that a look :)

@ KingOfDCP - Thanks glad to know that mysqldumper does work i dident know about it

@ Wdemon - Thank you that was another i was trying to think of


Thank you again guys i appreciate the help .
ill give this a try and report back and let ya know how it went .
the database is just fulllll of info even tho its only 500mg its just overloaded with data .

=)











Weird question .. Could it be because of the browser . altho i did use IE and Chrome .
 
Kat said:
@ Bxflow - it has allot of data for being 500mg i have both files gzip and sql sorry i forgot to mention that . both time out . times out in bigdump as well .

@ thanhlangso - thanks ill give that a look :)

@ KingOfDCP - Thanks glad to know that mysqldumper does work i dident know about it

@ Wdemon - Thank you that was another i was trying to think of


Thank you again guys i appreciate the help .
ill give this a try and report back and let ya know how it went .
the database is just fulllll of info even tho its only 500mg its just overloaded with data .

=)











Weird question .. Could it be because of the browser . altho i did use IE and Chrome .
Click to expand...

phpmyadmin is not really an option as it will most likely time out.
 
Upload it via FTP and then use mysql via command to dump that in a database
i think it goes like mysql -u username -p databasename < database.sql.gz
Not a command guru so check/google for the correct command.
 
@ 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 .
 
@ 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 .
 
Kat said:
@ 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 .
Click to expand...

Raise your php timeout config
 
@ 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 .
 
Last edited:
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
 
Last edited:
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 :)
 
Status
Not open for further replies.
Back
Top