MySQL 8 change default data directory

In this video clip we will go through step by step how you can change the data storage directory in MySQL 8.
By default, all data is stored in the /var/lib/mysql directory

0:00 Start
0:19 Checking the current state of the datadir variable
0:48 Create a directory for data
1:10 Editing parameters for the configuration file
1:40 Transferring data from the old directory to the new one
2:06 Restarting the database
2:15 Connecting to the database console
2:20 Rechecking the current state of the datadir variable
3:50 The end

#mysql #mysqldatabase #mysqlcourse #mysqltutorial #datadir #mysqldb #db #database

Тэги:

#mysql #datadir #mysql_data_directory #change_data_directory_mysql #datadir_mysql #mysql_change_database_directory #mysql_data_folder #mysql_data_location #mysql_data_location_linux #mysql_data_path #mysql_database_directory #mysql_directory #change_mysql_data_directory #find_mysql_data_directory #linux_mysql_data_directory #move_mysql_data_directory #mysql_create_data_directory #mysql_data_dir #mysql_data_file_location_linux #mysql_data_path_linux #mysql_datadir_change

Скачать видео