Bug #58968 ibbackup problem if datadir path in my.cnf has multiple trailing path separators
Submitted: 16 Dec 2010 10:06 Modified: 29 Dec 2011 20:04
Reporter: Victor Kirkebo Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Enterprise Backup Severity:S3 (Non-critical)
Version:3.5.2 OS:Any
Assigned to: CPU Architecture:Any

[16 Dec 2010 10:06] Victor Kirkebo
Description:
If the datadir path in my.cnf is poorly formatted, i.e. with more than one trailing path separator this affects backup of per-table tablespaces. Specifically ibbackup will create additional directories with erroneous names for each database - instead of <backup dir>/<database> it will create <backupdir><database>, i.e. with a missing path separator. The per-table ibd files will be copied to these directories.

How to repeat:
Run a backup on a database with per-table tablespaces where datadir in my.cnf has more than one trailing path separator. e.g:

[mysqld]
datadir=/export/home/tmp/test/mysql-5.5.8-linux-x86_64/mysql-test/my_var_dir/mysqld.1/data//
.
.
.
.
[16 Dec 2010 18:05] Sveta Smirnova
Thank you for the report.

Verified as described. Problem is not repeatable if use 5.1 MySQL server.
[16 Feb 2011 1:39] Hema Sridharan
I am not able to reproduce this issue with MEB 3.5.2 version and also in MEB 3.6 version. I think we can close this bug.
[18 Feb 2011 17:14] Hema Sridharan
Please ignore my previous comment. I was able to reproduce the behavior even in mysql-5.1-meb tree using the latest patch of meb 3.6 version from /bzrroot/meb/sbin-repo/single-bin
[27 Jun 2011 11:54] MySQL Verification Team
See http://bugs.mysql.com/bug.php?id=61655.
[29 Dec 2011 20:04] Hema Sridharan
This bug is fixed in MEB 3.6 version.
[20 Jun 2012 1:59] yongyong lai
This bug still can be reproduced in MEB 3.7.1, the following is my.cnf configuration:

datadir = /opt/mysql/data

when i do the mysqlbackup, a directory named /opt/mysqldbdata is created, and the backup data files is copied to that directory either.
[20 Jun 2012 2:45] yongyong lai
using qutos can resolve this issue.
like datadir = '/opt/mysql/data'
[26 Jun 2012 17:07] Sveta Smirnova
yongyong lai,

thank you for update. I can not repeat described behavior, so looks like you experience new issue. Please open separate bug report, upload full configuration file and exact steps you perform to take backup.