Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> Post Installation Help
Author Message
jaded
Theme Guru


Joined: Nov 01, 2003
Posts: 1006

PostPosted: Sun Sep 10, 2006 12:38 pm Reply with quote

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.

_________________
Themes BB Skins Only registered users can see links on this board! Get registered or login!
Graphic Tees Only registered users can see links on this board! Get registered or login!
Paranormal Tees Only registered users can see links on this board! Get registered or login!
Ghost Stories & More Only registered users can see links on this board! Get registered or login! 
View user's profile Send private message Visit poster's website
hitwalker
Sells PC To Pay For Divorce


Joined:
Posts: 5661

PostPosted: Sun Sep 10, 2006 1:07 pm Reply with quote

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...
 
View user's profile Send private message
jaded
PostPosted: Sun Sep 10, 2006 1:18 pm Reply with quote

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.
 
hitwalker
PostPosted: Sun Sep 10, 2006 1:28 pm Reply with quote

But is this for real jaded....8 gigabite ?
 
jaded
PostPosted: Sun Sep 10, 2006 1:34 pm Reply with quote

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 Only registered users can see links on this board! Get registered or login! Confused
 
hitwalker
PostPosted: Sun Sep 10, 2006 1:41 pm Reply with quote

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..
 
jaded
PostPosted: Sun Sep 10, 2006 1:50 pm Reply with quote

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.
Only registered users can see links on this board! Get registered or login!
 
hitwalker
PostPosted: Sun Sep 10, 2006 1:52 pm Reply with quote

well it wouldnt hurt to send a pm to raven to...
 
jaded
PostPosted: Sun Sep 10, 2006 1:56 pm Reply with quote

Yes, I did that on yahoo. He is away right now. I am going to drop him this link as well.
 
hitwalker
PostPosted: Sun Sep 10, 2006 2:01 pm Reply with quote

well i called the author and maild him to.....
 
jaded
PostPosted: Sun Sep 10, 2006 2:03 pm Reply with quote

Thank you so much hit. I really appreciate that.
 
hitwalker
PostPosted: Sun Sep 10, 2006 2:46 pm Reply with quote

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...
 
Guardian2003
Site Admin


Joined: Aug 28, 2003
Posts: 6793
Location: Ha Noi, Viet Nam

PostPosted: Sun Sep 10, 2006 2:50 pm Reply with quote

Notepad++ should open it without any problems.
 
View user's profile Send private message Send e-mail
hitwalker
PostPosted: Sun Sep 10, 2006 2:52 pm Reply with quote

lol..huh..a file of 8 gigabite guardian..?
your computer will completely freez..
 
Guardian2003
PostPosted: Sun Sep 10, 2006 3:05 pm Reply with quote

8 Gig? Wow, sorry I thought it was 8Meg oops - must read more carefully Wink
 
hitwalker
PostPosted: Sun Sep 10, 2006 3:06 pm Reply with quote

have a beer Smile
 
jaded
PostPosted: Sun Sep 10, 2006 3:07 pm Reply with quote

thank you so much!! I will check my pm now!
 
hitwalker
PostPosted: Sun Sep 10, 2006 3:12 pm Reply with quote

send jaded.....
good luck... Wink
 
jaded
PostPosted: Sun Sep 10, 2006 3:13 pm Reply with quote

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.
 
hitwalker
PostPosted: Sun Sep 10, 2006 3:17 pm Reply with quote

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.
 
jaded
PostPosted: Sun Sep 10, 2006 3:23 pm Reply with quote

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)
 
hitwalker
PostPosted: Sun Sep 10, 2006 3:28 pm Reply with quote

ah i see,well it was a big beta..
i maild him...
we have to wait for reply..
 
jaded
PostPosted: Sun Sep 10, 2006 3:29 pm Reply with quote

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.
 
gregexp
The Mouse Is Extension Of Arm


Joined: Feb 21, 2006
Posts: 1497
Location: In front of a screen....HELP! lol

PostPosted: Sun Sep 10, 2006 3:30 pm Reply with quote

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. Only registered users can see links on this board! Get registered or login!

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.

_________________
For those who stand shall NEVER fall and those who fall shall RISE once more!! 
View user's profile Send private message Send e-mail Visit poster's website AIM Address Yahoo Messenger MSN Messenger ICQ Number
jaded
PostPosted: Sun Sep 10, 2006 3:31 pm Reply with quote

okay, thank you. Let me try this out!
 
Display posts from previous:       
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> Post Installation Help

View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©