Bug #33148 falcon mysqldump does not include tablespace info
Submitted: 11 Dec 2007 18:48 Modified: 15 May 2009 13:11
Reporter: jey Razack Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Falcon storage engine Severity:S3 (Non-critical)
Version:6.0.3-alpha, 6.0-BK OS:Linux (RHEL 4)
Assigned to: Sergey Vojtovich CPU Architecture:Any
Tags: F_TABLESPACE, falcon, mysqldump
Triage: Triaged: D3 (Medium) / R3 (Medium) / E4 (High)

[11 Dec 2007 18:48] jey Razack
Description:
mysqldump with --skip-opt option truncates the tablespace clause.

 /*!50100 TABLESPACE mytablespace */

Also I don't see an option to dump 'CREATE TABLESPACE ...' statements.

How to repeat:
mysqldump --user=root -p --all-tablespaces --create-options=true --skip-opt mydb > mydb.dmp
[31 Jan 2008 23:08] Sveta Smirnova
Thank you for the report.

Verified as described.

cat bug31148.test:
CREATE TABLESPACE tablespace
    ADD DATAFILE 'file'
    ENGINE = Falcon;
	
create table t1(id int) engine=falcon;

insert into t1 values(1);

--exec $MYSQL_DUMP --all-tablespaces test
--exec $MYSQL_DUMP --skip-opt test
--exec $MYSQL_DUMP test
[12 Dec 2008 11:58] Sergey Vojtovich
mysqldump --skip-opt sets NO_TABLE_OPTIONS flag in SQL_MODE (http://dev.mysql.com/doc/refman/6.0/en/server-sql-mode.html#sqlmode_no_table_options):

Do not print MySQL-specific table options (such as ENGINE) in the output of SHOW CREATE TABLE. This mode is used by mysqldump in portability mode. 

Won't fix this issue within the scope of this bug.
[15 Dec 2008 14:48] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/61680

2934 Sergey Vojtovich	2008-12-15
      BUG#33148 - falcon mysqldump does not include tablespace info
      
      mysqldump didn't include tablespace definition when dumping
      Falcon tables, that use custom tablespaces.
      
      With this fix Falcon tablespace definition is dumped.
[17 Dec 2008 14:12] Alexander Barkov
The patch looks fine for me.
[18 Dec 2008 8:32] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/61937

2934 Sergey Vojtovich	2008-12-18
      BUG#33148 - falcon mysqldump does not include tablespace info
      
      mysqldump didn't include tablespace definition when dumping
      Falcon tables, that use custom tablespaces.
      
      With this fix Falcon tablespace definition is dumped.
[13 Feb 2009 7:25] Bugs System
Pushed into 6.0.10-alpha (revid:alik@sun.com-20090211182317-uagkyj01fk30p1f8) (version source revid:hky@sun.com-20081218223730-ujuygclo2fezfurq) (merge vers: 6.0.9-alpha) (pib:6)
[15 May 2009 13:11] MC Brown
An entry has been added to the 6.0.10 changelog: 

The mysqldump command would not include the TABLESPACE information for Falcon tables within the dump information.