You didn't say which version of MySQL you are using, or if you are using
InnoDB tables. I'll assume you are using MyISAM tables, and are **adding** a
drive to the system.
1. Install / mount the new drive so it is available to the O/S and assign it
a drive letter.
2. Stop the MySQL Server (in DOS: NET STOP MYSQL)
3. Copy the entire \data directory from \mysql to the new drive.
4. In DOS, CD\WINNT and EDIT MY.INI
5. Locate the line with datadir ... i.e.:
datadir = C:/mysql/data/
... and edit to reflect the new location of your data on the new drive
... i.e.:
datadir = E:/mysql/data/
6. In DOS, start the MySQL server (NET START MYSQL)
G. Jensen
----- Original Message -----
From: "Sparky Kopetzky" <[EMAIL PROTECTED]>
To: "My Sql List" <[EMAIL PROTECTED]>
Sent: Thursday, July 10, 2003 12:24 AM
Subject: Moving DB
I have a database that is getting too big for the drive it's on. How do
change my.ini to make it see everything after I move the mysql/data folder??
or is there more to it than that?? BTW - I'm running on Windows NT 4.0 SP6
w/ gig of ram...
Robin E. Kopetzky
Black Mesa Computers/Internet Services
www.blackmesa-isp.net
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
