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 3:34 pm Reply with quote

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

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

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?
 
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:37 pm Reply with quote

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.

_________________
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
gregexp
PostPosted: Sun Sep 10, 2006 3:44 pm Reply with quote

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

lol.. yeah. I hear you there. It is so hard to work with.
 
jaded
PostPosted: Sun Sep 10, 2006 3:52 pm Reply with quote

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

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?
 
gregexp
PostPosted: Sun Sep 10, 2006 5:41 pm Reply with quote

It connects to the same database as the site itself. Using config.php And a little recode can repair that problem.
 
gregexp
PostPosted: Sun Sep 10, 2006 5:42 pm Reply with quote

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?
 
jaded
PostPosted: Sun Sep 10, 2006 5:54 pm Reply with quote

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

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.
 
Raven
Site Admin/Owner


Joined: Aug 27, 2002
Posts: 17086

PostPosted: Sun Sep 10, 2006 7:21 pm Reply with quote

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

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.
 
Raven
PostPosted: Sun Sep 10, 2006 8:07 pm Reply with quote

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?
 
jaded
PostPosted: Sun Sep 10, 2006 8:16 pm Reply with quote

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!
 
hitwalker
Sells PC To Pay For Divorce


Joined:
Posts: 5661

PostPosted: Mon Sep 11, 2006 1:09 am Reply with quote

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..
 
View user's profile Send private message
jaded
PostPosted: Mon Sep 11, 2006 6:08 am Reply with quote

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.
 
hitwalker
PostPosted: Mon Sep 11, 2006 7:11 am Reply with quote

yeah he's getting funny now...

he replied with...

Quote:
read this... Only registered users can see links on this board! Get registered or login!
or ask me for support service...



so i maild him back....
i expected a more helpfull reply...
 
jaded
PostPosted: Mon Sep 11, 2006 7:14 am Reply with quote

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.
 
hitwalker
PostPosted: Mon Sep 11, 2006 7:20 am Reply with quote

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
 
jaded
PostPosted: Mon Sep 11, 2006 7:25 am Reply with quote

Razz 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.
 
hitwalker
PostPosted: Mon Sep 11, 2006 8:27 am Reply with quote

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
 
jaded
PostPosted: Mon Sep 11, 2006 8:33 am Reply with quote

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
 
hitwalker
PostPosted: Mon Sep 11, 2006 9:21 am Reply with quote

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
 
jaded
PostPosted: Mon Sep 11, 2006 9:29 am Reply with quote

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