Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-17769

After changing datadir, unable to start the mariadb

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • None
    • N/A
    • Configuration
    • 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.
      2)created new dir.
      3)copied all the data from old to new location.
      4)copied my-small.cnf from /usr/share/myql/ to /etc/my.cnf(since i didnt get the default my.cnf).
      5)added below lines

      [mysqld]
      datadir=<new loc>
      socket=/<new loc>/mysql.sock
      [client]
      port=3306
      socket=/<new loc>/mysql.sock

      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,
      Prabha.

      Attachments

        Activity

          People

            Unassigned Unassigned
            prabha Prabha
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.