As part of the the first service to migrate is my MySQL 5.7 engine. Although MySQL is not part of MacOS Server anymore for a long time (and I had installed it separately), I will cover the migration here as 1) I still had it running on my MacOS Server and 2) the migration wasn’t smooth so decided to share my learnings here. The first complication I encountered was that on, MySQL (now an Oracle product) is no longer available in the Debian package repository. It by, a spin-off by a part of the original MySQL development team at the moment of the acquisition of Sun by Oracle. Although it is supposed (and also looks like) a drop-in replacement, I wasn’t sure how it would handle the migration from MySQL 5.7 to MariaDB 10.1. And it turned out not to be a smooth ride as there were incompatible differences between these two products/versions that could not be handled in a fully automated way. Android Cloud Security Code Scripting Cryptography CTF Challenges Data security Enterprise Security Weekly Framework google Government hacking Hacks interview IoT Kali Linux Linux Mac Malware Microsoft Mobile Security Networking News Open Source Other Paul's Security Weekly paul asadoorian Penetration Test Penetration Testing Phishing. I need MySQL or MariaDB for a WordPress install on Mac OSX. I’m wondering if given what you said if MariaDB is not the way to go. I wanted something simple like a double-clickable package install. Mariadb Client ToolOpenvpn 2.4.5. Failed Attempt 1: mysqldump -A and importing the dump The first (and usual) approach to migrate MySQL databases is to export it on the old server and import it on the new server. This is how I have done this already many times before so expected this to work. I issued the following command: sudo /usr/local/mysql/bin/mysqldump -p --all-databases| gzip > hostname.mysql.20180331.dmp.gz on my MacOS Server (it prompted me for the root password as that is the way I set it up), transferred the file to the new server and ran the command: zcat hostname.mysql.20180331.dmp.gz| sudo mysql By default, on MariaDB on Debian allows root to connect and login in using a unix socket so no password is needed for this operations. After the import, the data seemed OK though I was unable to add any users or change rights and after a restart, MariaDB no longer wanted to start and in the logs I got the following error message: [ERROR] Fatal error: mysql.user table is damaged. Please run mysql_upgrade.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |