MySQL Forums
Forum List  »  Other Migration

Export entire database in CSV format
Posted by: hal lavender
Date: January 11, 2012 12:01PM

Hi. And Thanks in Advance

I want to export an entire MySQL database (all of the tables) to a series of CSV files (one file per table). is there a way to do this? I know this must be simple but I see how to do one table at a time but given I have 100 databases to do with 100s of tables in each one.. this would be to time consuming. Can one of you gurus provide me a way to do this?

Options: ReplyQuote


Subject
Views
Written By
Posted
Export entire database in CSV format
21690
January 11, 2012 12:01PM
11381
January 12, 2012 08:16AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.