database restore help needed

Theme Guru Joined: Nov 01, 2003 Posts: 1006

I am attempting to restore the database on a website that was hacked. The database is enormous at over 8gb. I clearly cannot open that database to extract info from it. The volume is too large.

I have decided it would be best to just load it into a new database. I am using bigdump to do this. My issue is this. The dump fails at about the 8th table. There is a mysql error in the table. I cannot open this file to edit it or fix it.

My question is as follows.

Does anyone have any ideas on how to make the import not stop at error? Perhaps a way to tell it to continue past the error.

Does anyone know of a different way to do this import?

I really need to find a way to get this done.

Thank you in advance for any help with this.

Sells PC To Pay For Divorce Joined: Posts: 5661

hi jaded...
how is it backed up ?
Not as 1 dump i hope...
any chance you can start making backups with selected and shorter tables ?
in that way maybe you can backup the table in question and edit it seperately...

Posted: Sun Sep 10, 2006 1:18 pm

hi, yes, sadly he only had it backed up as 1 file. There is no way to make any smaller backups now because most of his database was destroyed. I am stuck with this one large file. Which really wouldnt be a bad thing if it didnt have any errrors. Bigdump would load it. However, the moment the error occurs it stops.

Posted: Sun Sep 10, 2006 1:28 pm

But is this for real jaded....8 gigabite ?

Posted: Sun Sep 10, 2006 1:34 pm

yes, it is. It is the largest thing that I have ever seen. it took about 10 hours to upload it to bigdump in his ftp. Confused

Posted: Sun Sep 10, 2006 1:41 pm

and your still able to upload ?
wauw...that takes some time...

But i think it would be a problem....
only way to solve this is if the bigdump would be altered to skip the error.
ive already called the german author but he's not at home at this moment...
hope he could give an advice on this.

other solution would be if the main host puts the dump in.
as far as i know of if you create a backup with a mysql error in it the main host should be able to put it back without any problems..

Posted: Sun Sep 10, 2006 1:50 pm

I appreciate that hit, If the bigdump could skip that would be ideal. Hopefully you will hear back from him.

As far as the host unfortunatly the host is just some girl who got a server but does not know how to do anything with it. She doesnt know how to restore it. It is a huge MESS! I have told him before ,you get what you pay for.

Therefore, I really hope that bigdump can be altered to skip errors.

Here is a link to the download in case anyone wants to try to alter it for me.

http://www.ozerov.de/bigdump.php

Posted: Sun Sep 10, 2006 1:52 pm

well it wouldnt hurt to send a pm to raven to...

Posted: Sun Sep 10, 2006 1:56 pm

Yes, I did that on yahoo. He is away right now. I am going to drop him this link as well.

Posted: Sun Sep 10, 2006 2:01 pm

well i called the author and maild him to.....

Posted: Sun Sep 10, 2006 2:03 pm

Thank you so much hit. I really appreciate that.

Posted: Sun Sep 10, 2006 2:46 pm

hi jaded...

i guess i did it again....
hethe author just maild me and sen a altered version that as he says :

It should ignore mySQL errors and produce an error log file. I have never prooved if it really works. Feel free to test and report.

so good news or what !

Ok....send a pm with your email address where i can send it to...
and ill cross my fingers...

Posted: Sun Sep 10, 2006 2:50 pm

Notepad++ should open it without any problems.

Posted: Sun Sep 10, 2006 2:52 pm

lol..huh..a file of 8 gigabite guardian..?
your computer will completely freez..

Posted: Sun Sep 10, 2006 3:05 pm

8 Gig? Wow, sorry I thought it was 8Meg oops - must read more carefully Wink

Posted: Sun Sep 10, 2006 3:06 pm

have a beer Smile

Posted: Sun Sep 10, 2006 3:07 pm

thank you so much!! I will check my pm now!

Posted: Sun Sep 10, 2006 3:12 pm

send jaded.....
good luck... Wink

Posted: Sun Sep 10, 2006 3:13 pm

thank you. I will report back the results. I have never understood why someone would let their database reach this size. It makes it virtually impossible to work with. I will be once again stressing to him the importance of proper maintainance.

Posted: Sun Sep 10, 2006 3:17 pm

well it happens more then you think...
usualy good running sites with some heavy traffic and sometimes run by people with litle knowledge..
but they wake up when they go on their face..and hopefully learn from it.

Posted: Sun Sep 10, 2006 3:23 pm

hmm, it failed again on the same spot.
Is there anything that I need to alter in the file to make it skip and make the error log? Perhaps you could reach out to him again. I dont know of any other options unfortunatly.
Thanks again!!

Error at the line 21383: ) TYPE=MyISAM;

Query: CREATE TABLE nuke_bbarcade_fav ( order mediumint( Cool

NOT NULL default '0', user_id mediumint( Cool

NOT NULL default '0', game_id mediumint( Cool

NOT NULL default '0' ) TYPE=MyISAM;

MySQL: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'order mediumint( Cool

NOT NULL default '0', user_id mediumint( Cool

Stopped on error

Start from the beginning (DROP the old tables before restarting)

Posted: Sun Sep 10, 2006 3:28 pm

ah i see,well it was a big beta..
i maild him...
we have to wait for reply..

Posted: Sun Sep 10, 2006 3:29 pm

thank you. I hope that he can help to make it work. You have been a great help to me with this. Thank you hit.

Posted: Sun Sep 10, 2006 3:30 pm

Jaded, I couldnt respond any earlier so I thought Id jump in to help, I hope hitwalker has some good news but Ive made something for you to try.
http://darklords-lair.com/dl/query.zip.

It will echo the query that failed but it will continue as well. Ive tested it on a windows and linux, Its extremely simple but took me a second to make. Have at it.

Upload the file via ftp, Then put that script in the same directory as config.php. then enter the name of the file relative to the scripts postion. It will Grab the contents and run each line as a query, It will echo the contents of the querys that fail so Im sure you can fix em after you see em, but ONLY the ones that fail.

Posted: Sun Sep 10, 2006 3:31 pm

okay, thank you. Let me try this out!