275,000++ Articles In MySQL 1.2GB SQL File

Expron · 11-12-2007, 07:09 PM

I purchased a full database. The database is informational & covers a lot of general topics. From cars to home & garden.. Etc..

The problem is that I can't import the database into phpmyadmin.

The .sql file is 1.2GB in size after uncompressing the file.

When I try to open it or import it into phpmyadmin, it just freezes up my computer. I've let it run for days & my computer just gets really slow & freezes for days. Looking at the database, it's still empty.

I'm willing to share this database for free - if someone has suggestions on how to do this. I know it can be done via phpmyadmin but I am doing something wrong.

Don · 11-12-2007, 07:22 PM

http://www.ozerov.de/bigdump.php

Should eat it right up.

stscac · 11-12-2007, 09:08 PM

Originally Posted by greatdomainz

http://www.ozerov.de/bigdump.php

Should eat it right up.

Great Link

-Steve

Expron · 11-12-2007, 10:06 PM

Thanks for the link. I will be trying it soon! Exactly what I needed.

neroux · 11-13-2007, 03:07 AM

The best way would be to upload the compressed data to your server and import it via the shell.

stscac · 11-13-2007, 04:41 PM

Originally Posted by greatdomainz

http://www.ozerov.de/bigdump.php

Should eat it right up.

Tried out this tool tonight and it is FANTASTIC

Originally Posted by neroux

The best way would be to upload the compressed data to your server and import it via the shell.

This would be the alternate way. This is what I've done in the past, and it works well. But when one doesn't know the command line, or just wants an interface, Big Dump is the way to go.
????: NamePros.com http://www.namepros.com/programming/395181-275-000-articles-mysql-1-2gb.html

-Steve

Peter · 11-13-2007, 05:30 PM

1 problem with using the command line for restoring databases is that it is much more pedantic with what commands work and which will not. Files that will quite happily succeed in phpmyadmin can quite as easily fail on the command line.

wikes82 · 11-15-2007, 01:58 PM

great tool, though I prefer compressing the files, then ftp-ing or scp-ing to server, then ssh to server, extract the file, mysql -u username -p dbname < dumpfile.sql

11-12-2007, 07:09 PM	THREAD STARTER #1 (permalink)
Expron Senior Member Join Date: Sep 2007 Location: Chicago, IL USA Posts: 677	275,000++ Articles In MySQL 1.2GB SQL File I purchased a full database. The database is informational & covers a lot of general topics. From cars to home & garden.. Etc.. The problem is that I can't import the database into phpmyadmin. The .sql file is 1.2GB in size after uncompressing the file. When I try to open it or import it into phpmyadmin, it just freezes up my computer. I've let it run for days & my computer just gets really slow & freezes for days. Looking at the database, it's still empty. I'm willing to share this database for free - if someone has suggestions on how to do this. I know it can be done via phpmyadmin but I am doing something wrong. __________________ ****** DropKing.com Drop Catching - Software **** DNMeter Domain drop order with drop times. Domain Afterlife My Drop Catching Blog!**

11-12-2007, 07:22 PM	#2 (permalink)
Don Live Chat Operator Join Date: Jun 2005 Location: NY Posts: 932	http://www.ozerov.de/bigdump.php Should eat it right up. __________________ ` ... .

11-12-2007, 10:06 PM	THREAD STARTER #4 (permalink)
Expron Senior Member Join Date: Sep 2007 Location: Chicago, IL USA Posts: 677	Thanks for the link. I will be trying it soon! Exactly what I needed. __________________ ****** DropKing.com Drop Catching - Software **** DNMeter Domain drop order with drop times. Domain Afterlife My Drop Catching Blog!**

11-13-2007, 03:07 AM	#5 (permalink)
neroux NamePros Regular Join Date: Oct 2006 Posts: 963	The best way would be to upload the compressed data to your server and import it via the shell. __________________ Paris loves CityPics -- Do not let others be treated this way!

11-13-2007, 05:30 PM	#7 (permalink)
Peter NamePros Expert Join Date: Nov 2003 Location: Scotland Posts: 5,069	1 problem with using the command line for restoring databases is that it is much more pedantic with what commands work and which will not. Files that will quite happily succeed in phpmyadmin can quite as easily fail on the command line. __________________ Manage your portfolio using my new Domain Portfolio Management script. Securing Your Domain Name From Theft

11-15-2007, 01:58 PM	#8 (permalink)
wikes82 NamePros Regular Join Date: Sep 2006 Location: K-R.NET Posts: 902	great tool, though I prefer compressing the files, then ftp-ing or scp-ing to server, then ssh to server, extract the file, mysql -u username -p dbname < dumpfile.sql __________________ LogicBoxes/Directi/Resell.biz Domain Catcher for Windows,Linux,Mac OSX

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)