OZ-KBA-4002: Importing a MySQL Database

This KB will explain:

• How to Access the phpMyAdmin Control Panel
• How to Import your Database using the phpMyAdmin Control Panel
 

Article

How to Access the phpMyAdmin Control Panel

OzHosting.com uses phpMyAdmin to manage MySQL Databases. Complete documentation for phpMyAdmin is available at http://phpmyadmin.net.
 

1. Navigate to https://my.ozhosting.com and Login
2. Click Hosting
 
3. Click Databases
 
4. Click on the Database you wish to Administer
 
5. You will see the following page
 
a. Browse database manager: This is your link to the phpMyAdmin Control Panel
b. Database name: This is your databases name
c. Internal hostname: This is the IP address you need to supply instead of ‘localhost’ when connecting to the database in your website code
 

6. Click the Browse database manager link

How to Import a Database using phpMyAdmin
 

1. Click the database you want to Import into
 
2. Click Import
 
3. Select your SQL File and Click GO
 
4. If all went well you should see the following
 
The number of queries executed will vary depending on your Database Structure.
5. You can now administer your restored database from the phpMyAdmin Control Panel