342 Part III . Administration mysqlhotcopy also copies (My web server)

342 Part III . Administration mysqlhotcopy also copies any other files within the directory housing the database as well. For example, if you have files such as those produced with mysqldump, performing a mysqlhotcopyof the database copies those to the new location. Figure 13-6 shows an example of this behavior. A listing of the ecommerce database directory is done, then a mysqlhotcopy to make a backup of the database into ecommercebak, followed by a listing of the new ecommercebak directory. Figure 13-6: The mysqlhotcopy script copies all files located in the database s directory on the server. Recall the basic syntax for the mysqlhotcopy program: mysqlhotcopy [./
/] [ | ] You have two possible destinations for the backup: . A new database . A directory in a different location The examples in Figures 13-5 and 13-6 each made new databases. However, attempting to use either database can result in an error message, as shown in Figure 13-7.
From our experience, we are can tell you that you can find a reliable and cheap webhost service at Java Web Hosting services.

Leave a Reply