Backup/Restore failing between 2 machines
Posted by:
Jim Lord
Date: February 22, 2012 03:16PM
We run this command to backup our mySQL INNODB database:
sudo mysqlhotcopy -u root --allowold $db $mysql
When I copy the resulting file to our failover machine and try to restore the database, I get a mysql cannot connect error.
This used to work when we used the MyISAM format but since we recently switched to INNODB format, this process fails.
Both Jira servers (Production and Regression) are:
mysql Ver 14.12 Distrib 5.0.24a, for slackware-linux-gnu (i486)
IF I try to do the backup/restore (using mysqlhotcopy) on the SAME machine, there is no issue. But, when I try to backup Jira1, transfer the data to Jira2 and restart mysql, I get a cannot connect to socket error. Is the hostname embedded in the INNODB data or is there something that makes this activity impossible?
Subject
Views
Written By
Posted
Backup/Restore failing between 2 machines
2809
February 22, 2012 03:16PM
1590
February 22, 2012 03:20PM
1296
February 24, 2012 12:07AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.