Urgent database export question

Hi,

I have a big mysql database.
I want to extract it. There is only 1 row.

I want extract it in this way:
item1,item2,item3,item4.
I tried to use CVS export option in phpmyadmin with option: Fields enclosed by "," but this not suit the job.

Somebody kindly help me
It may be also script which will fwrite content to .txt file...I have no idea.

 

What is 'big'? Many tables? A lot of data?
What do you mean there is only 1 row? You've got only one table with only one record?
Why doesn't the CVS export function suit the job?

I guess what I'm saying is, could you please give some more info?

 

well, its 300 mb database but i've splitted it to parts 10mb each database.
there is 1 table with 450.000 records which i want to import.
I want separate each record with ",".
so i want it exported like that:
record1,record2,record3

 

I may help you on this. Are you going to pay for this? Please let me know.. Thanks

 

fwrite($fileopen, $row['name'] . ',');
did the job.

 

you can use phpmyadmin to export data in a selection of records like from record 1 to 10000


Regards

Alex