Technically Challenged Person Looking to extract data from sql to spreadsheet - GoFuckYourself.com

B.Barnato · 11-02-2012, 12:56 PM

I bought a database that is supposed to be imported to wordpress, however I would like to use the data locally in a spreadsheet.

How do I do this?

The sql file is roughly 7 mb, so too large for online extraction tools.

B.Barnato · 11-02-2012, 01:06 PM

Bump to first page.

Klen · 11-02-2012, 01:08 PM

Did you tried to export with gzip ?

DeletedBlogger · 11-02-2012, 01:08 PM

Not sure, but you could add the DB to phpmyadmin on your server and then export it to excel.

woj · 11-02-2012, 02:04 PM

I can do that for you for a few bucks, icq: 33375924 if you are interested...

B.Barnato · 11-02-2012, 02:12 PM

Quote:

Originally Posted by KlenTelaris

Did you tried to export with gzip ?

Quote:

Originally Posted by DeletedBlogger

Not sure, but you could add the DB to phpmyadmin on your server and then export it to excel.

Thanks for the help, am currently on the move and on my netbook so I was hoping for a simple on the fly solution.

B.Barnato · 11-02-2012, 02:13 PM

Quote:

Originally Posted by woj

I can do that for you for a few bucks, icq: 33375924 if you are interested...

Currently don't have access to my icq. I'll send you a mail to the email in your sig if that is ok.

woj · 11-02-2012, 02:14 PM

Quote:

Originally Posted by B.Barnato

Currently don't have access to my icq. I'll send you a mail to the email in your sig if that is ok.

sure, woj at wojfun dot com

Klen · 11-02-2012, 02:30 PM

Quote:

Originally Posted by B.Barnato

Thanks for the help, am currently on the move and on my netbook so I was hoping for a simple on the fly solution.

That is actually "simple on fly solution".I assume you tried to export with phpmyadmin,and then browser timeout due to too big size.There is in footer of phpmyadmin option for gzip export,which reduce size of database around 90% and then you can easily get db export since then size will be like 1 mb or even less.When you download you will need to extract archive with some archiver and that's it.Also,even in case if gzipped database is still toobig(but highly unlikely)you can still download by simply changing a setting in php.ini which will allow browser to load longer before it timeout.

sarettah · 11-02-2012, 02:33 PM

Quote:

Originally Posted by KlenTelaris

That is actually "simple on fly solution".I assume you tried to export with phpmyadmin,and then browser timeout due to too big size.There is in footer of phpmyadmin option for gzip export,which reduce size of database around 90% and then you can easily get db export since then size will be like 1 mb or even less.When you download you will need to extract archive with some archiver and that's it.Also,even in case if gzipped database is still toobig(but highly unlikely)you can still download by simply changing a setting in php.ini which will allow browser to load longer before it timeout.

Actually it sounds like he does not have the data in a database yet and he is trying to do this with the .sql file that would be used for importing. (I am sure Bbarnato will correct me on that if I am wrong).

Simple enough parse operation getting it from that into a .csv or excel format.

WOJ will take care of it, I am sure.

BB, I tried to icq you earlier, nothing important but I now see you don't have icq on your spare computer so I will not expect a response anytime soon ;p

.

Vapid - BANNED FOR LIFE · 11-02-2012, 02:39 PM

Do you know what new line characters and delimiters are?

Use phpmyadmin to import it as .sql and export it as .csv.

11-02-2012, 12:56 PM	#1
B.Barnato So Fucking Banned Industry Role: Join Date: Nov 2010 Posts: 3,618	Technically Challenged Person Looking to extract data from sql to spreadsheet I bought a database that is supposed to be imported to wordpress, however I would like to use the data locally in a spreadsheet. How do I do this? The sql file is roughly 7 mb, so too large for online extraction tools. Last edited by B.Barnato; 11-02-2012 at 12:58 PM..

11-02-2012, 01:08 PM	#3
Klen Industry Role: Join Date: Aug 2006 Location: Little Vienna Posts: 32,235	Did you tried to export with gzip ? Last edited by Klen; 11-02-2012 at 01:09 PM..

11-02-2012, 01:08 PM	#4
DeletedBlogger Registered User Industry Role: Join Date: Oct 2012 Posts: 74	Not sure, but you could add the DB to phpmyadmin on your server and then export it to excel. Last edited by DeletedBlogger; 11-02-2012 at 01:08 PM.. Reason: Got beat by above!

11-02-2012, 02:04 PM	#5
woj <&(©¿©)&> Industry Role: Join Date: Jul 2002 Location: Chicago Posts: 47,882	I can do that for you for a few bucks, icq: 33375924 if you are interested... __________________ Custom Software Development, email: woj#at#wojfun#.#com to discuss details or skype: wojl2000 or gchat: wojfun or telegram: wojl2000 Affiliate program tools: Hosted Galleries Manager Banner Manager Video Manager Wordpress Affiliate Plugin Pic/Movie of the Day Fansign Generator Zip Manager

11-02-2012, 01:06 PM	#2
B.Barnato So Fucking Banned Industry Role: Join Date: Nov 2010 Posts: 3,618	Bump to first page.

11-02-2012, 02:39 PM	#11
Vapid - BANNED FOR LIFE Barterer Industry Role: Join Date: Aug 2004 Posts: 4,864	Do you know what new line characters and delimiters are? Use phpmyadmin to import it as .sql and export it as .csv.