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

Expron · 11-12-2007, 06: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, 06:22 PM

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

Should eat it right up.

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

Quote:

Originally Posted by greatdomainz

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

Should eat it right up.

Great Link

-Steve

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

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

neroux · 11-13-2007, 02: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, 03:41 PM

Quote:

Originally Posted by greatdomainz

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

Should eat it right up.

Tried out this tool tonight and it is FANTASTIC

Quote:

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.

-Steve

Peter · 11-13-2007, 04: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, 12: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, 06:09 PM	#1 (permalink)
Expron Senior Member Join Date: Sep 2007 Location: Chicago, IL USA Posts: 591 220.00 NP$ (Donate)	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. __________________ Domain Drop Catching Tools - Server & Desktop Based. Expron Solutions - Checkout the drop catching tools!

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

11-12-2007, 09:06 PM	#4 (permalink)
Expron Senior Member Join Date: Sep 2007 Location: Chicago, IL USA Posts: 591 220.00 NP$ (Donate)	Thanks for the link. I will be trying it soon! Exactly what I needed. __________________ Domain Drop Catching Tools - Server & Desktop Based. Expron Solutions - Checkout the drop catching tools!

11-13-2007, 02:07 AM	#5 (permalink)
neroux NamePros Regular Join Date: Oct 2006 Posts: 918 40.00 NP$ (Donate)	The best way would be to upload the compressed data to your server and import it via the shell. __________________ Paris loves CityPics muov.com • qeww.com • sejz.com • viuo.com • vuav.com • wzeo.com • xeib.com • xueo.com -- Do not let others be treated this way!

11-13-2007, 04:30 PM	#7 (permalink)
Peter Senior Member Join Date: Nov 2003 Location: Scotland Posts: 4,900 0.60 NP$ (Donate)	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, 12:58 PM	#8 (permalink)
wikes82 NamePros Regular Join Date: Sep 2006 Location: K-R.NET Posts: 870 1,842.48 NP$ (Donate)	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 __________________ #include <signature.h> ■ Dictionary ■ Stand Up to Cancer ■ ■ :cool: Accepting offer : FUYP.COM - HOYV.COM - OWKZ.COM :cool: ■

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

NamePros Chat Operator