MariaDB migreren van Ubuntu naar Debian
Hallo,
Ik wil MariaDB kopieren van Ubuntu naar Debian. De versie op Debian is
nieuwer, maar niet veel.
Oud:
mysql Ver 15.1 Distrib 10.3.31-MariaDB, for debian-linux-gnu (x86_64)
using readline 5.2
Nieuw:
mysql Ver 15.1 Distrib 10.5.11-MariaDB, for debian-linux-gnu (x86_64)
using EditLine wrapper
Wat ik wou doen is aan beide kanten MariaDB uitzetten, en dan
/var/lib/mysql synchroniseren. Dan op de nieuwe machine MariaDB weer
aanzetten. Bij de informatie aan het eind van dit bericht is dat nog
niet gebeurd, daar heb ik de ib_logfile* bestanden verwijderd en dan
start het wel weer, maar goed is het niet.
Ik kwam ook een melding tegen dat inloggen als root niet lukt voor de
update, terwijl het paswoord in /root/.my.cnf staat en inloggen als root
vanaf de commandline lukt.
Ja, ik weet het, een dump maken en weer inlezen is beter. Maar in dit
geval lastig (grote database, disks erg vol).
Tips zijn welkom.
Groeten,
Paul
----
root@BW165:/var/lib/mysql# systemctl status mariadb
● mariadb.service - MariaDB 10.5.11 database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled;
vendor preset: enabled)
Active: active (running) since Thu 2021-09-23 12:02:01 CEST; 40s ago
Docs: man:mariadbd(8)
https://mariadb.com/kb/en/library/systemd/
Process: 42267 ExecStartPre=/usr/bin/install -m 755 -o mysql -g
root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
Process: 42268 ExecStartPre=/bin/sh -c systemctl unset-environment
_WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 42270 ExecStartPre=/bin/sh -c [ ! -e
/usr/bin/galera_recovery ] && VAR= || VAR=`cd /usr/bin/..;
/usr/bin/galera_recovery`; [ $? -eq 0 ] && s>
Process: 42333 ExecStartPost=/bin/sh -c systemctl unset-environment
_WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 42335 ExecStartPost=/etc/mysql/debian-start (code=exited,
status=0/SUCCESS)
Main PID: 42317 (mariadbd)
Status: "Taking your SQL requests now..."
Tasks: 16 (limit: 38149)
Memory: 100.5M
CPU: 157ms
CGroup: /system.slice/mariadb.service
└─42317 /usr/sbin/mariadbd
sep 23 12:02:01 BW165 mariadbd[42317]: 2021-09-23 12:02:01 0 [ERROR]
InnoDB: Your database may be corrupt or you may have copied the InnoDB
tablespace but no>
sep 23 12:02:01 BW165 mariadbd[42317]: 2021-09-23 12:02:01 0 [ERROR]
InnoDB: Page [page id: space=11005, page number=32661] log sequence
number 97015802228 i>
sep 23 12:02:01 BW165 mariadbd[42317]: 2021-09-23 12:02:01 0 [ERROR]
InnoDB: Your database may be corrupt or you may have copied the InnoDB
tablespace but no>
sep 23 12:02:01 BW165 mariadbd[42317]: 2021-09-23 12:02:01 0 [ERROR]
InnoDB: Page [page id: space=11005, page number=49152] log sequence
number 97212470424 i>
sep 23 12:02:01 BW165 mariadbd[42317]: 2021-09-23 12:02:01 0 [ERROR]
InnoDB: Your database may be corrupt or you may have copied the InnoDB
tablespace but no>
sep 23 12:02:01 BW165 mariadbd[42317]: 2021-09-23 12:02:01 0 [ERROR]
InnoDB: Page [page id: space=11005, page number=56022] log sequence
number 96979870456 i>
sep 23 12:02:01 BW165 mariadbd[42317]: 2021-09-23 12:02:01 0 [ERROR]
InnoDB: Your database may be corrupt or you may have copied the InnoDB
tablespace but no>
sep 23 12:02:01 BW165 mariadbd[42317]: 2021-09-23 12:02:01 0 [ERROR]
InnoDB: Page [page id: space=11005, page number=56023] log sequence
number 96979990452 i>
sep 23 12:02:01 BW165 mariadbd[42317]: 2021-09-23 12:02:01 0 [ERROR]
InnoDB: Your database may be corrupt or you may have copied the InnoDB
tablespace but no>
sep 23 12:02:01 BW165 mariadbd[42317]: 2021-09-23 12:02:01 0 [Note]
InnoDB: Buffer pool(s) load completed at 210923 12:02:01
----------
Uit /var/log/syslog
--------
Sep 23 11:42:18 BW165 systemd[1]: Started MariaDB 10.5.11 database server.
Sep 23 11:42:18 BW165 /etc/mysql/debian-start[42232]: Upgrading MySQL
tables if necessary.
Sep 23 11:42:18 BW165 mariadbd[42214]: 2021-09-23 11:42:18 3 [Warning]
Access denied for user 'root'@'localhost' (using password: NO)
Sep 23 11:42:18 BW165 mariadbd[42214]: 2021-09-23 11:42:18 4 [Warning]
Access denied for user 'root'@'localhost' (using password: NO)
Sep 23 11:42:18 BW165 /etc/mysql/debian-start[42235]: Looking for
'mysql' as: /usr/bin/mysql
Sep 23 11:42:18 BW165 /etc/mysql/debian-start[42235]: Looking for
'mysqlcheck' as: /usr/bin/mysqlcheck
Sep 23 11:42:18 BW165 /etc/mysql/debian-start[42235]: Version check
failed. Got the following error when calling the 'mysql' command line client
Sep 23 11:42:18 BW165 /etc/mysql/debian-start[42235]: ERROR 1045
(28000): Access denied for user 'root'@'localhost' (using password: NO)
Sep 23 11:42:18 BW165 /etc/mysql/debian-start[42235]: FATAL ERROR:
Upgrade failed
Sep 23 11:42:18 BW165 /etc/mysql/debian-start[42245]: Checking for
insecure root accounts.
Sep 23 11:42:18 BW165 mariadbd[42214]: 2021-09-23 11:42:18 5 [Warning]
Access denied for user 'root'@'localhost' (using password: NO)
Sep 23 11:42:18 BW165 debian-start[42248]: ERROR 1045 (28000): Access
denied for user 'root'@'localhost' (using password: NO)
Sep 23 11:42:18 BW165 mariadbd[42214]: 2021-09-23 11:42:18 0 [Note]
InnoDB: Buffer pool(s) load completed at 210923 11:42:18
------
--
Paul van der Vlis Linux systeembeheer Groningen
https://www.vandervlis.nl/
Reply to: