How to change MySQL data directory?

by

  1. Stop MySQL using the following command:

    sudo /etc/init.d/mysql stop

  2. Copy the existing data directory (default located in /var/lib/mysql) using the following command:

    sudo cp -R -p /var/lib/mysql /newpath

  3. edit the MySQL configuration file with the following command:

    sudo gedit /etc/mysql/my.cnf   # or perhaps /etc/mysql/mysql.conf.d/mysqld.cnf

  4. Look for the entry for datadir, and change the path (which should be /var/lib/mysql) to the new data directory.

  5. In the terminal, enter the command:

    sudo gedit /etc/apparmor.d/usr.sbin.mysqld

  6. Look for lines beginning with /var/lib/mysql. Change /var/lib/mysql in the lines with the new path.

  7. Save and close the file.

  8. Restart the AppArmor profiles with the command:

    sudo /etc/init.d/apparmor reload

  9. Restart MySQL with the command:

    sudo /etc/init.d/mysql restart

  10. Now login to MySQL and you can access the same databases you had before.

More Related Contents:

  1. Return a default value if single row is not found
  2. MySQL: set field default value to other column
  3. Create a Cumulative Sum Column in MySQL
  4. Equivalent of explode() to work with strings in MySQL
  5. 1064 error in CREATE TABLE … TYPE=MYISAM
  6. mysql select dynamic row values as column names, another column as value
  7. Run MySQLDump without Locking Tables
  8. How to convert number of week into date?
  9. count(*) and count(column_name), what’s the diff?
  10. When to use SELECT … FOR UPDATE?
  11. MySQL Select Date Equal to Today (having datetime as the data type)
  12. BULK INSERT in MYSQL
  13. Count table rows
  14. MYSQL sum() for distinct rows
  15. How to deploy local MySQL database to Heroku
  16. Should I use MySQL blob field type?
  17. How to lock a single row
  18. MySQL Cannot drop index needed in a foreign key constraint
  19. MySQL Insert & Joins
  20. Does MySQL overwrite a column of same value on update?
  21. How to join two tables using a comma-separated-list in the join field
  22. MySQL selecting yesterday’s date
  23. Does MySQL included with MAMP not include a config file?
  24. How to regex in a MySQL query
  25. How do I write an SP in phpMyAdmin (MySQL)?
  26. Syntax error on MERGE statement
  27. INSERT INTO Table from multiple tables
  28. Mysql How do you create a clustered index?
  29. Counting associated entries with Sequelize
  30. MySQL data directory location

Leave a Comment