Windows

Change MySQL existing datadir path

Leave a comment

When installing MySQL for Windows using the MSI, the location of my.ini is expected to be C:/ProgramData/MySQL/MySQL Server 5.1.

Please run the following in a DOS Window:

cd C:/ProgramData/MySQL/MySQL Server 5.1
dir *.ini

You will see some sample my.ini files. However, if there is no file named my.ini in that folder, you must create one. Whether one exists or not, please run this:

cd C:/ProgramData/MySQL/MySQL Server 5.1
notepad my.ini

If you are asked to create it, please do so. Continue reading →

Defragmenting your Hard Disk, will make your PC more first .

Leave a comment

As you continuously use your computer by adding, removing, modifying and changing files, your hard disk will become fragmented. Fragmentation occurs when the file system cannot or will not allocate enough continuous space to store a complete file as a unit, but instead puts parts of it in gaps on the hard drive. Larger files and a bigger quantity of files also play a role to fragmentation and performance loss.

Continue reading →