How to change MySql Data folder location - Windows machine
2. Go to the Data folder location which we see while doing the installation. Usually it is
C:\Documents and Settings\All Users\Application Data\MySQL\MySQL Server 5.1\data
3. delete all files which names begins like ib_log*
4. Go to the mysql installed location . The default location is C:\Program files\MySQL\MySQL Server 5.0
open/edit the my.ini file
5. find the section
#path to the database root
and change the value of datadir
6. save the my.ini file
7. start the MySQL service
No comments:
Post a Comment