Skip to main content
commvault.com commvault.com
Solved

MySql pre and post scripts

N
Bit
Forum|alt.badge.img+2

Hi Team,

I am successfully took the backup of mysql database, but now I have to run pre and post scripts. I want to run application consistent backup for mysql database so for this I got the pre and post scripts from below link.

https://documentation.commvault.com/v11/essential/137017_pre_freeze_script_mysql.html

Can you please let me know, where to add this scripts. I mean in sql database where should I load the scripts and how can I execute this.

Can you please help me to solve this.

 

Thanks

Naveen

Best answer by Scott Moseman

Naveenkumarhn wrote:

I am trying MySQL DB app consistent backup, as you said if we dont need to run any pre and post scripts how they app consistent will work for mysql.

I have another question, when I check mysql database properties, I can see pre-post scripts tab so there I can upload the pre and post scripts? but not sure which path I have to give.


The pre/post script paths are locations locally on the Client.  You can click Browse to see.

However, as mentioned, the MySQL agent doesn’t require any pre/post scripts for consistency.

The documentation you shared is for a VM running MySQL in Google Cloud.  These do not apply if you’re talking about the MySQL agent installed on a Client.

Thanks,
Scott
 

View original
Did this answer your question?
If you have a question or comment, please create a topic

4 replies

Sunil
Vaulter
Forum|alt.badge.img+13
  • SunilVaulter
  • Vaulter
  • 300 replies
  • April 18, 2022

Hi @Naveenkumarhn 

Are you doing Virtual server backups and make MySQL DB app consistent?

For agent based MySQL backups we don’t need to run any pre-post scripts to keep backup consistent.

 

Thanks,

Sunil-

MichaelCapon
1 person likes this
  • MichaelCapon
    MichaelCapon
N
Bit
Forum|alt.badge.img+2

Hi @Sunil 

Thanks for your quick reply.

I am trying MySQL DB app consistent backup, as you said if we dont need to run any pre and post scripts how they app consistent will work for mysql.

I have another question, when I check mysql database properties, I can see pre-post scripts tab so there I can upload the pre and post scripts? but not sure which path I have to give.

 

Thanks,

Naveen

Sunil
Vaulter
Forum|alt.badge.img+13
  • SunilVaulter
  • Vaulter
  • 300 replies
  • April 18, 2022

Hi @Naveenkumarhn 

I meant, for MySQL agent based backups we don’t need to run any scripts. In the backup process itself we run “flush tables with read lock” which ensures the consistency of the dump.

However, I still didn’t understand if you are running VM backups using VSA agent or direct database backups using MySQL agent.

 

Thanks,

Sunil-

 

Scott Moseman
Vaulter
Forum|alt.badge.img+18
Naveenkumarhn wrote:

I am trying MySQL DB app consistent backup, as you said if we dont need to run any pre and post scripts how they app consistent will work for mysql.

I have another question, when I check mysql database properties, I can see pre-post scripts tab so there I can upload the pre and post scripts? but not sure which path I have to give.


The pre/post script paths are locations locally on the Client.  You can click Browse to see.

However, as mentioned, the MySQL agent doesn’t require any pre/post scripts for consistency.

The documentation you shared is for a VM running MySQL in Google Cloud.  These do not apply if you’re talking about the MySQL agent installed on a Client.

Thanks,
Scott
 

Commvault Enterprise Success

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