Export SQL to one cvs file?

Hi, when I go to myphpadmin, I can export the top-level file into cvs. If I export as all one file, cvs, I only get part of the information. If I export each sub-level sheet separately, there are no identifying marker (ID) that allows me to merge all the sheets today.

Can anyone please advise me on how to merge all the sub-level sheets into one cvs sheet? When I have tried to get that, the information is in rows instead of columns and is all jumbled together.

Thank you for your time
Kim

It might be that the database dump is large. Try dumping in shell.

$ mysqldump -h [dbHostName] -u [dbUserName] -p [dbName] -t -T~/ --fields-enclosed-by=" --fields-terminated-by=,

1 Like

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.