The Snarkpit
login register search
Say hi to our newest member, QuartzRaven!
Home Maps Articles Downloads Forums Links

For all you php / sql knowledge folks

For all you php / sql knowledge folks

Re: For all you php / sql knowledge folks Posted by xconspirisist on Fri Jan 21st 2005 at 12:22am
xconspirisist
307 posts
Posted 2005-01-21 12:22am
Post #70314
xconspirisist
member
307 posts 81 snarkmarks Registered: Feb 26th 2003 Occupation: Student Location: UK
sorry to mirror threads, but my site is going to die without a rather rapid response ...

http://www.linuxquestions.org/questions/showthread.php?s=&threadid=280285

arg, please help...
Re: For all you php / sql knowledge folks Posted by Leperous on Fri Jan 21st 2005 at 1:37am
Leperous
3382 posts
Posted 2005-01-21 1:37am
Post #70328
Leperous
Creator of SnarkPit!
member
3382 posts 1635 snarkmarks Registered: Aug 21st 2001 Occupation: Lazy student Location: UK
3.8mb?! Hah, this site's is around 80mb.

The solution is to chop up your SQL query and feed it bit by bit- cut and paste large parts of the query at a time, instead of trying the whole thing at once.

Or of course you could upload the script and make a PHP script that runs it from localhost...
Re: For all you php / sql knowledge folks Posted by xconspirisist on Fri Jan 21st 2005 at 2:36pm
xconspirisist
307 posts
Posted 2005-01-21 2:36pm
Post #70429
xconspirisist
member
307 posts 81 snarkmarks Registered: Feb 26th 2003 Occupation: Student Location: UK
Ive been trying to hack apart some of the phpbb code, it is capable of processing massive sql backup files.

3.8 megs, in 1 month, with only 14 users, and only forums. :smile:
Re: For all you php / sql knowledge folks Posted by Fluke on Fri Jan 21st 2005 at 10:56pm
Fluke
18 posts
Posted 2005-01-21 10:56pm
Post #70576
Fluke
member
18 posts 12 snarkmarks Registered: Jan 12th 2005 Occupation: Networking Location: Canada
My Faceoff site was near 400MB and continued to grow. Had 1500 unique members in less than 1 month. Feature, file uploading and downloading, mirroring direct server map downloaded from the #1 source today for all map download, especially UT. I had personally galleries, built in IRC and a features that were continually implemented. Anyone that know PnPhpbb 2 knows what I mean.

I specifically use to this phpmyadmin for db stuff, very easy to use and its free http://sourceforge.net/projects/phpmyadmin/ also your php.ini file what have you has to be configured correctly too. Don't use PHP 5, I don't find it works very well myself and it's also new and probably risk of attacks. I still use 4.x
Re: For all you php / sql knowledge folks Posted by Joe-Bob on Fri Jan 21st 2005 at 10:59pm
Joe-Bob
180 posts
Posted 2005-01-21 10:59pm
Post #70578
Joe-Bob
member
180 posts 77 snarkmarks Registered: Dec 3rd 2004
Fluke said:
I don't find it works very well myself and it's also new and probably risk of attacks. I still use 4.x
Security sites are your friends. For example, Packet Storm
Re: For all you php / sql knowledge folks Posted by fraggard on Sat Jan 22nd 2005 at 4:42pm
fraggard
1110 posts
Posted 2005-01-22 4:42pm
Post #70829
fraggard
member
1110 posts 220 snarkmarks Registered: Jul 8th 2002 Occupation: Student Location: Bangalore, India
xcon, if you have the database mirrored on a local sqlserver on your
machine, I think the simplest thing to do will be to dump your data one
table at a time. Sequential filenames would be best. If you're running
Linux (and I assume you are, based on what you've posted before), a
simple perl/awk script should be able to automatically dump the tables
into sequential files.

Then run the dumps also one file at a time. A PHP script should be able to do it automatically from a list of files.