Rubriigi arhiiv: mysql

moving data from MS SQL to MySQL, on OSX

When I have had to move data from Microsoft SQL Server to MySQL I have used MySQL Workbench data migration wizard – well, presumably used, as there has never been enough time to document the process. But as I spent several hours today trying to re-build the setup and ended using RazorSQL (during last 15 minutes)… some […]

Lisaks postitatud rubriiki ms sql | Kommenteerimine suletud

dumping databases, sometimes with forced latin1

This script dates back to when I needed to dump MySQL database accessed by whatever legacy app that decided to connect as latin1 but send data as utf8 – meaning, that dumping it with usual phpMyAdmin (that connects as utf8) resulted in file that failed to properly import. Well, it did import, but the contents […]

Lisaks postitatud rubriiki php, wordpress | Kommenteerimine suletud