мускул работает под рутом
[00:47][root@ххх ps ax|grep sql
19160 pts/0 S 0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --socket=/var/lib/mysql/mysql.sock --log-error=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid
19222 pts/0 Sl 0:00 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=root --pid-file=/var/run/mysqld/mysqld.pid --skip-external-locking --socket=/var/lib/mysql/mysql.sock
останавливаю сервер:
[00:48][root@ххх]# /etc/init.d/mysqld stop
Stopping MySQL: [ OK ]
[00:48][root@ххх]# ps ax|grep sql
19285 pts/0 S+ 0:00 grep sql
1. поменял в my.cnf --> user=mysql-user
2. Дамп создан уже.
3. есть
4. есть
5.
[01:46][root@ххх:/usr/mysqldunp/all]# rm /var/run/mysqld/mysqld.pid
rm: cannot remove `/var/run/mysqld/mysqld.pid': No such file or directory
[01:46][root@ххх:/usr/mysqldunp/all]# rm /var/lib/mysql/mysql.sock
rm: cannot remove `/var/lib/mysql/mysql.sock': No such file or directory
готово.
6.
Запускаем и читаем tail -f /var/log/mysql/mysqld.log
081121 01:55:41 mysqld started
081121 1:55:41 InnoDB: Started; log sequence number 0 43655
081121 1:55:41 [ERROR] Can't start server : Bind on unix socket: Permission denied
081121 1:55:41 [ERROR] Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ?
081121 1:55:41 [ERROR] Aborting
081121 1:55:41 InnoDB: Starting shutdown...
081121 1:55:43 InnoDB: Shutdown completed; log sequence number 0 43655
081121 1:55:43 [Note] /usr/libexec/mysqld: Shutdown complete
081121 01:55:43 mysqld ended
[01:57][root@ххх:/var/log/mysql]# ps ax|grep sql
20092 pts/1 S+ 0:00 mcedit sql-dump.sql
20275 pts/2 S+ 0:00 tail -f /var/log/mysql/mysqld.log
20392 pts/4 S+ 0:00 tail -f /var/log/mysql.log