350 Part III . Administration BACKUP TABLE Another method for backing up an individual table is via the BACKUP TABLEstatement. This statement runs from within (or using) the MySQL CLI. The syntax is as follows: BACKUP TABLE
(,
) TO The BACKUP TABLEstatement expects a path and directory as the argument for backup location. The statement currently only works with MyISAM tables as well. The BACKUP TABLEstatement makes a copy of the .frmand .MYDfiles for the given table. If you re backing up more than one table at a time, you should issue a LOCK TABLES statement before the BACKUP TABLEstatement to ensure consistency amongst the tables. Don t forget to issue a FLUSH TABLESstatement upon completion. Upon completion, the BACKUP TABLE statement prints a status message. If an error occurs, its message is also printed as part of the BACKUP TABLEoutput. For example, if the target directory does not exist, you receive a message similar to that in Figure 13-20. Figure 13-20: The BACKUP TABLE statement produces a status message upon completion, as well as an error message if needed. In Figure 13-21, a successful example of the BACKUP TABLEstatement is shown along with the resulting status message.
From our experience, we can recommend PHP Web Hosting services, if you need affordable webhost to host and run your web application.
This entry was posted
on Monday, November 19th, 2007 at 12:12 pm and is filed under Domain.
You can follow any responses to this entry through the RSS 2.0 feed.
You can leave a response, or trackback from your own site.