column and click the right-arrow but- ton to (Cheapest web hosting)

column and click the right-arrow but- ton to include that database in the BackupContent pane. Expand the database into a treecontrol form by clicking the arrow next to thedatabase name. Check the boxes next to eachtable name to include (or uncheck the boxes toexclude) the tables in the backup (see Figure 44-9). Figure 44-9:Creating a new backup profile. When your profile is complete, click the SaveProject button. To run the backup, click the StartBackup button. In this technique, we ve given you other, dependable ways to back up. They re notgraphical, but dependability counts whenyou re making backups. Until this productmatures a bit, we recommend sticking to triedand true backups for data you treasure. Restore Backup: The Restore Backup menuselection opens a dialog designed to restore fromarchives created with the Backup menu. For now, we recommend that you use more dependablemethods to back up and restore. Replication Status: The Replication Status menuselection opens a dialog displaying informationabout the state of your replication topology. (Wecover MySQL replication features earlier in thistechnique.) Catalogs: The Catalogs menu selection displaysinformation about the databases and tablesdefined on your MySQL server. The creators of MySQL Administrator are a bitloose with their labels. The Catalogs andSchemata labels both refer to what are nor- mally called databases. Highlight a database name in the Schemataframeto see the tables stored in that database. Highlight a table name in the top panel to displaythe columns within that table, as shown inFigure44-10. Use the tab controls in the lower panel to viewinformation about the Columns, Indices, TableStatus, and Row Status. Figure 44-10:Table information displayed with MySQLAdministrator. MySQL Administrator should grow up to be anifty timesaving tool. If you re just starting touse MySQL, you may want to avoid the frus- tration (and slowdowns) caused by the bugsand skip the installation of the version distrib- uted with Fedora (3.x). You can download the RPM packages that you need to installMySQL version 4.0 or better from www. mysql.com/downloads.
Note: In case you are looking for affordable and reliable webhost to host and run your j2ee application check Vision J2ee Web Hosting services.

Leave a Reply