CODEWITHSUNDEEP
mysqlexcelcsvspreadsheetdump
phaz
phaz

Reputation: 882

Exporting all data from MySQL database to spreadsheets

So, I've got a MySQL database consisting of a bunch of tables that I want to give to my uncle.

Problem is, he doesn't know much about computers, so I can't just hook him up with the database.

Instead, I would like to extract all the data from the database into a more readable format, e.g. Excel spreadsheets.

I've tried mysqldump, but that just gives me a *.sql file which doesn't help much.

Any ideas?

Upvotes: 0

Views: 3970

Answers (2)

user1914292
user1914292

Reputation: 1556

PHPmyadmin allows you to Export to many different formats - why don't you access your database through that?

Upvotes: 0

Kermit
Kermit

Reputation: 34054

If you only have command line, this answer explains how to dump into a tab delimited and this answer how to dump into a comma delimited file. You can then import the tab delimited file into Excel.

Alternatively, you can use phpMyAdmin to export to *.csv if you have PHP.

Upvotes: 2

Related Questions