Re: Moving to another hard drive
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]
Re: Moving to another hard drive
Hi, 1) check with the owner & permission of the copied data folder 2) GRANT ALL permission to access that db (name of the copied folder) Thanks ViSolve DB Team - Original Message - From: "Kevin Chen" <[EMAIL PROTECTED]> To: Sent: Thursday, February 21, 2008 1:14 PM Subject: Moving to another hard drive 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. - Looking for last minute shopping deals? Find them fast with Yahoo! Search. No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.516 / Virus Database: 269.20.9/1290 - Release Date: 2/20/2008 8:45 PM -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Moving to another hard drive
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. - Looking for last minute shopping deals? Find them fast with Yahoo! Search.