SETTING UP (Web hosting india) MYSQL AND PHPMYADMIN Figure 10-2. phpMyAdmin
SETTING UP MYSQL AND PHPMYADMIN Figure 10-2. phpMyAdmin is a very user-friendly and stable graphical interface to MySQL. Logging out of phpMyAdmin If you opted to password protect phpMyAdmin, the Log out link is at the bottom left of the front page, just beneath Import (as shown in the screenshot). When you click the link, you are immediately prompted for your username and password. Click Cancel, and you will be presented with a screen informing you that you supplied the wrong username/password in other words, you have been logged out. Odd, but that s the way it works. You cannot log back in to phpMyAdmin from the wrong username/password screen. You must enter the original URL into the browser address bar first. 10 Backup and data transfer MySQL doesn t store your database in a single file that you can simply upload to your web- site. Even if you find the right files (on Windows, they re located in C:Program FilesMySQLMySQL Server 5.0data), you re likely to damage them unless the MySQL server is turned off. Anyway, most hosting companies won t permit you to upload the raw files because it would also involve shutting down their server, causing a great deal of inconvenience for everyone. Nevertheless, moving a database from one server to another is very easy. All it involves is creating a backup dump of the data and loading it into the other database with phpMyAdmin. The dump is a text file that contains all the necessary Structured Query Language (SQL) commands to populate an individual table or even an entire database elsewhere. phpMyAdmin can create backups of your entire MySQL server, individual databases, selected tables, or individual tables. To make things simple, the following instructions show you how to back up only a single database. 281
If you are searching for cheap webhost for your web application, please visit MySQL5 Web Hosting services.