On 10/3/2011 9:11 PM, Dan Horning wrote:
On 10/3/2011 3:31 PM, David Roth wrote:What other data is needed to restore a MySQL database besides the directory /var/lib/mysql ? I'm looking into moving the MySQL database to an external RAID 1 on CentOS. Thanks!David Rothin /etc/my.cnf [mysqld] datadir=/var/lib/mysql you can shutdown mysql and move that to any directory you chooseonce you move all the files (DO NOT move them without stopping the mysql service) then you can start the servicehope that helps! _______________________________________________ New York PHP Community MySQL SIG http://lists.nyphp.org/mailman/listinfo/mysql NYPHPCon 2006 Presentations Online http://www.nyphpcon.com Show Your Participation in New York PHP http://www.nyphp.org/show_participation.php
-- -- Dan Horning American Digital Services - Where you are only limited by imagination. [email protected] :: http://www.americandigitalservices.com 1-518-444-0213 x502 . toll free 1-800-863-3854 . fax 1-888-474-6133 PO Box 746, Troy, NY 12181
<<attachment: dan_horning.vcf>>
_______________________________________________ New York PHP Community MySQL SIG http://lists.nyphp.org/mailman/listinfo/mysql NYPHPCon 2006 Presentations Online http://www.nyphpcon.com Show Your Participation in New York PHP http://www.nyphp.org/show_participation.php
