How to view and change the location where mysql database files are stored
The mysql database data files are stored by default at: C:\DocumentsandSettings\AllUsers\ApplicationData\MySQL\MySQLServer5.1\ datal, where can I see it?
Of course, from the mysql configuration file, find the installation directory of mysql, find my.ini, and then through the search to find datadir=, the back of the mysql database file is stored in the location of the mysql database file, to modify is also very simple, first of all, the back of the address to change to the address that you want, and then to the original location of the database file stored in the location of all the contents are copied to the new address, and then to the original database file is stored in the location of all the contents are copied to the new address. Then copy all the contents of the original location of the database file to the new address, and then restart the database service on the line.
PS: A quick and easy way to restart the mysql database:
Open a command prompt window by typing cmd into Run, and then enter the command:
netstopmysql//stop mysql service netstartmysql//start
How to view and change the location of the mysql database file
How to view and change the location of the mysql database file
How to view and change the location of the mysql database file
Tag:
How to see where the MySql database physical files are stored
variableslike “%datadir%”;
The database files are stored in this location, and it may be different for each person oh.
C:\ProgramData\MySQL\MySQLServer5.6\Data\
After this, I still think that in the future to use mysql or to configure their own first to a database storage path is better.
How to view MySql database physical file storage location
Tags: mysql physical file storage path storage location