changing field char set to store Emoji Character in MySQL
michael https://stackoverflow.com/questions/39463134/how-to-store-emoji-character-in-mysql-database php $this->pdo = new PDO(“mysql:host=$ip;port=$port;dbname=$db;charset=utf8mb4”
find replace update mysql table field
UPDATE db_name SET filename = REPLACE(filename, ’_JPG’, ’.JPG’) WHERE 1;
Delete duplicate db records
DELETE n1 FROM `memehk_scan` n1, `memehk_scan` n2 WHERE n1.id > n2.id AND n1.youtube_code = n2.youtube_code learn from SOF
Where is MariaDB config in Synology
/volume1/@appstore/MariaDB/etc/mysql/my.cnf (this one no data in my ds) and there’s another at /etc/my.cnf with data in mine Thank you link http://forum.kodi.tv/showthread.php?tid=184363
Commandline import .sql file
mysql -u username -p database_name < file.sql mysql dump mysqldump -u username -p db_name > backup-file.sql ar…for Synology MariaDB /usr/syno/mysql/bin/mysqldump –user=$DB_USER –password=$DB_PASS Schedule a Backup of all your MySQL databases…