Solved

Changing the Location of the My SQL Database Directory

Posted on 2012-04-01
2
314 Views
Last Modified: 2012-04-01
I'm new to My SQL . I installed My SQL version 5.2.38 and the default Directory location for the database is Program Data/MySQL/MySQL Server 5.5/data . Is this controled with the my.ini file? How can I change the location so can put the data on the server directory?

Thanks,
Mike
0
Comment
Question by:miker454
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 6

Accepted Solution

by:
Bxoz earned 500 total points
ID: 37792555
Yes you can change the default datadir in my.ini.

But do a backup before an stop the MySql services
http://technicians-blog.kingcomputer.com.au/how-to-move-mysql-database-on-windows-server/
0
 

Author Closing Comment

by:miker454
ID: 37793574
Got it,
Thank you,
Mike
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Audit has been really one of the more interesting, most useful, yet difficult to maintain topics in the history of SQL Server. In earlier versions of SQL people had very few options for auditing in SQL Server. It typically meant using SQL Trace …
There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…

630 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question