database restore help needed

Theme Guru Joined: Nov 01, 2003 Posts: 1006

does the sql file have to be in the root with the query.php file?

Posted: Sun Sep 10, 2006 3:37 pm

also, would this have any way of letting me what things failed that it couldnt do so that I can try to manually edit that afterward?

Posted: Sun Sep 10, 2006 3:37 pm

no, if its in folder/sql.txt then type foler/sql.txt, its the path relative to the placement of the script, the script must be in same directory as config.php.

And on failure, it will print the sql code to your browser that failed but only that sql code.

Posted: Sun Sep 10, 2006 3:44 pm

Jaded, also if you still have issues or if something ends up turning out to be Garbage, let me know, I have some resources to open that file up possiby. Thinkin how I think I have a solution but I got no clue how to make a file that large to verify Laughing

One more thing Im sorry to say this but In my testing, I edited the file and zipped it because of the fact that it died on error(I fixed it though). And Forgot to save it.

You may need to grab the script again(I updated the download), Sorry.

Posted: Sun Sep 10, 2006 3:50 pm

lol.. yeah. I hear you there. It is so hard to work with.

Posted: Sun Sep 10, 2006 3:52 pm

it will be nice if hit has some success with the man who made bigdump. That program would be perfect if it allowed the skip option. At any rate, I have yours trying now. I expect it to take a while to complete though.

Posted: Sun Sep 10, 2006 4:00 pm

Fatal error: Maximum execution time of 30 seconds exceeded in /***/public_html/home/query.php on line 29

my other question is this. How does it know which database to put the tables into?

Posted: Sun Sep 10, 2006 5:41 pm

It connects to the same database as the site itself. Using config.php And a little recode can repair that problem.

Posted: Sun Sep 10, 2006 5:42 pm

Hold up a single query is taking 30 seconds to execute:O No coding on the script level can help that shy of trying to change the max time but thats just weird.

Can you ask the host to increase the alotted execution time?

Posted: Sun Sep 10, 2006 5:54 pm

no, his host is not cooperative. Smile

I am going to try once more to load this. Failing that perhaps hit will have some luck with the man who made bigdump. That one doesnt seem to time out due to the way it processes only so many lines at a time.. or something. Yours is very nice and I hope it will work. I have set config.php to go to a blank db now so perhaps it will work. For two days I have been attempting to do this. lol. I am about sick of it.

Posted: Sun Sep 10, 2006 6:00 pm

darn it. It timed out again. I appreciate your effort with this Dark. Perhaps some success will come with a modification of bigdump that allows for skipping bad tables.

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

Can you get a compressed file of the actual MySQL database (not the Insert statements., The .MYD, .MYI, and .frm files? If so, then the host could just drop those into the MySQL data storage without doing any inserts at all.

Is this 8 gig compressed or 8 gig uncompressed?
Are you trying to load to a *nix server or a windoze server?
What version of MySQL created the dump file and what version are you loading to?

Posted: Sun Sep 10, 2006 7:43 pm

no, those files are not available. There is no way to get them now as the db is a mess. Uncompressed now. It is a linux server and the mysql is 4.0.25 I believe. It is the same place that I am trying to restore it to that it came from.

Posted: Sun Sep 10, 2006 8:07 pm

Have you got shell access to the actual MySQL server? If so, this would be easy to fix.

You can use the force option with MySQL to tell it to disregard errors. BigDump could/should be modified to add this option or is that what he already tried?

Posted: Sun Sep 10, 2006 8:16 pm

no, I wish that I did have shell access. I would love that. No, I dont believe that is what he tried with bigdump. He tried to make it so that it would just skip the errors and make a log of them. Is this something that you can look at the bigdump.php file and try to alter for me so that it can work. I am willing to pay you for your time on it. Please let me know. Thanks!

Sells PC To Pay For Divorce Joined: Posts: 5661

jaded i forwarded your reply on the returned error and he said :

Quote:

this mySQL statement is wrong as it uses a registered mySQL word as column name.

i maild him back asking to be more specific what he means by that..

Posted: Mon Sep 11, 2006 6:08 am

Okay, thank you. I have no idea what that means. It stands to reason that somehow this script can be made to move on after errors and produce the error report at the end so that manual fixes can be done. I really hope it can lol.

Posted: Mon Sep 11, 2006 7:11 am

yeah he's getting funny now...

he replied with...

Quote:

read this...
http://dev.mysql.com/doc/refman/5.0/en/reserved-words.html
or ask me for support service...

so i maild him back....
i expected a more helpfull reply...

Posted: Mon Sep 11, 2006 7:14 am

i assume that support service is paid? I dont mind paying for help. I just thought that there might be a simple way for him to edit the script to simply skip all errors and then make a log.

Maybe we have annoyed him with our questions, hit. lol, I hope that you get an informative reply because as it might have something in it that is causing this error, it still has to be able to get past the error to load the rest of the tables since it is uneditable.

Posted: Mon Sep 11, 2006 7:20 am

i thought the same thing....
he created a few settings at the beginning of the file...
you would think an option would be build in to ignore errors...

now he has the chance to create a working version and now suddenly he dont wanna debug it...

ill bet if i told him it was for a lady you would have had it yesterday...
ok my mistake.... killing me

Posted: Mon Sep 11, 2006 7:25 am

perhaps you are right. I hope that he can do that. The script would be more useful to many people if it had that function. Many people have large dump files that end up throwing an error somewhere. The ability to move past that and then fix things at the end is quite needed.

Posted: Mon Sep 11, 2006 8:27 am

ok..he replied again..
this will make you laugh even harder..

he said..

Quote:

it's not a script issue. It's a wrong mySQL statement in your dump file.

Get it Jaded ?

but the script should continue no matter what and ignore the error..
but thats not working.. Confused

Posted: Mon Sep 11, 2006 8:33 am

exactly. I think that he is missing the point. the dump file cannot be edited so the script must have the ability to skip it and move on. (sigh)

no one was saying that the script was the issue causing an error. Perhaps he misunderstood that part. Smile

Posted: Mon Sep 11, 2006 9:21 am

well were still communicating..

his reply "....

Quote:

unfortunately I have never used this version which was created by some
bigdump user.
Normally it should ignore mySQL errors, butnobody knows.
I will have to take a look tonight.
Maybe I will include some ignore mechanism in the official version, but I'm not sure.
The dump must be good.

For example: if you just ignore this create table statement you want be
able to do all the insert statements for the data.
Finally your data will
be completely lost for this table.
Do you really want it?

naturally i said yes.. Laughing

Posted: Mon Sep 11, 2006 9:29 am

yes, at this point, replacing a few tables would be a whole better option then no database. If the error log he mentioned can be made at the end the user can go back in and manually add a few tables. That is a lot better then the current option of no database.

Thank you for continuing to work on this hit. I really do appreciate it.