Не работает mysql-server

Статус файловых систем в ro не перешел?

Прошу прощенья, я только осваиваю Linux, не могли бы подсказать как проверить статус? Спасибо.

Выполнить команду mount в консоли

Выйдет что-то вроде этого Где /dev/sd* Ваш раздел на жестком диске, а параметры в скобках (rw,relatime,user_xattr,barrier=1,data=ordered) это опции с которыми этот раздел подключен к системе (rw - чтиние/запись) и где on /mnt как в моем случае, директория, куда подключен раздел

проверьте не ro ли там? ( ro - read only )

sysfs on /sys type sysfs (rw,nosuid,nodev,noexec,relatime) proc on /proc type proc (rw,nosuid,nodev,noexec,relatime) udev on /dev type devtmpfs (rw,relatime,size=10240k,nr_inodes=4091320,mode=755) devpts on /dev/pts type devpts (rw,nosuid,noexec,relatime,gid=5,mode=620,ptmxmode=000) tmpfs on /run type tmpfs (rw,nosuid,noexec,relatime,size=3274400k,mode=755) /dev/disk/by-uuid/523717bb-4d80-41ca-a029-d9d1f0770ca4 on / type ext4 (rw,relatime,errors=remount-ro,user_xattr,barrier=1,data=ordered) tmpfs on /run/lock type tmpfs (rw,nosuid,nodev,noexec,relatime,size=5120k) tmpfs on /run/shm type tmpfs (rw,nosuid,nodev,noexec,relatime,size=9900940k) /dev/md1 on /boot type ext2 (rw,relatime,errors=continue) rpc_pipefs on /var/lib/nfs/rpc_pipefs type rpc_pipefs (rw,relatime) /dev/sdc1 on /mnt type ext4 (rw,relatime,user_xattr,barrier=1,data=ordered)

#mount

/dev/xvda1 on / type ext4 (rw,errors=remount-ro) proc on /proc type proc (rw,noexec,nosuid,nodev) sysfs on /sys type sysfs (rw,noexec,nosuid,nodev) none on /sys/fs/fuse/connections type fusectl (rw) none on /sys/kernel/debug type debugfs (rw) none on /sys/kernel/security type securityfs (rw) udev on /dev type devtmpfs (rw,mode=0755) devpts on /dev/pts type devpts (rw,noexec,nosuid,gid=5,mode=0620) tmpfs on /run type tmpfs (rw,noexec,nosuid,size=10%,mode=0755) none on /run/lock type tmpfs (rw,noexec,nosuid,nodev,size=5242880) none on /run/shm type tmpfs (rw,nosuid,nodev) /dev/xvdb5 on /mnt/disk type ext4 (rw) none on /proc/xen type xenfs (rw)

Ну блин! www.linux.org.ru/help/lorcode.md

тогда надо смотреть в сторону самого mysql а после чего так стало?

Жесткий диск забился данными, пришлось примонтировать новый, сделал бэкап базы, и перенес ее на новый диск. Ссылкой прокинул туда где и была. Выставил права. Перезапустил mysql. Вот в принципе и все мои действия. В чем может быть проблема?

не могли бы вы предоставить гостевой доступ в свою систему, чтобы я мог подробнее посмотреть всё. Мои контакты в профиле

Вот что выводит команда:
mysqld_safe --log-error=/var/log/mysql.err

160530 13:27:44 mysqld_safe Can't log to error log and syslog at the same time. Remove all --log-error configuration options for --syslog to take effect.
160530 13:27:44 mysqld_safe Logging to '/var/log/mysql.err'.
160530 13:27:44 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
160530 13:27:46 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

Попробуйте запустить myisamchk /var/lib/mysql/*/*.MYI >> /tmp/myisamchk_log.txt

если копия баз данных есть, то смело

myisamchk --silent --force --fast --update-state /var/lib/mysql/*/*.MYI

Checking MyISAM file: /var/lib/mysql/mysql/columns_priv.MYI Data records: 0 Deleted blocks: 0 - check file-size - check record delete-chain - check key delete-chain - check index reference - check data record references index: 1

---------

Checking MyISAM file: /var/lib/mysql/mysql/db.MYI Data records: 5 Deleted blocks: 0 - check file-size - check record delete-chain - check key delete-chain - check index reference - check data record references index: 1 - check data record references index: 2

---------

Checking MyISAM file: /var/lib/mysql/mysql/event.MYI Data records: 0 Deleted blocks: 0 - check file-size - check record delete-chain - check key delete-chain - check index reference - check data record references index: 1 - check record links

---------

Checking MyISAM file: /var/lib/mysql/mysql/func.MYI Data records: 0 Deleted blocks: 0 - check file-size - check record delete-chain - check key delete-chain - check index reference - check data record references index: 1

---------

Checking MyISAM file: /var/lib/mysql/mysql/help_category.MYI Data records: 39 Deleted blocks: 0 - check file-size - check record delete-chain - check key delete-chain - check index reference - check data record references index: 1 - check data record references index: 2 - check record links

---------

Checking MyISAM file: /var/lib/mysql/mysql/help_keyword.MYI Data records: 464 Deleted blocks: 0 - check file-size - check record delete-chain - check key delete-chain - check index reference - check data record references index: 1 - check data record references index: 2

---------

Checking MyISAM file: /var/lib/mysql/mysql/help_relation.MYI Data records: 1028 Deleted blocks: 0 - check file-size - check record delete-chain - check key delete-chain - check index reference - check data record references index: 1

---------

Checking MyISAM file: /var/lib/mysql/mysql/help_topic.MYI Data records: 508 Deleted blocks: 0 - check file-size - check record delete-chain - check key delete-chain - check index reference - check data record references index: 1 - check data record references index: 2 - check record links

---------

Checking MyISAM file: /var/lib/mysql/mysql/host.MYI Data records: 0 Deleted blocks: 0 - check file-size - check record delete-chain - check key delete-chain - check index reference - check data record references index: 1

---------

Checking MyISAM file: /var/lib/mysql/mysql/ndb_binlog_index.MYI Data records: 0 Deleted blocks: 0 - check file-size - check record delete-chain - check key delete-chain - check index reference - check data record references index: 1 - check record links

---------

Checking MyISAM file: /var/lib/mysql/mysql/plugin.MYI Data records: 0 Deleted blocks: 0 - check file-size - check record delete-chain - check key delete-chain - check index reference - check data record references index: 1 - check record links

---------

Checking MyISAM file: /var/lib/mysql/mysql/proc.MYI Data records: 8 Deleted blocks: 1 - check file-size - check record delete-chain - check key delete-chain - check index reference - check data record references index: 1 - check record links

---------

Checking MyISAM file: /var/lib/mysql/mysql/procs_priv.MYI Data records: 0 Deleted blocks: 0 - check file-size - check record delete-chain - check key delete-chain - check index reference - check data record references index: 1 - check data record references index: 2

---------

Checking MyISAM file: /var/lib/mysql/mysql/proxies_priv.MYI Data records: 2 Deleted blocks: 0 - check file-size - check record delete-chain - check key delete-chain - check index reference - check data record references index: 1 - check data record references index: 2

---------

Checking MyISAM file: /var/lib/mysql/mysql/servers.MYI Data records: 0 Deleted blocks: 0 - check file-size - check record delete-chain - check key delete-chain - check index reference - check data record references index: 1

---------

Checking MyISAM file: /var/lib/mysql/mysql/tables_priv.MYI Data records: 0 Deleted blocks: 0 - check file-size - check record delete-chain - check key delete-chain - check index reference - check data record references index: 1 - check data record references index: 2

---------

Checking MyISAM file: /var/lib/mysql/mysql/time_zone_leap_second.MYI Data records: 0 Deleted blocks: 0 - check file-size - check record delete-chain - check key delete-chain - check index reference - check data record references index: 1

---------

Checking MyISAM file: /var/lib/mysql/mysql/time_zone.MYI Data records: 0 Deleted blocks: 0 - check file-size - check record delete-chain - check key delete-chain - check index reference - check data record references index: 1

---------

Checking MyISAM file: /var/lib/mysql/mysql/time_zone_name.MYI Data records: 0 Deleted blocks: 0 - check file-size - check record delete-chain - check key delete-chain - check index reference - check data record references index: 1

---------

Checking MyISAM file: /var/lib/mysql/mysql/time_zone_transition.MYI Data records: 0 Deleted blocks: 0 - check file-size - check record delete-chain - check key delete-chain - check index reference - check data record references index: 1

---------

Checking MyISAM file: /var/lib/mysql/mysql/time_zone_transition_type.MYI Data records: 0 Deleted blocks: 0 - check file-size - check record delete-chain - check key delete-chain - check index reference - check data record references index: 1

---------

Checking MyISAM file: /var/lib/mysql/mysql/user.MYI Data records: 10 Deleted blocks: 0 - check file-size - check record delete-chain - check key delete-chain - check index reference - check data record references index: 1 - check record links

---------

Checking MyISAM file: /var/lib/mysql/zgdb/ds_sensors.MYI Data records: 4 Deleted blocks: 6 - check file-size - check record delete-chain - check key delete-chain - check index reference - check data record references index: 1 - check record links

---------

Checking MyISAM file: /var/lib/mysql/zgdb/ds_temps.MYI Data records: 58068 Deleted blocks: 0 - check file-size - check record delete-chain - check key delete-chain - check index reference - check data record references index: 1

К сожалению доступ к серверу предоставить не могу(

Я забыл о создании дампа работающей базы. забэкапил только саму папку mysql(

На будущее, скрипт для бэкапа баз данных и веб хостов

#!/bin/bash

#Settings

BACKUP_PATH="/home/BACKUP"
TIMESTAMP=$(date +"%F")
MYSQL=/usr/bin/mysql
MYSQLDUMP=/usr/bin/mysqldump
MYSQL_USER="user"
MYSQL_PASS="password"
SITES_DIR="/var/www"

## Files backup

for i in `ls $SITES_DIR`; do

if [[ ! -e $BACKUP_PATH/vhosts/$i ]]; then
            mkdir $BACKUP_PATH/vhosts/$i
fi

tar czf $BACKUP_PATH/vhosts/$i/$i-$TIMESTAMP.tar.gz $SITES_DIR/$i
done

databases=`$MYSQL --user=$MYSQL_USER -p$MYSQL_PASS -e "SHOW DATABASES;" | grep -Ev "(Database|information_schema|performance_schema)"`

for db in $databases; do

if [[ ! -e $BACKUP_PATH/bases/$db ]]; then
            mkdir $BACKUP_PATH/bases/$db
fi

  $MYSQLDUMP --force --opt --user=$MYSQL_USER -p$MYSQL_PASS --databases $db | gzip > "$BACKUP_PATH/bases/$db/$db-$TIMESTAMP.gz"
done

## Remove old backups

find $BACKUP_PATH/vhosts -mtime +3|xargs rm -f
find $BACKUP_PATH/bases -mtime +3|xargs rm -f

можно поместить в cron

touch /etc/cron.daily/backup_bd_www
chmod +x /etc/cron.daily/backup_bd_www

За скрипт огромное спасибо. Вопрос можно ли как-нибудь запустить mysql?

можно

А как? как исправить данную ошибку? Подскажите пожалуйста, очень нужно.