Technically Challenged Person Looking to extract data from sql to spreadsheet

[B.Barnato]

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]

Bump to first page.

[Klen]

Did you tried to export with gzip ?

[DeletedBlogger]

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

[woj]

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

[B.Barnato]

Did you tried to export with gzip ?

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]

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]

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]

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]

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]

Do you know what new line characters and delimiters are?

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