13,468
edits
MySQL commands: Difference between revisions
Jump to navigation
Jump to search
m
no edit summary
m (→tools) |
mNo edit summary |
||
| Line 75: | Line 75: | ||
=== Synchronizing databases === | === Synchronizing 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}}: Manually synchronizing databases between two different servers. {{exclaim}} No schedules. | * [http://www.heidisql.com/ HeidiSQL - MySQL, MSSQL and PostgreSQL made easy] v.9.4.0.5125 for {{Win}}, {{Mac}} & {{Linux}}: Manually synchronizing databases between two different servers. {{exclaim}} No schedules. | ||
** 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 | ||
* [https://dev.mysql.com/doc/refman/5.7/en/replication.html Replication] | * [https://dev.mysql.com/doc/refman/5.7/en/replication.html Replication] | ||
Transfer date from MS SQL server to MySQL server: | |||
* ''$'' [https://www.webyog.com/product/sqlyog SQLyog] for {{Win}}. Use a query to specify the data to transfer from MS SQL server into MySQL server. | |||
=== Show the MySQL process list & kill the process === | === Show the MySQL process list & kill the process === | ||
| Line 262: | Line 266: | ||
[http://errerrors.blogspot.tw/2016/07/mysql.html Err: 解決 MySQL 資料庫所在硬碟空間不足的狀況] | [http://errerrors.blogspot.tw/2016/07/mysql.html Err: 解決 MySQL 資料庫所在硬碟空間不足的狀況] | ||
=== further reading === | === further reading === | ||