Problem z mariadb

[DaFFX 14]

Witajcie,

Przy migracji z mysql'a na mariadb powstał pewien problem, przy próbie instalacji mariadb wyskakuja errory: http://pastebin.com/raw/BukHiaVf

Może ktoś z was miał ten problem lub wie jak sobie z nim poradzić?

[hemi 20]

Spróbuj całkowicie usunąć mysql z systemu. Oczywiście zrób kopię całego katalogu /var/lib/mysql lub mysqldump całej instancji jeśli masz już tam jakies dane.

apt-get remove --purge mysql-server mysql-client mysql-common

[Gość mariaczi]

Zrób purge dla samego pakietu mysql-common. W nim nic nie wskazuje do /var/lib/mysql (https://packages.debian.org/jessie/all/mysql-common/filelist) zatem nie powinno usunąć Ci danych. Czytaj dokładnie komunikaty. Kopia zawsze mile widziana przed rozpoczęciem działań.

 

[Edycja] Linki:

http://xmodulo.com/migrate-mysql-to-mariadb-linux.html

https://downloads.mariadb.org/mariadb/repositories/#mirror=kisiek&distro=Debian&distro_release=jessie--jessie&version=10.1

Edytowano Luty 10, 2017 przez mariaczi (zobacz historię edycji)

[DaFFX 14]

 

Spróbuj całkowicie usunąć mysql z systemu. Oczywiście zrób kopię całego katalogu /var/lib/mysql lub mysqldump całej instancji jeśli masz już tam jakies dane.

apt-get remove --purge mysql-server mysql-client mysql-common

root@s1:/home# apt-get remove --purge mysql-server mysql-client mysql-common    Reading package lists... Done
Building dependency tree
Reading state information... Done
Package 'mysql-client' is not installed, so not removed
Package 'mysql-server' is not installed, so not removed
You might want to run 'apt-get -f install' to correct these:
The following packages have unmet dependencies:
 libmysqlclient18 : Depends: mysql-common (= 5.6.35-1debian8)
 mariadb-common : Depends: mysql-common
 mariadb-server : Depends: mariadb-server-10.0 (>= 10.0.29-0+deb8u1) but it is not going to be installed
E: Unmet dependencies. Try 'apt-get -f install' with no packages (or specify a solution).
root@s1:/home# clear
root@s1:/home# apt-get remove --purge mysql-server mysql-client mysql-common
Reading package lists... Done
Building dependency tree
Reading state information... Done
Package 'mysql-client' is not installed, so not removed
Package 'mysql-server' is not installed, so not removed
You might want to run 'apt-get -f install' to correct these:
The following packages have unmet dependencies:
 libmysqlclient18 : Depends: mysql-common (= 5.6.35-1debian8)
 mariadb-common : Depends: mysql-common
 mariadb-server : Depends: mariadb-server-10.0 (>= 10.0.29-0+deb8u1) but it is not going to be installed
E: Unmet dependencies. Try 'apt-get -f install' with no packages (or specify a solution).
root@s1:/home# apt-get -f install
Reading package lists... Done
Building dependency tree
Reading state information... Done
Correcting dependencies... Done
The following extra packages will be installed:
  mariadb-server-10.0 mariadb-server-core-10.0
Suggested packages:
  mariadb-test tinyca
The following NEW packages will be installed:
  mariadb-server-10.0 mariadb-server-core-10.0
0 upgraded, 2 newly installed, 0 to remove and 1 not upgraded.
1 not fully installed or removed.
Need to get 0 B/10.7 MB of archives.
After this operation, 99.5 MB of additional disk space will be used.
Do you want to continue? [Y/n] y
Preconfiguring packages ...
(Reading database ... 58839 files and directories currently installed.)
Preparing to unpack .../mariadb-server-core-10.0_10.0.29-0+deb8u1_amd64.deb ...
Unpacking mariadb-server-core-10.0 (10.0.29-0+deb8u1) ...
dpkg: error processing archive /var/cache/apt/archives/mariadb-server-core-10.0_10.0.29-0+deb8u1_amd64.deb (--unpack):
 trying to overwrite '/usr/share/mysql/japanese/errmsg.sys', which is also in package mysql-common 5.6.35-1debian8
dpkg-deb: error: subprocess paste was killed by signal (Broken pipe)
Preparing to unpack .../mariadb-server-10.0_10.0.29-0+deb8u1_amd64.deb ...
Unpacking mariadb-server-10.0 (10.0.29-0+deb8u1) ...
dpkg: error processing archive /var/cache/apt/archives/mariadb-server-10.0_10.0.29-0+deb8u1_amd64.deb (--unpack):
 trying to overwrite '/usr/share/mysql/errmsg-utf8.txt', which is also in package mysql-common 5.6.35-1debian8
dpkg-deb: error: subprocess paste was killed by signal (Broken pipe)
E: Sub-process /usr/bin/dpkg returned an error code (1)
root@s1:/home#

To samo ;x

[Fizyda 34]

Zrób apt-get autoremove a potem update i dopiero instaluj mariadb.

[Gość mariaczi]

Jak nie uda Ci się samodzielnie rozwiązać problemu, to odezwij się na PW. Mogę dziś wieczorem spojrzeć "w serwer".