MySQL on Windows – Questions Answered

 

I just installed WordPress with MySQL.  I am familiar with all the intricacies of SQL Query.  I am asking from MS SQL Admin point of view.  These questions from a person who never saw MySQL before: 

 – Where DB files are located?    – See other post
– Is DB backup available and free?
– How to add new tables and fields?
– How to move database from one PC to another?    – See bellow and other post
– Is ODBS driver is available – Yes!
– Is GUI software is available – Yes! 

I am sure I will find answers pretty easy, but if you have any tips and tricks, please reply.

Within days of original post, I had to find answers to some of these questions.

Where MySQL D/B files are located

On a default Win XP install D/B files go to %UserProfile%/Application Data\MySQL
You can easily move these files any where you want:
-01- Stop MySQL service
-02- Move your D/B files
-03- Adjust my.ini settings to point to a new location
-04- Restart the service

(Visited 50 times, 1 visits today)

Be the first to comment

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