|
To deploy the MySQL database to the Inspirunner server, you can
use backup/restore procedure in the phpMyAdmin.
Step 1. Backup your MySQL
database using PHPMyAdmin on your local machine
| 2.
|
Select your database by clicking the
database name in the list on the left of the screen.
|
| 3.
|
Click the Export
link. This should bring up a new screen
that says View dump of database (or something similar). |
| 4.
|
In the Export
area, click the Select All
link to choose all of the tables in your
database. |
| 5.
|
In the SQL options area, click the
right options.
|
| 6.
|
Click on the Save as file
option and the corresponding compression
option and then click the Go button. A
dialog box should appear prompting you to save the file
locally. |
Step 2. Restore your database
using phpMyAdmin on the server
To access phpMyAdmin on the server
follow instructions described in How do I manage my
databases? topic.
| 2.
|
Create an appropriately named
database and select it by clicking the database name in the list on
the left of the screen. If you would like to rewrite the backup
over an existing database then click on the database name, select
all the check boxes next to the table names and select
Drop
to delete all existing tables in the
database. |
| 3.
|
Click the SQL link. This should bring up a new screen where you
can either type in SQL commands, or upload your SQL
file. |
| 4.
|
Use the browse button to find the
database file.
|
| 5.
|
Click Go button. This will upload the backup, execute the SQL
commands and re-create your database. |
|
