Завалил MySQL

blackdog · Сообщение **blackdog** » 16 сен 2014, 11:17

Raven писал(а):Блджад, вот нафига было выдумывать этот systemd, если он настолько неюзабельное УГ? Старые добырые инит-скрипты умели воссоздавать базу в пустую папку.

В общем вот:
Код: Выделить всё
systemctl stop mysql.service
rm -rf /var/lib/mysql/*
mysql_install_db
chown -R mysql:mysql /var/lib/mysql
ln -sf /usr/share/mysql-community-server/english/errmsg.sys /usr/share/mysql-community-server/errmsg.sys
systemctl start mysql.service

Ну собственно на стадии установки БД начинаются приколы

Код: Выделить всё

linux-white:~ # mysql_install_dbWARNING: The host 'linux-white' could not be looked up with /usr/bin/resolveip.
This probably means that your libc libraries are not 100 % compatible
with this binary MySQL version. The MySQL daemon, mysqld, should work
normally with the exception that host name resolving will not work.
This means that you should use IP addresses instead of hostnames
when specifying MySQL privileges !

Installing MySQL system tables...2014-09-16 11:11:29 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2014-09-16 11:11:29 6036 [ERROR] Can't find messagefile '/usr/share/mysql-community-server/errmsg.sys'
2014-09-16 11:11:29 6036 [ERROR] 
2014-09-16 11:11:29 6036 [ERROR] Couldn't load plugin named 'archive' with soname 'ha_archive.so'.
2014-09-16 11:11:29 6036 [Note] InnoDB: The InnoDB memory heap is disabled
2014-09-16 11:11:29 6036 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2014-09-16 11:11:29 6036 [Note] InnoDB: Compressed tables use zlib 1.2.8
2014-09-16 11:11:29 6036 [Note] InnoDB: Using Linux native AIO
2014-09-16 11:11:29 6036 [Note] InnoDB: Not using CPU crc32 instructions
2014-09-16 11:11:29 6036 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2014-09-16 11:11:29 6036 [Note] InnoDB: Completed initialization of buffer pool
2014-09-16 11:11:29 6036 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!
2014-09-16 11:11:29 6036 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB
2014-09-16 11:11:29 6036 [Note] InnoDB: Database physically writes the file full: wait...
2014-09-16 11:11:29 6036 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
2014-09-16 11:11:30 6036 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
2014-09-16 11:11:30 6036 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2014-09-16 11:11:30 6036 [Warning] InnoDB: New log files created, LSN=45781
2014-09-16 11:11:30 6036 [Note] InnoDB: Doublewrite buffer not found: creating new
2014-09-16 11:11:31 6036 [Note] InnoDB: Doublewrite buffer created
2014-09-16 11:11:31 6036 [Note] InnoDB: 128 rollback segment(s) are active.
2014-09-16 11:11:31 6036 [Warning] InnoDB: Creating foreign key constraint system tables.
2014-09-16 11:11:31 6036 [Note] InnoDB: Foreign key constraint system tables created
2014-09-16 11:11:31 6036 [Note] InnoDB: Creating tablespace and datafile system tables.
2014-09-16 11:11:31 6036 [Note] InnoDB: Tablespace and datafile system tables created.
2014-09-16 11:11:31 6036 [Note] InnoDB: Waiting for purge to start
2014-09-16 11:11:31 6036 [Note] InnoDB: 5.6.12 started; log sequence number 0
2014-09-16 11:11:31 6036 [ERROR] Aborting

2014-09-16 11:11:31 6036 [Note] Binlog end
2014-09-16 11:11:31 6036 [Note] InnoDB: FTS optimize thread exiting.
2014-09-16 11:11:31 6036 [Note] InnoDB: Starting shutdown...
2014-09-16 11:11:33 6036 [Note] InnoDB: Shutdown completed; log sequence number 1600607
2014-09-16 11:11:33 6036 [Note] 
linux-white:~ # chown -R mysql:mysql /var/lib/mysqllinux-white:~ # ln -sf /usr/share/mysql-community-server/english/errmsg.sys /usr/share/mysql-community-server/errmsg.sys
linux-white:~ # systemctl start mysql.serviceJob for mysql.service failed. See 'systemctl status mysql.service' and 'journalctl -xn' for details.
linux-white:~ # systemctl status mysql.service
mysql.service - LSB: Start the MySQL database server
   Loaded: loaded (/etc/init.d/mysql)
   Active: failed (Result: exit-code) since Вт 2014-09-16 11:12:46 KGT; 9s ago
  Process: 6068 ExecStart=/etc/init.d/mysql start (code=exited, status=1/FAILURE)

сен 16 11:12:15 linux-white mysql[6068]: Will update MySQL now, if you encounter any problems, please read...file:
сен 16 11:12:15 linux-white mysql[6068]: /usr/share/doc/packages/mysql-community-server/README.SuSE
сен 16 11:12:15 linux-white mysql[6068]: Log files inconsistency, please merge following files manually:
сен 16 11:12:15 linux-white mysql[6068]: Running protected MySQL...
сен 16 11:12:46 linux-white mysql[6068]: error: /var/tmp/mysql-protected.BohlUv/mysql.sock file didn't appeared...
сен 16 11:12:46 linux-white mysql[6068]: Try checking "/var/log/mysql/mysqld-upgrade-run.log"...
сен 16 11:12:46 linux-white mysql[6068]: ..failed
сен 16 11:12:46 linux-white systemd[1]: mysql.service: control process exited, code=exited status=1
сен 16 11:12:46 linux-white systemd[1]: Failed to start LSB: Start the MySQL database server.
сен 16 11:12:46 linux-white systemd[1]: Unit mysql.service entered failed state.
Hint: Some lines were ellipsized, use -l to show in full.
linux-white:~ #

/var/log/mysql/mysqld-upgrade-run.log

Код: Выделить всё

140916 11:12:16 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2014-09-16 11:12:16 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2014-09-16 11:12:16 6451 [ERROR] Can't find messagefile '/usr/share/mysql-community-server/errmsg.sys'
2014-09-16 11:12:16 6451 [Note] Plugin 'FEDERATED' is disabled.
2014-09-16 11:12:16 6451 [ERROR] 
2014-09-16 11:12:16 6451 [ERROR] Couldn't load plugin named 'archive' with soname 'ha_archive.so'.
2014-09-16 11:12:16 6451 [Note] InnoDB: The InnoDB memory heap is disabled
2014-09-16 11:12:16 6451 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2014-09-16 11:12:16 6451 [Note] InnoDB: Compressed tables use zlib 1.2.8
2014-09-16 11:12:16 6451 [Note] InnoDB: Using Linux native AIO
2014-09-16 11:12:16 6451 [Note] InnoDB: Not using CPU crc32 instructions
2014-09-16 11:12:16 6451 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2014-09-16 11:12:16 6451 [Note] InnoDB: Completed initialization of buffer pool
2014-09-16 11:12:16 6451 [Note] InnoDB: Highest supported file format is Barracuda.
2014-09-16 11:12:17 6451 [Note] InnoDB: 128 rollback segment(s) are active.
2014-09-16 11:12:17 6451 [Note] InnoDB: Waiting for purge to start
2014-09-16 11:12:17 6451 [Note] InnoDB: 5.6.12 started; log sequence number 1600607
2014-09-16 11:12:17 6451 [ERROR] Aborting

2014-09-16 11:12:17 6451 [Note] Binlog end
2014-09-16 11:12:17 6451 [Note] Shutting down plugin 'partition'
2014-09-16 11:12:17 6451 [Note] Shutting down plugin 'ARCHIVE'
2014-09-16 11:12:17 6451 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2014-09-16 11:12:17 6451 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2014-09-16 11:12:17 6451 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2014-09-16 11:12:17 6451 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2014-09-16 11:12:17 6451 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2014-09-16 11:12:17 6451 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2014-09-16 11:12:17 6451 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2014-09-16 11:12:17 6451 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2014-09-16 11:12:17 6451 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2014-09-16 11:12:17 6451 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2014-09-16 11:12:17 6451 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2014-09-16 11:12:17 6451 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2014-09-16 11:12:17 6451 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2014-09-16 11:12:17 6451 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2014-09-16 11:12:17 6451 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2014-09-16 11:12:17 6451 [Note] Shutting down plugin 'INNODB_METRICS'
2014-09-16 11:12:17 6451 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2014-09-16 11:12:17 6451 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2014-09-16 11:12:17 6451 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2014-09-16 11:12:17 6451 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2014-09-16 11:12:17 6451 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2014-09-16 11:12:17 6451 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2014-09-16 11:12:17 6451 [Note] Shutting down plugin 'INNODB_CMPMEM'
2014-09-16 11:12:17 6451 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2014-09-16 11:12:17 6451 [Note] Shutting down plugin 'INNODB_CMP'
2014-09-16 11:12:17 6451 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2014-09-16 11:12:17 6451 [Note] Shutting down plugin 'INNODB_LOCKS'
2014-09-16 11:12:17 6451 [Note] Shutting down plugin 'INNODB_TRX'
2014-09-16 11:12:17 6451 [Note] Shutting down plugin 'InnoDB'
2014-09-16 11:12:17 6451 [Note] InnoDB: FTS optimize thread exiting.
2014-09-16 11:12:17 6451 [Note] InnoDB: Starting shutdown...
2014-09-16 11:12:19 6451 [Note] InnoDB: Shutdown completed; log sequence number 1600617
2014-09-16 11:12:19 6451 [Note] Shutting down plugin 'BLACKHOLE'
2014-09-16 11:12:19 6451 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2014-09-16 11:12:19 6451 [Note] Shutting down plugin 'MEMORY'
2014-09-16 11:12:19 6451 [Note] Shutting down plugin 'CSV'
2014-09-16 11:12:19 6451 [Note] Shutting down plugin 'MRG_MYISAM'
2014-09-16 11:12:19 6451 [Note] Shutting down plugin 'MyISAM'
2014-09-16 11:12:19 6451 [Note] Shutting down plugin 'sha256_password'
2014-09-16 11:12:19 6451 [Note] Shutting down plugin 'mysql_old_password'
2014-09-16 11:12:19 6451 [Note] Shutting down plugin 'mysql_native_password'
2014-09-16 11:12:19 6451 [Note] Shutting down plugin 'binlog'
2014-09-16 11:12:19 6451 [Note] 
140916 11:12:19 mysqld_safe mysqld from pid file /var/tmp/mysql-protected.BohlUv/mysqld.pid ended

Какой то бег по кругу.Одна и та же ошибка

Код: Выделить всё

2014-09-16 11:12:16 6451 [Note] Plugin 'FEDERATED' is disabled.
2014-09-16 11:12:16 6451 [ERROR] 
2014-09-16 11:12:16 6451 [ERROR] Couldn't load plugin named 'archive' with soname 'ha_archive.so'.

И чего то я не вкурил-это на что он тут лается???

Код: Выделить всё

The host 'linux-white' could not be looked up with /usr/bin/resolveip.
This probably means that your libc libraries are not 100 % compatible
with this binary MySQL version. The MySQL daemon, mysqld, should work
normally with the exception that host name resolving will not work.
This means that you should use IP addresses instead of hostnames
when specifying MySQL privileges !

Raven · Сообщение **Raven** » 16 сен 2014, 13:56

mysql стал догадываться что он приемный

1. сделай симлинк раньше установки баз
ln -sf /usr/share/mysql-community-server/english/errmsg.sys /usr/share/mysql-community-server/errmsg.sys

2. покажи содержимое my.cnf

blackdog · Сообщение **blackdog** » 16 сен 2014, 14:50

Raven писал(а):mysql стал догадываться что он приемный

1. сделай симлинк раньше установки баз
ln -sf /usr/share/mysql-community-server/english/errmsg.sys /usr/share/mysql-community-server/errmsg.sys

2. покажи содержимое my.cnf

Выполнил предложенные действия еще раз указав линк раньше создания базы

Код: Выделить всё

linux-white:~ # systemctl stop mysql.service
linux-white:~ # rm -rf /var/lib/mysql/*
linux-white:~ # ln -sf /usr/share/mysql-community-server/english/errmsg.sys /usr/share/mysql-community-server/errmsg.sys
linux-white:~ # mysql_install_db
WARNING: The host 'linux-white' could not be looked up with /usr/bin/resolveip.
This probably means that your libc libraries are not 100 % compatible
with this binary MySQL version. The MySQL daemon, mysqld, should work
normally with the exception that host name resolving will not work.
This means that you should use IP addresses instead of hostnames
when specifying MySQL privileges !

Installing MySQL system tables...2014-09-16 14:44:42 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2014-09-16 14:44:42 10761 [ERROR] Can't find messagefile '/usr/share/mysql-community-server/errmsg.sys'
2014-09-16 14:44:42 10761 [ERROR] 
2014-09-16 14:44:42 10761 [ERROR] Couldn't load plugin named 'archive' with soname 'ha_archive.so'.
2014-09-16 14:44:42 10761 [Note] InnoDB: The InnoDB memory heap is disabled
2014-09-16 14:44:42 10761 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2014-09-16 14:44:42 10761 [Note] InnoDB: Compressed tables use zlib 1.2.8
2014-09-16 14:44:42 10761 [Note] InnoDB: Using Linux native AIO
2014-09-16 14:44:42 10761 [Note] InnoDB: Not using CPU crc32 instructions
2014-09-16 14:44:42 10761 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2014-09-16 14:44:42 10761 [Note] InnoDB: Completed initialization of buffer pool
2014-09-16 14:44:42 10761 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!
2014-09-16 14:44:42 10761 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB
2014-09-16 14:44:42 10761 [Note] InnoDB: Database physically writes the file full: wait...
2014-09-16 14:44:43 10761 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
2014-09-16 14:44:43 10761 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
2014-09-16 14:44:44 10761 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2014-09-16 14:44:44 10761 [Warning] InnoDB: New log files created, LSN=45781
2014-09-16 14:44:44 10761 [Note] InnoDB: Doublewrite buffer not found: creating new
2014-09-16 14:44:44 10761 [Note] InnoDB: Doublewrite buffer created
2014-09-16 14:44:44 10761 [Note] InnoDB: 128 rollback segment(s) are active.
2014-09-16 14:44:44 10761 [Warning] InnoDB: Creating foreign key constraint system tables.
2014-09-16 14:44:44 10761 [Note] InnoDB: Foreign key constraint system tables created
2014-09-16 14:44:44 10761 [Note] InnoDB: Creating tablespace and datafile system tables.
2014-09-16 14:44:44 10761 [Note] InnoDB: Tablespace and datafile system tables created.
2014-09-16 14:44:44 10761 [Note] InnoDB: Waiting for purge to start
2014-09-16 14:44:44 10761 [Note] InnoDB: 5.6.12 started; log sequence number 0
2014-09-16 14:44:44 10761 [ERROR] Aborting

2014-09-16 14:44:44 10761 [Note] Binlog end
2014-09-16 14:44:44 10761 [Note] InnoDB: FTS optimize thread exiting.
2014-09-16 14:44:44 10761 [Note] InnoDB: Starting shutdown...
2014-09-16 14:44:46 10761 [Note] InnoDB: Shutdown completed; log sequence number 1600607
2014-09-16 14:44:46 10761 [Note] 
linux-white:~ # chown -R mysql:mysql /var/lib/mysql
linux-white:~ # systemctl start mysql.service
Job for mysql.service failed. See 'systemctl status mysql.service' and 'journalctl -xn' for details.
linux-white:~ # systemctl status mysql.service
mysql.service - LSB: Start the MySQL database server
   Loaded: loaded (/etc/init.d/mysql)
   Active: failed (Result: exit-code) since Вт 2014-09-16 14:45:54 KGT; 28s ago
  Process: 10818 ExecStart=/etc/init.d/mysql start (code=exited, status=1/FAILURE)

сен 16 14:45:12 linux-white mysql[10818]: Will update MySQL now, if you encounter any problems, please rea...file:
сен 16 14:45:12 linux-white mysql[10818]: /usr/share/doc/packages/mysql-community-server/README.SuSE
сен 16 14:45:12 linux-white mysql[10818]: Log files inconsistency, please merge following files manually:
сен 16 14:45:12 linux-white mysql[10818]: Running protected MySQL...
сен 16 14:45:54 linux-white mysql[10818]: error: /var/tmp/mysql-protected.RnK2w7/mysql.sock file didn't ap...ed...
сен 16 14:45:54 linux-white mysql[10818]: Try checking "/var/log/mysql/mysqld-upgrade-run.log"...
сен 16 14:45:54 linux-white mysql[10818]: ..failed
сен 16 14:45:54 linux-white systemd[1]: mysql.service: control process exited, code=exited status=1
сен 16 14:45:54 linux-white systemd[1]: Failed to start LSB: Start the MySQL database server.
сен 16 14:45:55 linux-white systemd[1]: Unit mysql.service entered failed state.
Hint: Some lines were ellipsized, use -l to show in full.
linux-white:~ #

my.cnf

Код: Выделить всё

# This is default example of MySQL/MariaDB configuration provided with openSUSE package
# It is based on upstream defaults with some additional examples.


# The following options will be passed to all MariaDB clients
[client]
# password  = your_password
# port       = 3306
# socket     = /var/run/mysql/mysql.sock

[mysqld]

# Remove leading # if you don't want to listen on network (only socket - safer)
# skip-networking

# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M

# Using newer file format that supports dynamic and compressed row formats.
# If you are using replication you have to make sure, that these options are
# set everywhere the same way (probably comment them out is the easiest way)
innodb_file_format=Barracuda
innodb_file_per_table=ON

# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin=mysql-bin
# binlog_format=mixed

# Remove leading # if you want to store your database elsewhere
# datadir	= /var/lib/mysql

# required unique id between 1 and 2^32 - 1
# defaults to 1 if master-host is not set
# but will not function as a master if omitted
server-id	= 1

# These are commonly set, remove the # and set as required.
# port = 3306
# socket = /var/run/mysql/mysql.sock

# Don't listen on a TCP/IP port at all. This can be a security enhancement,
# if all processes that need to connect to mysqld run on the same host.
# All interaction with mysqld must be made via Unix sockets or named pipes.
# Note that using this option without enabling named pipes on Windows
# (via the "enable-named-pipe" option) will render mysqld useless!
# 
# skip-networking

# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M 

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

[mysqld_multi]
mysqld     = /usr/bin/mysqld_safe
mysqladmin = /usr/bin/mysqladmin
log        = /var/log/mysqld_multi.log

# If you want to use mysqld_multi uncomment 1 or more mysqld sections
# below or add your own ones.

# WARNING
# --------
# If you uncomment mysqld1 than make absolutely sure, that database mysql,
# configured above, is not started.  This may result in corrupted data!
#
# [mysqld1]
# port       = 3306
# datadir    = /var/lib/mysql
# pid-file   = /var/lib/mysql/mysqld.pid
# socket     = /var/lib/mysql/mysql.sock
# user       = mysql

# [mysqld2]
# port       = 3307
# datadir    = /var/lib/mysql-databases/mysqld2
# pid-file   = /var/lib/mysql-databases/mysqld2/mysql.pid
# socket     = /var/lib/mysql-databases/mysqld2/mysql.sock
# user       = mysql

# [mysqld3]
# port       = 3308
# datadir    = /var/lib/mysql-databases/mysqld3
# pid-file   = /var/lib/mysql-databases/mysqld3/mysql.pid
# socket     = /var/lib/mysql-databases/mysqld3/mysql.sock
# user       = mysql

# [mysqld6]
# port       = 3309
# datadir    = /var/lib/mysql-databases/mysqld6
# pid-file   = /var/lib/mysql-databases/mysqld6/mysql.pid
# socket     = /var/lib/mysql-databases/mysqld6/mysql.sock
# user       = mysql

!includedir /etc/my.cnf.d

почему то все закомментированное...
А что за ругачка была на нерезолв ИП?

Raven · Сообщение **Raven** » 16 сен 2014, 15:11

Да, странное содержимое фалов.
нужно взглянуть на файлы в /etc/my.cnf.d/, скорее всего там все интересное.

blackdog · Сообщение **blackdog** » 16 сен 2014, 15:17

Там ток один файл file:///etc/my.cnf.d/default_plugins.cnf

Код: Выделить всё

[server]
plugin-load=blackhole=ha_blackhole.so
plugin-load=federated=ha_federated.so
plugin-load=archive=ha_archive.so

chown -R mysql:mysql /usr/share/mysql-community-server/english

Код: Выделить всё

linux-white:~ # chown -R mysql:mysql /usr/share/mysql-community-server/english
chown: невозможно получить доступ к «/usr/share/mysql-community-server/english»: Нет такого файла или каталога
linux-white:~ #

Raven · Сообщение **Raven** » 16 сен 2014, 15:29

blackdog писал(а):chown -R mysql:mysql /usr/share/mysql-community-server/englishКод:linux-white:~ # chown -R mysql:mysql /usr/share/mysql-community-server/englishchown: невозможно получить доступ к «/usr/share/mysql-community-server/english»: Нет такого файла или каталогаlinux-white:~ #

как интересно! можно взглянуть на содержимое сей директории /usr/share/mysql-community-server?

blackdog писал(а):Там ток один файл file:///etc/my.cnf.d/default_plugins.cnf

Закоментируй в нем все. Это остатки mariadb.

blackdog · Сообщение **blackdog** » 16 сен 2014, 15:40

Raven писал(а):
blackdog писал(а):chown -R mysql:mysql /usr/share/mysql-community-server/englishКод:linux-white:~ # chown -R mysql:mysql /usr/share/mysql-community-server/englishchown: невозможно получить доступ к «/usr/share/mysql-community-server/english»: Нет такого файла или каталогаlinux-white:~ #
как интересно! можно взглянуть на содержимое сей директории /usr/share/mysql-community-server?

blackdog писал(а):Там ток один файл file:///etc/my.cnf.d/default_plugins.cnf
Закоментируй в нем все. Это остатки mariadb.

Закомментировал-там 3 строки
Скрин тож вроде прилепил
Блин,не пойму куда скрин исчезает-файр говорит что загрузил...

Код: Выделить всё

file:///usr/share/mysql-community-server/charsets
file:///usr/share/mysql-community-server/dictionary.txt
file:///usr/share/mysql-community-server/errmsg.sys
file:///usr/share/mysql-community-server/fill_help_tables.sql
file:///usr/share/mysql-community-server/innodb_memcached_config.sql
file:///usr/share/mysql-community-server/mysql_security_commands.sql
file:///usr/share/mysql-community-server/mysql_system_tables.sql
file:///usr/share/mysql-community-server/mysql_system_tables_data.sql
file:///usr/share/mysql-community-server/mysql_test_data_timezone.sql

вот список файлов оттеда

Raven · Сообщение **Raven** » 16 сен 2014, 15:48

Ясно. Пакета не хватает.
zypper install mysql-community-server-errormessages
rm -f /usr/share/mysql-community-server/errmsg.sys
ln -sf /usr/share/mysql-community-server/english/errmsg.sys /usr/share/mysql-community-server/errmsg.sys

blackdog · Сообщение **blackdog** » 16 сен 2014, 15:53

Raven писал(а):Ясно. Пакета не хватает.
zypper install mysql-community-server-errormessages
rm -f /usr/share/mysql-community-server/errmsg.sys
ln -sf /usr/share/mysql-community-server/english/errmsg.sys /usr/share/mysql-community-server/errmsg.sys

Я балдею от линя

Код: Выделить всё

linux-white:~ # zypper install mysql-community-server-errormessages
Загрузка данных о репозиториях...
Чтение установленных пакетов...
'mysql-community-server-errormessages' уже установлен.
Нет кандидатов на обновление 'mysql-community-server-errormessages-5.6.12-7.2.2.i586'. Новейшая версия уже установлена.
Разрешение зависимостей пакетов...

Нечего выполнять.
linux-white:~ #

blackdog писал(а):Я балдею от линя

это просто дебильный системд и менеджер пакетов тупят там где не надо

Завалил MySQL

Re: Завалил MySQL

Re: Завалил MySQL

Re: Завалил MySQL

Re: Завалил MySQL

Re: Завалил MySQL

Re: Завалил MySQL

Re: Завалил MySQL

Re: Завалил MySQL

Re: Завалил MySQL

Re: Завалил MySQL