Product Version:
ServosityPRO: All
OS: All platforms (with MySQL 5.6 or above)
Problem Description:
When performing a mysql database backup, the following error message is received in the backup report:
| |
|
Backup Logs
|
|
No.
|
Type
|
Timestamp
|
Backup Logs
|
|
1
|
Info
|
YYYY/MM/DD hh:mm
|
Start [ All platforms (ServositySupport), ServosityPRO x.x.x.x ]
|
|
2
|
Info
|
YYYY/MM/DD hh:mm
|
Start running pre-commands
|
|
3
|
...
|
...
|
...
|
|
*
|
Error
|
YYYY/MM/DD hh:mm
|
Warning: Using a password on the command line interface can be insecure.
|
|
|
Note:
This error will only occurs for database backup of MySQL version 5.6 or above.
Cause:
Security enhancement made to MySQL version 5.6 disallowed passwords to be passed via command line.
Resolution:
As a workaround, instead of using the built-in mysql database backup module which specify the password in the command, perform a file backup with a pre-backup command to output the required database file for backup:
1. Specify the password in an option file to avoid giving the password on the command line.
Note:
For mysql installation on Linux / Unix, permission of the my.cnf file must be set to 600.
>chmod 600 .my.cnf
2. Create a file backup set with a pre-backup mysqldump command to output the database file for backup:
- Create a file backup set for the mysql database backup.
- Select the mysqldump output folder (e.g. C:\backup_source) as backup source.
- Download and extract the mysqldump.bat file ( Click Here ) into the MySQL installation bin folder.
- Edit the mysqldump.bat file according to your setup (e.g. MYSQLDUMP_PATH, USERNAME and DATABASE).
- Press the Command Line Tool tab, then the Add button under the Pre-Backup section.
- Specify the working directory to the MySQL installation bin folder, and enter the pre-command similar to the example as shown below:
Working Directory: ${Install_Home}\MySQL Server 5.6\bin
Command: mysqldump.bat
Figure 1.0 - ServosityPRO (Backup Setting - Command Line Tool)
- Press the [OK] button to save this setting, and then perform a backup afterward.
Also See:
http://dev.mysql.com/doc/refman/5.6/en/option-files.html
http://dev.mysql.com/doc/refman/5.6/en/password-security-user.html
|
