Forum Moderators: coopster

Message Too Old, No Replies

phpMyAdmin: export several tables in csv?

Each table to a separate csv file - possible?

         

louponne

8:08 am on May 16, 2004 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



In phpMyAdmin, I'd like to select several tables, and export them to csv files, but each table in a separate file. I've tried every setting, and this isn't possible, right? I'm pretty sure it's not, but want to check to be sure!

henry0

10:54 am on May 16, 2004 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



unless I do not understand your question I do not see why you cannot
I always do it for backup purpose
not as a CSV format but as a simple file format
you need to only look at a single table and not at the whole DB, then do an export in the format that will fit you

don't know if it helps?

Henry

louponne

7:16 pm on May 16, 2004 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



No, sorry, that's not what I meant. Yes, I export .sql files all the time to do backups.

What I want to do here is export each table, separately, into a .csv file. You can export a table individually as a .csv, I'd like to know if there's any way at all to export several, or all, to as many .csv files as there are tables.

jatar_k

2:18 am on May 17, 2004 (gmt 0)

WebmasterWorld Administrator 10+ Year Member



the only way I can think of is to script it, don't know of a way in phpmyadmin though I rarely use it.