If you are running Ubuntu, you need to update your apparmour config at this point. You may also want to change the following variables as the logs can take up a lot of space. For MariaDB on Debian 10 it was /etc/mysql//50-server.cnf Sudo sed -i "s $SEARCH $REPLACE " $FILEPATHīe sure to check the $FILEPATH. Update the mysql configuration so that it knows where the data is stored. Grant root permisson, stop MySQL deamon: /etc/init. I think, at first you had to make a dir, where you want to put the selected database's files. Stop the mysql service sudo service mysql stop MySQL stores the database data in separated dirs in /var/lib/mysql. UUID="xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx" $MOUNT_POINT ext4 defaults 0 2 Use sudo blkid to get the UUID of your disk. Update your /etc/fstab file to automatically mount on boot. Mount the drive sudo mount $DISK_LOCATION $MOUNT_POINT DISK_LOCATION="/dev/sdb"Ĭreate a filesystem sudo mkfs -t ext4 $DISK_LOCATIONĬreate a mount point sudo mkdir $MOUNT_POINT To make the steps agnostic, I am going to use the following variables which may vary on your system/configuration. These steps can also be followed on Ubuntu systems, but will require some additional steps for configuring Apparmor. This tutorial will shown you how to move your database on a Debian 7.x server to another location, and are assuming another drive. Alternatively, you may wish to move your database to a separate location because you want to configure some sort of snapshotting technique, such as with ZFS or LVM. < drive > is the drive letter where components are installed. For Example, C:\Program Files\MySQL\MySQL Server 5.5\my.ini 2) Open the my.ini with notepad. Common files used by all instances on a single computer are installed in the folder < drive >:Program FilesMicrosoft SQL Server nnn.Databases are constantly growing and it is likely to outgrow your / partition at some point, especially these days in the age of "the cloud" where you may be limited to a small / partition, but can pay to add bulk storage, or attach more disks. You can find MySQL database location on your hard disk in the following ways: MySQL database location in Windows 1) Locate the my.ini file, which store in the MySQL installation folder.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |