How to Move MySQL D/B Files (Windows)

Locate your MySQL installation files and central configuration file

basedir="C:/Program Files/MySQL/MySQL Server 5.1/"
Your MySQL configuration is stored in "my.ini" file

Locate your MySQL Database location:

datadir="C:/Documents and Settings/All Users/
Application Data/MySQL/MySQL Server 5.1/Data/"

Stop MySQL service.

Modify My.ini file to point to a new D/B location and Save.

Move your Data directory to a new location

Restart MySQL service.

You are done.  All pages (even if you were in the middle of the editing) continue to work.  Amazing!

(Visited 42 times, 1 visits today)

1 Trackback / Pingback

  1. How to Work with MySQL – Basic Tasks | Domain Web Center

Your question, correction or clarification Ваш вопрос, поправка или уточнение

Editor on duty will review your comment. Can't wait? Discuss your topic right now in forums, if you register and login.     Required fields are marked with * Ваше послание пойдет на просмотр в редакцию. Не можете ждать? Обсудите ваш вопрос прямо сейчас в форуме Русский Круг , ecли вы зарегистрируетесь и войдёте под своим именем.     Поля, обязательные для заполнения, помечены *
* *