This is a two step process. Firstly, we need to export the local database, and then we need to import it into the database in our web hosting account.
The database can be exported from our local phpMyAdmin installation (comes included with most local web server setups, for example, WAMPServer). We need to open http://localhost/phpmyadmin/ in a web browser. From here, we need to select the Database we are using from the drop-down list.
Database drupal (63)
With the database selected, the page should reload the display of a number of tabs across the top of the screen, and a list of tables in the database in the main area of the window. We need to click the Export tab at the top.
From here, we need to ensure that all the tables are selected (we can click Select All to make sure they are), scroll to the bottom of the page, and check the Save as file box, before clicking Go which will prompt us to download the database export.
p 13 Save as fife-
File name template t1^ DB
Compression: ® None q "zipped" q "gzipped
( [7J remember template )
J This material is copyright and is licensed for the sole use by Richard Ostheimer on 15th June 2009 2205 hilda ave., , missoula, , 59801
Now that we have the database from our local installation saved, we can import it into the database on our web hosting account. From our cPanel control panel, we need to click the phpMyAdmin link.
If we have more than one database setup, we need to select it from the list (as we did with our local version). If not, we just need to click the database from the left hand pane.
dinospacjdinos ([>) No tables found in database
Next, we need to select the Import tab from the top of the window, so that we can import the database.
From this window, we can browse for the database file on our computer using the Choose File button and then clicking the Go button at the bottom of the page.
We now have our database setup on our hosting account!
Was this article helpful?