Patrick Nelson wrote: ----------------->>>> Moving a server (RH6.2 w/ 3.23.43) to a temporary system (RH7.3 w/ 3.23.49-3) and I have a mysql dump file created using:
mysqldump -A my-move.sql Just installed the server rpm on the temp system and any attempt to connect gives error because of a password, guessing that's because I've got a blank database. The sanity check is: User auth is done by ldap so the users entered in the mysql database should be ok. Anyone having done a restore, could you please tell me the process you used. The database is very large and I don't want to find out I frigged up hours later. ----------------->>>> I ultimately just did a cold directory copy of "/var/lib/mysql". I was then able to login using: mysql -h localhost -u root -p mysql and restarted the mysqld. Then I changed the specific system names from the old system to new within mysql client with: UPDATE user SET host='<new-system-name>' WHERE host='<old-system-name>'; FLUSH PRIVILEGES; then on the DNS I changed the CNAME of where mydb pointed to and reloaded the zone. Then tested on a few clients... everything worked great. No one even noticed the change. Easier than restoring? I'm not sure, but this was very easy. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
