14,982
edits
MySQL commands: Difference between revisions
Jump to navigation
Jump to search
→Synchronizing databases
| Line 79: | Line 79: | ||
=== Synchronizing databases === | === Synchronizing databases === | ||
Synchronizing two MySQL databases: | Synchronizing two MySQL databases: | ||
* [http://www.heidisql.com/ HeidiSQL - MySQL, MSSQL and PostgreSQL made easy] v.9.4.0.5125 for {{Win}}, {{Mac}} & {{Linux}} | * [http://www.heidisql.com/ HeidiSQL - MySQL, MSSQL and PostgreSQL made easy] v.9.4.0.5125 for {{Win}}, {{Mac}} & {{Linux}} | ||
** Steps: Choose the database or table --> Export database as SQL --> Output: Select the mysql server connection | ** Steps: Choose the database or table --> Export database as SQL --> Output: Select the mysql server connection | ||
** Scheduler: Not available<ref>[http://www.heidisql.com/forum.php?t=22040 Schedule backups/exports]</ref> {{exclaim}}. Manually synchronizing databases between two different servers. | |||
* [https://dev.mysql.com/doc/refman/5.7/en/replication.html Replication] | * [https://dev.mysql.com/doc/refman/5.7/en/replication.html Replication] | ||
** Steps: | |||
** Scheduler: Auto {{Gd}}. | |||
* ''$'' [https://www.webyog.com/product/sqlyog SQLyog] for {{Win}}. | |||
** Steps: Menu --> Powertools --> Database Synchronization Wizard | |||
** Scheduler: Available {{Gd}}. Save the job file & Schedule it using Windows scheduler. | |||
Transfer date from MS SQL server to MySQL server: | Transfer date from MS SQL server to MySQL server: | ||