Submit web site - WRITE YOUR OWN BLOG ENGINE Now you re ready
WRITE YOUR OWN BLOG ENGINE Now you re ready to copy your database to your live server. Open up your local installation of phpMyAdmin in your browser and select the blog database. Click the Export tab. Now click the Select All link in the Export box so that the posts and comments tables are both selected. Finally select the Save as file option and click Go (see Figure 7-25). A file called blog.sql should be saved to your default download folder (usually your desktop). Figure 7-25. Exporting your database in phpMyAdmin Now you have a complete copy of your database: table structure, indexes, and data. To import this onto your live server, open up the remote installation of phpMyAdmin and create a database called blog. Now click the SQL tab and browse to select your blog.sql file in the Location of the textfile section. Click Go, and your database will be uploaded. Easy as that! 335