Snarkpit Forum Index » General Banter » For all you php / sql knowledge folks
For all you php / sql knowledge folks
1
Post Reply
Quote
 Re: For all you php / sql knowledge folks
Posted by xconspirisist on Fri Jan 21st at 12:22am 2005

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




Quote
 Re: For all you php / sql knowledge folks
Posted by Leperous on Fri Jan 21st at 1:37am 2005

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





Quote
 Re: For all you php / sql knowledge folks
Posted by xconspirisist on Fri Jan 21st at 2:36pm 2005

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.




Quote
 Re: For all you php / sql knowledge folks
Posted by Fluke on Fri Jan 21st at 10:56pm 2005

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





Quote
 Re: For all you php / sql knowledge folks
Posted by Joe-Bob on Fri Jan 21st at 10:59pm 2005

? quoting Fluke
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




Quote
 Re: For all you php / sql knowledge folks
Posted by fraggard on Sat Jan 22nd at 4:42pm 2005

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.





1
Post Reply