262 Part II . SQL Essentials Figure 10-28 (Msn web hosting)
262 Part II . SQL Essentials Figure 10-28 shows examples of both redirect methods. Figure 10-28: Examples of redirecting output via the greater-than sign and the -r switch Specifying records to be dumped You can even get more specific than a particular table with mysqldump. The use of the –where= or -wswitch enables you to add a SELECT statement. For example, to dump only the contents of the user table of the MySQL grants database where the user is suehring , the command in Figure 10-29 could be issued: mysqldump -p –where=user= suehring mysql user The where clause can be longer than one argument. For example, the following command is valid: mysqldump -p –where=user= suehring and host = localhost mysql user Controlling the INSERT statement Two options control how any INSERT statements are done with mysqldump. These options are -c(–complete-insert), or -e (–extended-insert). The default is extended-insert. Examples with both types of insert options are shown in Figure 10-30. The commands to reproduce these examples are as follows: mysqldump -t -p -e –where=user= suehring and host = localhost mysql user mysqldump -t -p -c –where=user= suehring and host = localhost mysql user
From our experience, we can recommend PHP Web Hosting services, if you need affordable webhost to host and run your web application.