CODEWITHSUNDEEP
mysqlmysql-backup
Lavanya
Lavanya

Reputation: 1

mysqlbackup: ERROR: Found extraneous commands at the end

I'm tring to take backup of database using MysqlEnterpriseBackup tool (Mysqlbackup) command using below command:

mysqlbackup --defaults-file=/etc/my.cnf --user=Username -p --port=3306 --socket=/path/mysql.sock --with-timestamp --databases=dbname --datadir=/path/mysql --backup-dir= /backup path/foldername backup-and-apply-log

Below error I can see :

MySQL Enterprise Backup version 4.0.0 Linux-3.8.13-16.2.1.el6uek.x86_64-x86_64 [2015/10/17] Copyright (c) 2003, 2015, Oracle and/or its affiliates. All Rights Reserved.

mysqlbackup: INFO: Starting with following command line ...

mysqlbackup --defaults-file=/etc/my.cnf --user=Username -p --port=3306 --socket=/path/mysql.sock --with-timestamp --databases=dbname --datadir=/path/mysql --backup-dir= /backup path/foldername backup-and-apply-log

mysqlbackup: ERROR: Found extraneous commands at the end. Use --help option for usage description.

mysqlbackup failed with errors!

Can you please help me to resolve the above error?

Upvotes: 0

Views: 1104

Answers (2)

jhether
jhether

Reputation: 1

If there is a space after "backup_dir=" and before the backup path as shown in the output above that would cause this error.

Upvotes: 0

Henry Nino
Henry Nino

Reputation: 1

Please make sure that the last argument of the command must be: backup-to-image, backup or backup-and-apply-log

Upvotes: -1

Related Questions