MySql Database To Large

[Kat]

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 .

Kat Reviewed by Kat on 14th Dec 2011. MySql Database To Large 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 PhpMyadmin Bigdump Wget Rating: 5

[bxflow]

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?

[thanhlangso]

you can try with http://www.mysqldumper.net/

[KingOfDCP]

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

[Phozon]

I used to use a tool like this: http://jivstudio.com/2008/11/26/grea...split-utility/

Idk if this is the same one or if it still works. I would do a virus/malware scan on it before using to be safe.

Hope it helps.

[Kat]

@ 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 .

[bxflow]

@ 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 .

phpmyadmin is not really an option as it will most likely time out.

[donhopkin]

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.

[Time]

Too big for Bigdump?

1) Upload via FTP
2) Place in same folder as bigdump
3) Restore from local file

Ta da?

[Kat]

@ 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 .