MariaDb (v. 10.4.10) import error (WAMPServer 3.2.0)
Usually happens when importing a huge amount of data to a table with many columns (total data length too large).
Tag: MySQL
Installing apache, mysql, php 7.0, php-apcu and Phalcon framework on Centos 7
紀錄一下。被權限設定浪費不少時間 =_=
Backup tables of mysql server and import to the other server
這邊的使用情況是要把 gcp sql 的 import 到 aliyun 去
mysql import (to aliyun/alibaba cloud) error
這個狀況在 aliyun RDS 系統上應該很容易遇到
定期備份 mysql 資料到其他機器
最理想的方式當然是做 cluster，但是有時候沒這麼理想。
[mysql] Migrate user account from developing server to testing/production server
主要參考 http://www.uptimemadeeasy.com/linux/mysql-migrate-users-server-server/
Allow multiple statements in MySQL ODBC
While using MySQL ODBC to execute sql statements, only single sql statement is allowed for execution by default. If you want to execute multiple sql statements at once, you have to enable the multiple statements setting in MySQL ODBC.