mysql Archives - Desinerd : Dipankar's Blog

Gotcha with exporting MySQL tables for windows

Published: January 9, 2013 in Articles, Technical, carriage return, encoding, latin1, mysql, perl, unicode, utf by admin. Leave a Comment on Gotcha with exporting MySQL tables for windows.

I encountered some interesting issues when pulling out CSV from my MySQL databases. The core issue was the csv generated was not seemingly compatible with the various spreadsheet readers in Windows. After having a closer look at the file, it turns out to be an encoding issue clearly. As the database was Latin1 encoded, the […]

Exporting MySQL tables and databases

Published: January 9, 2013 in Articles, Technical, dump, export, mysql, mysqldump, sql by admin. Leave a Comment on Exporting MySQL tables and databases.

Here are the ways you can export tables and databases, each of them have their advantages and disadvantages depending on the task at hand. We will list out each with examples and discuss them. We will assume that the database name is D and table name is T. 1. Going native with SQL and generating […]