Bug #40285 Documentation is incorrect when defining the checkbox 'Dont write full path'.
Submitted: 23 Oct 2008 18:39 Modified: 14 Nov 2008 14:49
Reporter: Zach Legein Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL GUI Common: Docs Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: Tony Bedford CPU Architecture:Any
Tags: documentation

[23 Oct 2008 18:39] Zach Legein
Description:
On the following page the documentation is incorrect when describing the the 'Dont write full path' checkbox option, when performing backups. It should read:

"Check this option if you plan to restore your database objects to a different database."

http://dev.mysql.com/doc/administrator/en/mysql-administrator-backup-advanced-options-outp...

Fully Qualified Identifiers causes MySQL Administrator to write statements in the format, schema_name.table_name, instead of writing only the object name. 

(Under Linux this check box is labeled Don't write full path.) Don't check this option if you plan to restore your database objects to a different database. 

How to repeat:
Goto http://dev.mysql.com/doc/administrator/en/mysql-administrator-backup-advanced-options-outp... and look at the wording:

Fully Qualified Identifiers causes MySQL Administrator to write statements in the format, schema_name.table_name, instead of writing only the object name. 

(Under Linux this check box is labeled Don't write full path.) Don't check this option if you plan to restore your database objects to a different database. 

Suggested fix:
Remove the word: "Don't" in the sentence:

Don't check this option if you plan to restore your database objects to a different database.
[23 Oct 2008 18:41] Zach Legein
Tiny url of the page in question:

http://tinyurl.com/5f7mee
[24 Oct 2008 3:45] Valeriy Kravchuk
Thank you for a problem report. Indeed, this page, http://dev.mysql.com/doc/administrator/en/mysql-administrator-backup-advanced-options-outp..., should be clarified for the Linux case.
[14 Nov 2008 14:49] Tony Bedford
Updated the main documentation to clarify use of options:

Fully Qualified Identifiers causes MySQL Administrator to write statements in the format, schema_name.table_name, instead of writing only the object name. If you enable fully qualified identifiers you will not be able to restore your backup to a different schema. Selecting this option will also display a warning dialog requesting acknowledgement of this. 

Note
Under Linux this check box is labeled Don't write full path. In this case you need to check this box if you want to later restore to another database schema.