How to change the storage path of MySQL database

Change MySQL Tutorial database Tutorial Storage Path method

Open your MySQL installation directory and find the My.ini file (mine is studymysql download in the C:Program filesphp tutorial)

Search DataDir or #path to the database root

Datadir= "e:/mysql/data/"

Change the e:/mysql/data/into your database to save the address,

Note: After you modify the database path, you can copy all the files in the previous directory to the new directory. Oh, remember to stop the MySQL server again operation.

Original site of the transfer note from http://www.111cn.nethttp://www.111cn.net/database/database.html otherwise must investigate