Shulou(Shulou.com)06/01 Report--

This article mainly introduces the method of mysql to open the database file location, the article is very detailed, has a certain reference value, interested friends must read it!

Mysql opens the database file location: first open the mysqml folder to find the [my.ini] file, then select [notepad to open], and finally press [ctrl+f] to search [datadir] to find it.

The method for mysql to open the database file location:

Step 1: open the mysqml folder, show the following file, and find the my.ini file, as shown in the figure.

Step 2: select the my.ini file, then click the right mouse button and select "Open with" and then select "notepad Open"

Step 3: after opening the my.ini file in notepad, press ctrl+f to search for "datadir" to find the physical path to your database

Step 4: if you want to change the storage location of the database file, you can modify it directly here, as shown in the red box below.

Step 5: according to the path found above, we open the data folder of the above path, which is shown in the following figure.

Step 6: if you want to move the database, just copy the folder "data" and overwrite the "data" file in the new environment.

These are all the contents of mysql's method of opening the location of the database file. Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.