Microsoft Office Tutorials and References
In Depth Information
Getting the Site Online
Within the export area, we need to select the database tables we want to export;
obviously we want to export all of the data from the database so we click the Select
All link to select all of the tables from the list.
Then to actually save the data as a file, we need to check the Save as file box and
click the Go button.
This should then download the data in an SQL file onto our computer. Now we need
to import this data into the new database on the web server.
Firstly, we need to log in to our control panel, and select the MySQL logo to go to
the database area. At the bottom of this page there is a link to the phpMyAdmin
installation on the server—let's click that. Within phpMyAdmin we need to select
the database we created earlier from the left-hand side of the page, and then click
the import tab from the top of the page. On the import page there is a section with
the heading File to import ; we use the file Browse box to select the database file we
downloaded onto our computer.