At 01:44 AM 2/21/2008, Kevin Chen wrote:
I am trying to relocate MySQL and a database to another hard drive on the
same system. According to this page,
http://dev.mysql.com/doc/refman/5.0/en/upgrading-to-arch.html, I get the
impression that I should be able to do this by copying the data files to the
new MySQL installation. However, that doesn't seem to be sufficient as MySQL
does not "see" the database that was copied over.
Are you using MyISAM tables?
Then you copy just the database subdirectory underneath the old Data
directory to the new Data directory.
Check the "datadir=" in your my.cnf file. This points to the data directory.
If you're using InnoDb tables then someone else will have to chime in
because I don't use it. Sorry.
Mike
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
