![]() ![]() Mv /var/log/mysql/ /home/mysql/mysql-logs Now, stop MySQL, move the folders to the right location, reconfigure MySQL and start again: # Stop MySQL Open tables: 17 Queries per second avg: 26.000. ![]() ![]() Threads: 1 Questions: 78 Slow queries: 0 Opens: 23 Flush tables: 1 This is free software,Īnd you are welcome to modify and redistribute it under the GPL license This software comes with ABSOLUTELY NO WARRANTY. usr/bin/mysqladmin Ver 8.41 Distrib 5.0.51a, for debian-linux-gnu on i486 ![]() To check the status: /etc/init.d/mysql status This article describes how to move these two folders to ‘/home’ which is ideally mounted into another disk and has enough space to keep your database data and logs.įirst, I install the required apt-get packages as follows: apt-get update That may cause your database server system disk to get full, which is never a good idea. By default MySQL keeps them in the root mount point (i.e. Once the installation is completed, the MySQL service will start automatically.While installing MySQL Server it is always good to keep in mind that the logs and data folders will potentially have a big size. Select OK by pressing Tab and hit Enter (as shown in the image above). We’re going to install MySQL version 8.0. To add the MySQL APT repository to your system go to the repository download page and download the latest release package using the following command. Once you have updated the setup you can start the setup. Start by updating the packages to the latest version available using the following command.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |