Data base installation

Posted: Tue Nov 29, 2005 8:45 pm

I downloaded the 76 distro today and have now run the BigDump loader in INSTALLATION three times. It doesn't load any tables past 74 ( nuke_nsnst_ip2country ).

Any hints please?

Posted: Tue Nov 29, 2005 9:39 pm

Lateron, are you getting any error messages from BigDump or is it looking like it completes everything. You should get a message at the end of it saying that it has completed through the end of the file. Also, when it is cycling through its "batches" of inserts, does it halt on the last one for a very long time?

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

Maybe I will separate them (again) as originally distributed. Make sure that your MySQL max_queries is set to 0 if you control that. If not, BigDump should be handling this.

Posted: Tue Nov 29, 2005 9:52 pm

Raven wrote:

Maybe I will separate them (again) as originally distributed. Make sure that your MySQL max_queries is set to 0 if you control that. If not, BigDump should be handling this.

I hadn't taken the time to look. I wasn't sure if BigDump was breaking apart by table or by actual physical records. That could also make a difference... maybe. Depending on the error or behaviour, I thought it might point us in the right direction.

Posted: Tue Nov 29, 2005 9:55 pm

He breaks apart by records.

Posted: Tue Nov 29, 2005 10:06 pm

It starts the 5001 part, does something for a few minutes then I get a browser done msg (firefox) and then that's it.

Posted: Tue Nov 29, 2005 10:09 pm

Did you check the max_queries value?

Posted: Tue Nov 29, 2005 10:13 pm

I am using hosting, I don't have any control over that do I, Gaylen?

Ron ...

Posted: Tue Nov 29, 2005 10:37 pm

I am also creating a second phpNuke site today using this distro, and the same thing just happened: only created the first 74 tables.

Posted: Tue Nov 29, 2005 10:43 pm

Bigdump is set to restart after every 5000 queries. Are you running Apache or IIS? And, what version of PHP?

Posted: Tue Nov 29, 2005 10:46 pm

Apache version 1.3.34 (Unix)
MySQL version 4.1.13-standard
PHP version 4.4.1

Posted: Tue Nov 29, 2005 10:50 pm

MySQL version 4.1.13-standard - BINGO!

That's not compatible. That is still not production release.

Posted: Tue Nov 29, 2005 10:51 pm

So does that mean I can't install this distro?

Posted: Tue Nov 29, 2005 10:54 pm

So, do this. Unpack the tar.gz file to your local PC. Using a good text editor, cut the INSERT statements for the IP2COUNTRY table and save them to a file of their own. Then, save the edited (smaller) unpacked sql file. Using phpMyAdmin, load that sql file into your database. Then, once your base nuke tables are loaded, use phpMyAdmin and load the INSERT statements at a rate of maybe 8000 at a time.

Posted: Tue Nov 29, 2005 10:55 pm

Thanks, Raven.

Cheers,
Ron ....

Posted: Tue Nov 29, 2005 10:55 pm

I'll try to figure out what the issue is with 4.1. But, not right away.

Posted: Wed Nov 30, 2005 1:09 pm

I read in the BigDump instructions that it works better with unpacked file as it has to unzip it at the start of each sequence (in this case 5000).

So I uploaded an unzipped version of the sql file and this time it got to the start of sequence 30001 before it stopped.

The size of the database after it stopped is 2mb so it seems it is still stopped by the MySQL size limit.

Anyway it's morning here and I'm off to work without having slept. I had forgotten how much fun phpNuke can be! Razz

PS As for loading the lines a few thousand at a time I stopped after 3 hours realising I was looking at a HUGE amount of time to do that for two databases.

Worker Joined: Oct 05, 2003 Posts: 107 Location: Illinois

Try uploading these one at a time. I broke it down to seven 10000 line files.
[ Only registered users can see links on this board! Get registered or login! ]

Posted: Sat Dec 03, 2005 7:18 pm

Thanks for that! I have slightly rearranged the files and issued the v1.05.00 PATCH files.

Get the PATCH files at [ Only registered users can see links on this board! Get registered or login! ]

Get the full package at [ Only registered users can see links on this board! Get registered or login! ]

Posted: Sun Dec 04, 2005 1:36 am

Thank you Loki and Raven, that worked a treat.

I appreciate the work you put into breaking down the file.

Regards,
Ron ....