Solved

MySQL & Open Remote Directory

Posted on 2012-04-03
1
148 Views
Last Modified: 2012-04-19
I have installed MySQL on my local Windows computer.  It is working and I can access the sample databases.  I also have another MySQL data folder that contains copies of my production databases.  How do I open this "second" data folder?  I can copy it locally.
0
Comment
Question by:deklinm
1 Comment
 
LVL 24

Accepted Solution

by:
johanntagle earned 500 total points
Comment Utility
You can only open one data directory at a time.  to switch to the new directory, shut down mysql, Find your my.ini file, open it and change the data-dir entry to the new location.  Then restart mysql.  Note that this assumes that the new data dir is valid, meaning it includes its own mysql schema, etc.  Another thing to note is if the ib_logfile's on the new directory have different size as the original one.  If so you either make another change in your my.ini (look for something like innodb-log-file-size and set the value to the size of the new files), or you can delete the existing ib_logfile's so mysql will create new ones on startup.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Loading csv or delimited data files to MySQL database is a very common task frequently questioned about and almost every time LOAD DATA INFILE comes to the rescue. Here we will try to understand some of the very common scenarios for loading data …
This guide whil teach how to setup live replication (database mirroring) on 2 servers for backup or other purposes. In our example situation we have this network schema (see atachment). We need to replicate EVERY executed SQL query on server 1 to…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

772 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now