mkdir /home/eloy/applications/mysql-datadir/ Due to some reasons which are out of the scope of this solution, it's highly recommended to not create a data directory under the /home directory, but maybe some of you like me prefer it (it costs more steps). Make a new directory for MySQl's data directory.
Stop the MySQL services systemctl stop rvice Locate the line that contains SELINUX=enforcing and change its value to SELINUX=disabled, save the file and reboot your system. Open the SELinux configuration file nano /etc/selinux/config So it's better to disable it during the following steps and later enable it with some tweaks. use SELinux that enforces mandatory access control policies. Disabling SELinuxįirst of all, let me mention that RedHat-based Linux Distributions (RHELs) like Fedora, CentOS, etc.
Dbngin mysql config how to#
Note: Users of Debian-based distributions like Ubuntu should search how to disable and edit AppArmor and then follow the following steps. I think the following steps will work on other distributions. I could successfully alter the data directory of MySQL or MariaDB, and resolve all related issues on Fedora 30. "MySQL80" that you stopped, to restart it again. Step - 4 : Restarting the service Well, go back to the Services Manager to Start again, Some services stop automatically if they are not in use by other services or programs." - Courtesy: Microsoft Why not simply copy? Well because that's not COOL!, this helps you not lose permissions on the copied folder, so that when you restart MySQL80, it won't give a stupid error: "The MySQL80 service on Local Computer started and then stopped. Launch command prompt (Window + R, cmd, Enter) > xcopy "\C:\ProgramData\MySQL\MySQL Server 8.0" "W:\" /E /H /K /O /XĪnd rename the copied folder to the new datadir value that you changed. Now use xcopy to copy the default datadir to W:\. # datadir=C:/ProgramData/MySQL/MySQL Server 8.0/Data Keep the previous value commented so that you won't have to remember it. Let's changeĭatadir value in my.ini file to this value. Let's say you want your new data directory to be W:_MySQL_Data. Step - 3 : Replacing it with a new data directory. Used by MySQL in default setting (provided they haven't found another better location), but let's check that out.ĭo a CTRL+F to find out datadir in the file.Īctual location currently under use by MySQL for data directory.
Step - 2 : Finding out the current Data directory Goto C:\ProgramData\MySQL\MySQL Server 8.0īy default, there should be a folder here named Data, this is the one which is Locate MySQL80 (80 is for version 8.0, look for the one you've). Now you want to make sure there is enough space to store large databases which you might create in future, and so you thought, Hey! I want to put it into another drive which has got more space. Well, in the end, it has to store them in the form of files with some added jugglery in the application and file format to ensure the Database promises that you learned in Databases classes are intact. MySQL uses a Data directory to store the data of different databases you create.
Dbngin mysql config windows#
In case you're a Windows user and landed here to find out that all answers are for Linux Users, don't get disappointed! I won't let you waste time the way I did.Ī little of bullshit talk before solution:
0 kommentar(er)
