I have a 1Gb database and want to extract the contents. I lost a hosting account when I tried to do it online :-( "using more than 10% of server resources for 15 seconds" and I was out. I need the contents of this database put into a folder on my desktop - there are 250,000 articles to be extracted. I am overloaded with apache server, mysql server, information. I just want the contents in a form that I can use - not 1,000 Megabytes of .sql file. Surely they can be opened with some desktop program - I have 3 mysql servers running on my machine and I cant get "into" any of them to even find out how to load stuff let alone extract it. After searching for days to find a solution I throw myself on your mercy. Thanks in advance for any help suggested.
one gb of sql file extracting would be real hard task, your best option is to install sokkit with mysql try and import your db. after that extract partial tables. That is the best option, I can see right now.
Thanks for the replies guys ;-) I have been searching on here and someone else had the same problem and the good people of this forum offered loads of advice lol. I am just trying a few thing so if anyone has new ideas please post them - all gratefully received I can assure you. This turned out to be a royal PITA. Thanks again.