[MDEV-17769] After changing datadir, unable to start the mariadb Created: 2018-11-19 Updated: 2018-11-19 Resolved: 2018-11-19 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Configuration |
| Affects Version/s: | None |
| Fix Version/s: | N/A |
| Type: | Bug | Priority: | Major |
| Reporter: | Prabha | Assignee: | Unassigned |
| Resolution: | Not a Bug | Votes: | 0 |
| Labels: | None | ||
| Description |
|
Hi, I am new to mariadb, for our upcoming client i am learning Mariadb. I have installed Mariadb 10.2 on centos 7, then i want to change the default datadir from /var/lib/mysql to /home/data. For that i have performed below steps. 1)stopped mysql. [mysqld] 6)changed ownership to mysql:mysql for /etc/my.cnf and new loc. then i tried to start mysql but facing below error message. Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" and "journalctl -xe" for details. Please help me. Thanks, |
| Comments |
| Comment by Elena Stepanova [ 2018-11-19 ] |
|
Have you checked "systemctl status mariadb.service" and "journalctl -xe" for details, as it suggested? |
| Comment by Prabha [ 2018-11-19 ] |
|
Hi Elena, Below is the o/p . tails. Nov 19 20:49:02 mariadb.com systemd[1]: Starting MariaDB 10.2.19 database server... |
| Comment by Elena Stepanova [ 2018-11-19 ] |
|
Well, as you can see, it attempts to find under your home dir files which are not there. Possibly you changed the basedir in the config file, or otherwise indicated a wrong location. Please also note that even if you resolve it, probably it won't work right away, because the service configuration file by default has ProtectHome enabled, and you didn't mention that you have changed it. In general, JIRA is a bug tracking system and isn't a right place for seeking help with your configuration. Please use community forums and mailing lists. You can also consider acquiring a support contract if you don't have one yet; if you do, please file a support ticket for assistance with your configuration. |