mysql移动文件后打不开_移动数据目录后,MySQL服务器无法启动

我试图将

MySQL的数据目录移动到odroid(覆盆子式迷你计算机)上的外部驱动器.

我使用的是Ubuntu 14.04.

我更改了包含/ var / lib / mysql的所有配置文件中的路径,并在我的新驱动器上移动了所有mysql文件夹.

该服务不再启动,我不知道如何解决这个问题.

以下是所有更改的路径：

root@odroid-server:/etc# grep -rnw '/etc' -e "/var/lib/mysql"

root@odroid-server:/etc# grep -rnw '/etc' -e "/media/md0/mysql"

/etc/apparmor.d/abstractions/mysql:12: /media/md0/mysql{,d}/mysql{,d}.sock rw,

/etc/apparmor.d/tunables/alias:16:# alias /media/md0/mysql/ -> /home/mysql/,

/etc/apparmor.d/usr.sbin.mysqld:49: /media/md0/mysql/ r,

/etc/apparmor.d/usr.sbin.mysqld:50: /media/md0/mysql/** rwk,

/etc/apparmor.d/usr.sbin.mysqld:53: /media/md0/mysql-files/ r,

/etc/apparmor.d/usr.sbin.mysqld:54: /media/md0/mysql-files/** rwk,

/etc/apparmor.d/usr.sbin.mysqld:57: /media/md0/mysql-keyring/ r,

/etc/apparmor.d/usr.sbin.mysqld:58: /media/md0/mysql-keyring/** rwk,

/etc/imscp/imscp.conf:37:DATABASE_DIR = /media/md0/mysql

/etc/mysql/mysql.conf.d/mysqld.cnf:36:datadir = /media/md0/mysql

/etc/mysql/mysql.conf.d/mysqld.cnf:92:# InnoDB is enabled by default with a 10MB datafile in /media/md0/mysql/.

/etc/mysql/mysql.conf.d/mysqld.cnf:98:# chroot = /media/md0/mysql/

然后启动服务：

root@odroid-server:/etc# service mysql start

Job for mysql.service failed because the control process exited with error code. See "systemctl status mysql.service" and "journalctl -xe" for details.

我尝试了该命令以获取更多细节,我可以看到它仍然使用旧的mysql datadir.

root@odroid-server:/etc# journalctl -xe

Nov 18 13:06:45 odroid-server systemd[1]: Starting MySQL Community Server...

-- Subject: Unit mysql.service has begun start-up

-- Defined-By: systemd

-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel

--

-- Unit mysql.service has begun starting up.

Nov 18 13:06:45 odroid-server mysql-systemd-start[24276]: MySQL data dir not found at /var/lib/mysql. Please create one.

Nov 18 13:06:45 odroid-server systemd[1]: mysql.service: Control process exited, code=exited status=1

Nov 18 13:06:45 odroid-server systemd[1]: Failed to start MySQL Community Server.

-- Subject: Unit mysql.service has failed

-- Defined-By: systemd

-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel

--

-- Unit mysql.service has failed.

--

-- The result is failed.

Nov 18 13:06:45 odroid-server systemd[1]: mysql.service: Unit entered failed state.

Nov 18 13:06:45 odroid-server systemd[1]: mysql.service: Failed with result 'exit-code'.

Nov 18 13:06:45 odroid-server systemd[1]: mysql.service: Service hold-off time over, scheduling restart.

Nov 18 13:06:45 odroid-server systemd[1]: Stopped MySQL Community Server.

-- Subject: Unit mysql.service has finished shutting down

-- Defined-By: systemd

-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel

--

-- Unit mysql.service has finished shutting down.

Nov 18 13:06:45 odroid-server systemd[1]: mysql.service: Start request repeated too quickly.

Nov 18 13:06:45 odroid-server systemd[1]: Failed to start MySQL Community Server.

-- Subject: Unit mysql.service has failed

-- Defined-By: systemd

-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel

--

-- Unit mysql.service has failed.

--

-- The result is failed.

也许有一些命令将配置文件重新加载到ram中？