348 Part III . Administration Figure 13-17: Using
348 Part III . Administration Figure 13-17: Using the –dryrun or -n switch you can see what would happen with mysqlhotcopy without actually performing the backup. Other options for mysqlhotcopy include the following: Option Description –flushlog Performs the same functions as the flush-logs function with mysqladmin to reset any logging. Related to replication, –resetmaster Restarts the replication process. –resetslave Restarts the replication process. –noindices Excludes any index files from the backup. –tmpdir Changes the location of the temporary directory used by mysqlhotcopy (which is /tmp by default). Later this chapter provides an example of a script that automates the process of making backups with mysqlhotcopy. On the CD-ROM The script for automating backups with mysqlhotcopy is also located on the CD ROM included with this book. mysqldump With mysqldump, you can obtain a copy of the database structure, as well as the actual data for all databases on the server. The mysqldump command is flexible enough that you can specify structural units as small as tables and export them. Taking the output from mysqldumpand importing it back into MySQL, you can quickly reproduce an entire database server, along with all its data.
We recommend high quality webhost to host and run your jsp application: christian web host services.