Восстановление баз данных mysql

Здравствуйте.Сегодня отвалился мускул и постоянно пытается и не может включиться,но да ладно,я собрался переезжать на новый сервер и хотел бы узнать,как можно восстановить все бд или что делать чтобы всё осталось на месте после переустановки,если вдруг поможет то вот лог:
лог файла massages:
[console]Jul 8 06:38:13 hostname mysqld[20851]: 110708 6:38:13 [ERROR] /usr/libexec/mysqld: Error writing file '/var/run/mysqld/mysqld.pid' (Errcode: 28)
Jul 8 06:38:13 hostname mysqld[20851]: 110708 6:38:13 [ERROR] Can't start server: can't create PID file: No space left on device
Jul 8 06:38:13 hostname mysqld_safe[20881]:
Jul 8 06:38:13 hostname mysqld_safe[20881]: Number of processes running now: 0
Jul 8 06:38:13 hostname mysqld_safe[20883]: restarted
Jul 8 06:38:13 hostname mysqld[20887]: InnoDB: The InnoDB memory heap is disabled
Jul 8 06:38:13 hostname mysqld[20887]: InnoDB: use atomic builtins.
Jul 8 06:38:13 hostname mysqld[20887]: 110708 6:38:13 InnoDB: Started; log sequence number 0 41898384
Jul 8 06:38:13 hostname mysqld[20887]: 110708 6:38:13 [ERROR] /usr/libexec/mysqld: Error writing file '/var/run/mysqld/mysqld.pid' (Errcode: 28)
Jul 8 06:38:13 hostname mysqld[20887]: 110708 6:38:13 [ERROR] Can't start server: can't create PID file: No space left on device
Jul 8 06:38:13 hostname mysqld_safe[20917]:
Jul 8 06:38:13 hostname mysqld_safe[20917]: Number of processes running now: 0
Jul 8 06:38:13 hostname mysqld_safe[20919]: restarted
Jul 8 06:38:13 hostname mysqld[20922]: InnoDB: The InnoDB memory heap is disabled
Jul 8 06:38:13 hostname mysqld[20922]: InnoDB: use atomic builtins.
Jul 8 06:38:13 hostname mysqld[20922]: 110708 6:38:13 InnoDB: Started; log sequence number 0 41898384
Jul 8 06:38:13 hostname mysqld[20922]: 110708 6:38:13 [ERROR] /usr/libexec/mysqld: Error writing file '/var/run/mysqld/mysqld.pid' (Errcode: 28)
Jul 8 06:38:13 hostname mysqld[20922]: 110708 6:38:13 [ERROR] Can't start server: can't create PID file: No space left on device
Jul 8 06:38:13 hostname mysqld_safe[20953]:
Jul 8 06:38:13 hostname mysqld_safe[20953]: Number of processes running now: 0
Jul 8 06:38:13 hostname mysqld_safe[20955]: restarted
Jul 8 06:38:13 hostname mysqld[20959]: InnoDB: The InnoDB memory heap is disabled[/console]

и ещё лог ispmanager:
[console]Jul 7 22:00:04 [21135] [1;35mWARNING Can't connect to mgr_support as root@localhost MySQLError('Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)'). autocreate=0[0m
Jul 7 22:00:04 [21135] [1;35mWARNING Load module 'support' error: Can't connect to database[0m
Jul 7 22:00:04 [21135] [1;36mEXTINFO Load config 'var/userconf/ispmgr.root'[0m
Jul 7 22:00:04 [21135] [1;35mWARNING Can't connect to mysql as root@localhost MySQLError('Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)'). autocreate=0[0m
Jul 7 22:00:04 [21135] [1;35mWARNING Can't register dbserver 'MySQL'[0m
Jul 7 22:00:04 [21135] [1;32mINFO Detect enabled firewall[0m
Jul 7 22:00:04 [21135] [1;36mEXTINFO Load config '/etc/sysconfig/iptables'[0m
Jul 7 22:00:04 [21135] [1;32mINFO Detect enabled firewall[0m
Jul 7 22:00:04 [21135] [1;36mEXTINFO Load config '/etc/sysconfig/iptables'[0m
Jul 7 22:00:04 [21135] [1;36mEXTINFO Converting ip assigment[0m
Jul 7 22:00:04 [21135] [1;36mEXTINFO Converting ip done[0m
Jul 7 22:00:04 [21135] [1;36mEXTINFO Execute (crontab -l) return=0 exited[0m
Jul 7 22:00:04 [21135] [1;36mEXTINFO Load config '/var/spool/cron/root'[0m
Jul 7 22:00:04 [21135] [1;36mEXTINFO Execute (crontab -l) return=0 exited[0m
Jul 7 22:00:04 [21135] [1;34mNOTE Begin periodic tasks[0m
Jul 7 22:00:04 [21135] [1;34mNOTE Waiting requests[0m
Jul 7 22:00:06 [21135] [1;32mINFO Request [93.178.82.210][root] 'func=feature.enable&elid=mysql'[0m
Jul 7 22:00:06 [21135] [1;36mEXTINFO Load config 'skins/sirius/theme.conf'[0m
Jul 7 22:00:06 [21135] [1;36mEXTINFO Load config 'skins/mobile/theme.conf'[0m
Jul 7 22:00:06 [21135] [1;32mINFO Request [93.178.82.210][root] 'func=feature&clickstat=yes'[0m
Jul 7 22:00:07 [21135] [1;32mINFO Request [pkgctl][root] 'out=text&func=services.edit&elid=MySQL'[0m
Jul 7 22:00:07 [21135] [1;36mEXTINFO Load config '/var/spool/cron/root'[0m
Jul 7 22:00:07 [21135] [1;32mINFO Request [pkgctl][root] 'out=text&func=services.edit&name=MySQL&type=mysql&proc=mysqld&confname=mysqld&start=%2Fetc%2Frc%2Ed%2Finit%2Ed%2Fmysqld%20start&stop=%2Fetc%2Frc%2Ed%2Finit%2Ed%2Fmysqld%20stop&autostart=on&ip=&sok=yes&elid=MySQL'[0m
Jul 7 22:00:07 [21135] [1;36mEXTINFO Load config '/var/spool/cron/root'[0m
Jul 7 22:00:07 [21135] [1;36mEXTINFO Execute (cp -rp /etc/xinetd.d /etc/xinetd.d.ispmgr) return=0 exited[0m
Jul 7 22:00:07 [21135] [1;36mEXTINFO Execute (/sbin/chkconfig mysqld off) return=0 exited[0m
Jul 7 22:00:07 [21135] [1;36mEXTINFO Execute (/sbin/chkconfig mysqld on) return=0 exited[0m
Jul 7 22:00:07 [21135] [1;36mEXTINFO Execute (rm -rf /etc/xinetd.d.ispmgr) return=0 exited[0m
Jul 7 22:00:07 [21135] [1;32mINFO Request [pkgctl][root] 'out=xml&func=services.start&elid=MySQL'[0m
Jul 7 22:00:49 [21135] [1;32mINFO Request [pkgctl][root] 'out=text&func=services.edit&elid=MySQL'[0m
Jul 7 22:00:49 [21135] [1;36mEXTINFO Load config '/var/spool/cron/root'[0m
Jul 7 22:00:49 [21135] [1;32mINFO Request [pkgctl][root] 'out=text&func=services.edit&name=MySQL&type=mysql&proc=mysqld&confname=mysqld&start=%2Fetc%2Frc%2Ed%2Finit%2Ed%2Fmysqld%20start&stop=%2Fetc%2Frc%2Ed%2Finit%2Ed%2Fmysqld%20stop&autostart=on&ip=%2Fvar%2Flib%2Fmysql%2Fmysql%2Esock&sok=yes&elid=MySQL'[0m
Jul 7 22:00:49 [21135] [1;36mEXTINFO Load config '/var/spool/cron/root'[0m
Jul 7 22:00:49 [21135] [1;36mEXTINFO Execute (cp -rp /etc/xinetd.d /etc/xinetd.d.ispmgr) return=0 exited[0m
Jul 7 22:00:49 [21135] [1;36mEXTINFO Execute (/sbin/chkconfig mysqld off) return=0 exited[0m
Jul 7 22:00:49 [21135] [1;36mEXTINFO Execute (/sbin/chkconfig mysqld on) return=0 exited[0m
Jul 7 22:00:49 [21135] [1;36mEXTINFO Execute (rm -rf /etc/xinetd.d.ispmgr) return=0 exited[0m
Jul 7 22:00:49 [21135] [1;32mINFO Request [pkgctl][root] 'out=text&func=dbconf.edit&elid=MySQL'[0m
Jul 7 22:00:49 [21135] [1;35mWARNING Can't connect to mysql as root@localhost MySQLError('Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)'). autocreate=0[0m
Jul 7 22:00:49 [21135] [1;36mEXTINFO Load config '/etc/my.cnf'[0m
Jul 7 22:00:49 [21135] [1;32mINFO Request [pkgctl][root] 'out=text&func=dbconf.edit&name=MySQL&dbtype=mysql&contype=local&user=root&passwd=*&sockpath=%2Fvar%2Flib%2Fmysql%2Fmysql%2Esock&atype=allow&sok=yes&elid=MySQL'[0m
Jul 7 22:00:49 [21135] [1;35mWARNING Can't connect to mysql as root@localhost MySQLError('Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)'). autocreate=0[0m
Jul 7 22:00:49 [21135] [1;31mERROR Exception 1: Can't connect to database[0m
Jul 7 22:00:49 [21135] [1;31mERROR 'etc/ispmgr.conf'.'dbserver' try change pos in edit mode[0m
Jul 7 22:00:49 [21135] [1;35mWARNING error while restore form parameters. Can't change pos in edit mode[0m
Jul 7 22:00:49 [21135] [1;32mINFO Request [pkgctl][root] 'out=text&func=exit'[0m
Jul 7 22:00:49 [21135] [1;35mWARNING accept error[0m
Jul 7 22:00:49 [21135] [1;34mNOTE Waiting for threads 1[0m
Jul 7 22:00:49 [21135] [1;34mNOTE Last I have to do ...[0m
Jul 7 22:00:49 [ 0] [1;32mINFO Lookup log level for '/usr/local/ispmgr/var/ispmgr.log' in 'etc/ispmgr.debug'[0m
Jul 7 22:00:49 [29869] [1;34mNOTE ISPmanager-Pro 4.3.53.1 Started. OS Linux-cc6 (i686)[0m
Jul 7 22:00:49 [29869] [1;34mNOTE hostname 'kostyukdg.com'[0m
Jul 7 22:00:49 [29869] [1;36mEXTINFO Load config 'etc/ispmgr.conf'[0m
Jul 7 22:00:49 [29869] [1;36mEXTINFO Load config '/etc/passwd'[0m
Jul 7 22:00:49 [29869] [1;36mEXTINFO Load config '/etc/shadow'[0m
Jul 7 22:00:49 [29869] [1;36mEXTINFO Load config 'etc/ispmgr.ipaccess'[0m
Jul 7 22:00:49 [29869] [1;36mEXTINFO Load config '/etc/exim/domains'[0m
Jul 7 22:00:49 [29869] [1;36mEXTINFO Load config '/etc/exim/passwd'[0m
Jul 7 22:00:49 [29869] [1;36mEXTINFO Load config '/etc/exim/aliases'[0m
Jul 7 22:00:49 [29869] [1;32mINFO detect saslpasswd '/usr/sbin/saslpasswd2'[0m
Jul 7 22:00:49 [29869] [1;36mEXTINFO Load config '/etc/exim/dnsblists'[0m
Jul 7 22:00:49 [29869] [1;36mEXTINFO Load config '/etc/exim/whitelist'[0m
Jul 7 22:00:49 [29869] [1;36mEXTINFO Load config '/etc/exim/blacklist'[0m
Jul 7 22:00:49 [29869] [1;36mEXTINFO Load config '/etc/dovecot.passwd'[0m
Jul 7 22:00:49 [29869] [1;36mEXTINFO Load config '/etc/dovecot.passwd'[0m
Jul 7 22:00:49 [29869] [1;36mEXTINFO Load config '/etc/mail/spamassassin/local.cf'[0m
Jul 7 22:00:49 [29869] [1;36mEXTINFO Load config '/etc/httpd/conf/httpd.conf'[0m
Jul 7 22:00:49 [29869] [1;32mINFO Detected apache version '2'[0m
Jul 7 22:00:49 [29869] [1;32mINFO Use ApacheMPM[0m
Jul 7 22:00:49 [29869] [1;32mINFO Apache config test is off[0m
Jul 7 22:00:49 [29869] [1;36mEXTINFO Execute (/usr/sbin/httpd -M) return=1 exited[0m
Jul 7 22:00:49 [29869] [1;36mEXTINFO Load config 'etc/rotate.conf'[0m
Jul 7 22:00:49 [29869] [1;36mEXTINFO Load config '/etc/nginx/nginx.conf'[0m
Jul 7 22:00:49 [29869] [1;32mINFO Domain MasterIP 'ip'[0m
Jul 7 22:00:49 [29869] [1;36mEXTINFO Load config '/etc/named.conf'[0m
Jul 7 22:00:49 [29869] [1;35mWARNING Can't connect to mgr_support as root@localhost MySQLError('Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)'). autocreate=0[0m
Jul 7 22:00:49 [29869] [1;35mWARNING Load module 'support' error: Can't connect to database[0m
Jul 7 22:00:49 [29869] [1;36mEXTINFO Load config 'var/userconf/ispmgr.root'[0m
Jul 7 22:00:49 [29869] [1;35mWARNING Can't connect to mysql as root@localhost MySQLError('Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)'). autocreate=0[0m
Jul 7 22:00:49 [29869] [1;35mWARNING Can't register dbserver 'MySQL'[0m
Jul 7 22:00:49 [29869] [1;32mINFO Detect enabled firewall[0m
Jul 7 22:00:49 [29869] [1;36mEXTINFO Load config '/etc/sysconfig/iptables'[0m
Jul 7 22:00:49 [29869] [1;32mINFO Detect enabled firewall[0m
Jul 7 22:00:49 [29869] [1;36mEXTINFO Load config '/etc/sysconfig/iptables'[0m
Jul 7 22:00:49 [29869] [1;36mEXTINFO Converting ip assigment[0m
Jul 7 22:00:49 [29869] [1;36mEXTINFO Converting ip done[0m
Jul 7 22:00:49 [29869] [1;36mEXTINFO Execute (crontab -l) return=0 exited[0m
Jul 7 22:00:49 [29869] [1;36mEXTINFO Load config '/var/spool/cron/root'[0m
Jul 7 22:00:49 [29869] [1;36mEXTINFO Execute (crontab -l) return=0 exited[0m
Jul 7 22:00:49 [29869] [1;34mNOTE Begin periodic tasks[0m
Jul 7 22:00:49 [29869] [1;34mNOTE Waiting requests[0m
Jul 7 22:00:51 [29869] [1;32mINFO Request [pkgctl][root] 'out=xml&func=longtask.finish&elid=var%2Frun%2Fispmgr%2Fpkgctl%2Emysql&status=ok'[0m
Jul 7 22:01:07 [29869] [1;32mINFO Request [93.178.82.210][root] 'func=feature&clickstat=yes'[0m
Jul 7 22:01:07 [29869] [1;36mEXTINFO Load config 'skins/sirius/theme.conf'[0m
Jul 7 22:01:07 [29869] [1;36mEXTINFO Load config 'skins/mobile/theme.conf'[0m
Jul 7 22:08:49 [29869] [1;34mNOTE Last I have to do ...[0m[/console]

проблема решена,извените,тему можно удалить

post, как проблему то решили? Напиши, может кому пригодится =)

- Останавливаете MySQL:
- прячете в сторону его /var/lib/mysql;
- подбрасывете ему /var/lib/mysql из упавшей машины;
- стартуете MySQL:
- бекапите нужные базы;
- останавливаете MySQL и возвращаете все на место.


Но после всего этого,оказалось,что тупо бекапы забили память

post написал:

Но после всего этого,оказалось,что тупо бекапы забили память

Вот тут как раз и нужно делать скриптами и вбивать в крон.
Хотя таким образом делать бекап это извращение. Но да ладно, каждый сходит с ума по своему, главнео что всё работает.