DP - MYSQL backup agent problem (629 Views)
Occasional Contributor
Posts: 5
Registered: ‎12-24-2013
Message 1 of 3 (629 Views)
Accepted Solution

DP - MYSQL backup agent problem

I defined a new linux server in DP, but it is not possible to run a MYSQL agent on him.
So I need to write a script that copy all MySql data on this server to folder which the DP will backup.

any idea how?

Occasional Visitor
Posts: 2
Registered: ‎12-25-2013
Message 2 of 3 (601 Views)

Re: DP - MYSQL backup agent problem

Until HP starts supporting MySQL officially(an enhancement request QCCR2A44538 is considered),

you can use the Oracle recommendations:




To backup the MySQL database, first prepare the database by:

  •  Obtaining a read lock on all tables in slee_db, and
  •  Flushing all cached data to the database files.

After preparing the database, use one of the available MySQL backup scripts, such as mysqldump or mysqlhotcopy, to create an offline copy of the database. The exact tool and procedure you use depends on the type of database you have created (InnoDB, MyISAM, ISAM). See the MySQL Developer Zone to determine which backup utility and strategy best meets your needs.

You may also consider using the --log-bin option when starting MySQL to record database updates in a binary log file. The binary log acts as an incremental backup, and it can be applied to the a full database backup to restore the database to a more recent point in time."

Occasional Contributor
Posts: 5
Registered: ‎12-24-2013
Message 3 of 3 (563 Views)

Re: DP - MYSQL backup agent problem

thank you, for the following the script i use is :
mysqldump --database ***--events -f --add-lock --compress > mobileSchemaBackFile__$date.sql
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.