Is it possible to change the source folder of the mysql database?
I wanted to change his home folder
Is it possible to change the source folder of the mysql database?
I wanted to change his home folder
Yes, you can stop the service and change the path in the mysql
configuration file.
If it is Windows , the file is my.ini
, and stays in the application's data folder, usually under "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 to "datadir=", then restart the service.