Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Changing the Location of the My SQL Database Directory

Posted on 2012-04-01
2
Medium Priority
?
317 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
2 Comments
 
LVL 6

Accepted Solution

by:
Bxoz earned 2000 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

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

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 …
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …

927 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