340 Part III . Administration One notable exception (Web hosting provider)
340 Part III . Administration One notable exception in the behavior of the switches is the -por –password switch. Normally, programs such as the MySQL CLI and mysqladminprompt for a password when you use the -pswitch (as shown in Figure 13-2). You could also specify the password on the actual command line, also illustrated in Figure 13-2. Figure 13-2: The variations of the types of password entry methods for most MySQL commands Unlike most programs that come with MySQL, mysqlhotcopydoesn t prompt for a password. Rather, the password must be specified on the command line. In addition, if you use the -p switch mysqlhotcopyexpects a space after the -p. Figure 13-3 shows an example of this behavior. If the space isn t given after the -pswitch, an Invalid Optionerror message results. Figure 13-3: Attempting to give the password without a space after the -p switch results in an error.
In case you need affordable webhost to host your website, our recommendation is ecommerce web host services.