Chapter 13 . (Web hosting colocation) Debugging and Repairing Databases 347
Chapter 13 . Debugging and Repairing Databases 347 To copy more than one database at a time, you can use the –regexp switch to create a regular expression of matching databases. This switch uses a syntax similar to the one that tells mysqlhotcopy which tables to copy. Figure 13-15 shows an example of the –regexp switch in action. Caution The –regexp option does not run well currently; it may be fixed in a future version of mysqlhotcopy. Figure 13-15: The –regexp switch serves to copy more than one database at a time but is currently quite buggy. You can also specify a suffix for copied databases with the –suffixswitch. Doing so can help to keep a standard suffix for all backed-up databases. In Figure 13-16, for example, I use the –suffix switch to create a backup with an extension of _bak. Figure 13-16: Using the –suffix switch to create a backup with a special extension To see an example of what mysqlhotcopywould do given a set of arguments, use the -nor –dryrunswitch. The -nor –dryrunswitch provides a listing of what would happen without actually performing the operation. An example of the –dryrun switch is shown in Figure 13-17.
Please visit Domain Name Hosting services for high quality webhost to host and run your jsp applications.