Seeing tables in csv version of database backup

[jonkip]

Doing a backup of the DB, and exporting as SQL file , viewing in text editor, I can see the different table names and that's good.
However, when I export the complete DB using csv, I don't see the table names.
I'm trying different ways to export and still don't find the table names in csv.

this is not a big deal, but it's annoying that I can't figure it out.... I'd still probably upload using sql format, but I can't yet figure out how to see the individual TABLES in the csv version.

Searching the posts here yields nothing on this particular subject... but I did give it many chances to act nicely ....

Any ideas will be appreciated, of course

thanks

[DrByte]

Assuming you're talking about phpMyAdmin here.

If you really feel the need to export as CSV, I believe you'd need to do each table manually, one-by-one, and name the files according to which table you're exporting.

But, I don't see any practical application for exporting all tables to CSV. Might be suitable for individual tables when you're using that data in other applications. But not relevant for doing a full database backup.

If you're doing exports for the purpose of doing a database backup, then SQL is the appropriate format.

[jonkip]

thanks, I guess I wasn't clear.... I just wonder how the csv file accounts for the table names, since they don't seem to be included in the backup when done as csv.....I do the backups as sql just fine, I'm just curious as to how the csv file, which can also be used to backup and restore the DB, how it knows which table gets what information....

Again, I'm NOT using the csv for much....and this is just curiosity...

[DrByte]

My observations are the same: no tablename is output. Which makes sense, since a csv file is for the data, not for the tablename. I'd hate to have to remove the tablename from a csv file that I was working with.

And, I think your assumption about using csv to restore data is wrong. I don't think that's its purpose at all. Certainly not as far as an entire database is concerned. Maybe for one single table, but that's all.

[jonkip]

ok, thanks