Bug #32704 Missing documentation BACKUP and RESTORE
Submitted: 26 Nov 2007 2:02 Modified: 26 Nov 2007 4:23
Reporter: Jared S (Silver Quality Contributor) Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:5.1 OS:Any (Any)
Assigned to: CPU Architecture:Any
Tags: Backup, qc, resotre

[26 Nov 2007 2:02] Jared S 
Description:
Hi,

There is no written documentation about the new schema sql command driven BACKUP and RESTORE keywords in SQL Server 6.0.

6.0 is now in RC phase.

How to repeat:
See my webinar slides attached.  From "MySQL backup and Recovery Today and Tomorrow"
[26 Nov 2007 2:03] Jared S 
Slides

Attachment: backup.jpg (image/pjpeg, text), 147.74 KiB.
[26 Nov 2007 2:15] Paul DuBois 
We don't document SQL Server.

re: BACKUP TABLE and RESTORE TABLE, they were deprecated in 5.0/5.1.

http://dev.mysql.com/doc/refman/5.1/en/backup-table.html says:

"Note
This statement is deprecated. We are working on a better replacement for it that will provide online backup capabilities. In the meantime, the mysqlhotcopy script can be used instead."

And they were removed in 6.0. See http://dev.mysql.com/doc/refman/6.0/en/mysql-nutshell.html
[26 Nov 2007 2:32] Jared S 
*MySQL Server 6.0.  Please see my slide attached.  'SQL Server' was a typo!
[26 Nov 2007 2:39] Paul DuBois 
Ah, okay.  The BACKUP and RESTORE statements are not yet in a state that can be documented.

By the way, what do you mean by "6.0 is now in RC phase"?  MySQL 6.0 is still alpha.
[26 Nov 2007 3:11] Jared S 
My bad, I meant 5.1.  This bug can be closed if BACKUP\RESTORE will not be appearing until 6.x.