Skip to main content
commvault.com commvault.com
Solved

Unable to restore mysql database

  • February 17, 2021
  • 2 replies
  • 1865 views
M
Bit
Forum|alt.badge.img

Hi, 

Setup is something like MySql is running on a windows server and HDPS is also running on Windows platform. Mysql server is behind the firewall. Required ports have been opened for backup and restore work. Taking back up can be done successfully but while trying to restore any backed up database, it is giving an error. [Error Code: [24:42]
Description: Cannot start restore program on host [MySqlServerName*MySqlServerName*8400] - a network error occurred or the product's services are not running.
Source: ma-servername, Process: fsIndexedRestore

Best answer by Damian Andre

What's interesting on restore for (in most cases, not all) is that the Media Agent initiates the restore on the client. On a backup, the CommServe initiates the backup and communicates with the client-server, which then connects to the media agent. But on restore, the Media Agent typically reaches out to the client in the networking flow. So my bet is that if you try telnet or cvping from the MA to the client, there is a connection failure there or some sort of firewall blocking a connection between those two. It could also be DNS, where the Media Agent cannot resolve the client but the CommServe can..

That might give you some info to start exploring further.

View original
Did this answer your question?

2 replies

Mike Struening
Vaulter
Forum|alt.badge.img+23

Hey @MySql Backup & Restore , welcome and thanks for the post!

On a side note, it looks like your user display name is MySQL Backup & Restore, so send me a private message if you e=want it changed (and what I should change it to)!

For your error, it definitely looks like a communication issue.  fsIndexedRestore.log and CVD.log should give us a good place to start.

Can you confirm what is opened in your firewall exclusions and how?  Is there any filtering done on the executables itself?

I’m thinking it is most likely a port issue, however.

https://www.linkedin.com/in/michael-struening
Damian Andre
Vaulter
Forum|alt.badge.img+23
  • Damian AndreVaulter
  • Vaulter
  • 1297 replies
  • Answer
  • February 17, 2021

What's interesting on restore for (in most cases, not all) is that the Media Agent initiates the restore on the client. On a backup, the CommServe initiates the backup and communicates with the client-server, which then connects to the media agent. But on restore, the Media Agent typically reaches out to the client in the networking flow. So my bet is that if you try telnet or cvping from the MA to the client, there is a connection failure there or some sort of firewall blocking a connection between those two. It could also be DNS, where the Media Agent cannot resolve the client but the CommServe can..

That might give you some info to start exploring further.

G
1 person likes this
  • G
    Godwin

Reply


Most helpful members this week

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings