New answers tagged mysql-workbench
MySQL doesn't support true booleans as per standard SQL. It uses integer values 1 and 0 respectively for true and false. It does support the keywords true and false, but these are mapped to the integer values. mysql> SELECT true, false; +------+-------+ | TRUE | FALSE | +------+-------+ | 1 | 0 | +------+-------+ They really are mapped to ...
The error appears due to a corrupted configuration file or some dummy MySQL services (Leftovers from server installations not completely removed, this is due to the auto-detect mysql services functionality). Please make sure you're running the latest Notifier version available (that can be downloaded at mysql downloads page). How to solve the corrupted file ...
I got so SICK of MySQL Workbench being slow and sluggish (and sometimes crashing) while merely typing queries, I just switched to HeidiSQL. I'll never look back.
If this synchronization is regularly done (say every day) you may consider replication. I'm however unsure if that works in a scenario like yours where you have to replicate over internet. But I would give that a try. Otherwise you can only do it manually by taking a dump of your data and applying that to your remote server. That can be done autmoatically ...
Top 50 recent answers are included