DA and MySQL 5.1 - error in databases dumps!

[AnVir]

After upgrade MySQL from 5.0 to 5.1 all dumps in user's backups contain as first line:

Warning: The option '--all' is deprecated and will be removed in a future release. Please use --create-options instead.

So databases backups cannot be restored automatically...
Please, suggest where I can change backup or restore script to avoid it (change mysqldump options or insert sed parser to crop this line)...
Now i see only way to fix it - rename mysqldump binary and replace it with my own script, changing --all option.

 

[scsi]

A warning is nothing more then a message. It will not stop the program from running.

 

[AnVir]

A warning is nothing more then a message. It will not stop the program from running.

Ok, just try to insert this string into any .sql file and import it in database...

 

[DirectAdmin Support]

Hello,

I've modified the mysqldump code to use --create-options instead of --all for the next release of DA.

John

 

[bjseiler]

Any idea when the next release of DA is? If this is preventing restores from working without editing them, that is a big problem.

 

[nobaloney]

The newest release includes this.

Jeff

 

[harro]

Hi all,

you mentioned before that dumps from 5.0.x to 5.1 failed but this (indeed) works now. However, restoring msql dumps from 5.1 to 5.0.x (on another DA server, for example) can fail! I have some accounts with large databases and these fail with the following error on BTREE:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'USING BTREE,
KEY `FK_ATTRIBUTE_VARCHAR_ENTITY` (`entity_id`),
KEY `FK_CATALO' at line 9

On forums I read this can be attributed to trying to restore a 5.1 dump to 5.0.

Two questions from my side, perhaps someone can help me out:

1) is there a way to overcome this / to remove the BTREE entry from the huge sql dumps?

2) does DA support MySQL version 5.1, or is this not recommended?

Kind regards,

Harro