Configure database creation in another folder

Asked

Viewed 28 times

-1

You can change the mysql database source folder?

I wanted to change his source folder

mysql

  • See there for the Brothers https://stackoverflow.com/questions/1795176/how-to-change-mysql-data-directory

  • I use windows, this forum did not help much no

1 answer

4

Yes, you can stop the service and change the path in the configuration file of mysql.

If it is Windows, the file is my.ini, and is in the application data folder, usually in "C: Programdata Mysql".

If it is Linux, the file is mysqld.cnf, and is usually in "/etc/mysql".

Use your preferred editor and change the folder in "dated=", then restart the service.

  • Buddy, it didn’t work out for me

  • I am changing the date to a new folder, the service does not start

  • but besides changing you copied or restored the databases in the new folder?

Browser other questions tagged mysql

You are not signed in. Login or sign up in order to post.