PhpMyAdmin
From DreamHost
- Note that the correct title of this article is phpMyAdmin. The first letter is rendered in uppercase due to a technical limitation.
To use phpMyAdmin to access one of your MySQL databases simply go to that database's hostname on the web. For example, if your MySQL hostname was mysql.example.com, point your browser to http://mysql.example.com. You will then be prompted for a username and password.
phpMyAdmin is configured to use HTTP authentication against the database server. The user and password you enter should be a MySQL user / password that has access to the database you want to manage.
Contents |
HTTPS
For access via Secure HTTP, your domain must have secure hosting on it.
You may set up your domain to have secure hosting by going to the panel and to "domains->manage domains" and click "edit" under "secure hosting" to add secure hosting to your domain. No matter what, if you add secure hosting, you are going to need to pay the ongoing yearly rate to enable the unique IP; however, if you choose to "use your own certificate" (and don't purchase one from elsewhere), the system will setup a self-signed certificate for you. Though this isn't very secure for ecommerce and whatnot, it will probably be good enough for secure mysql management.
If you haven't subscribed to the secure hosting option, you may still access your database in a secure fashion by connecting via your shell account.
Copying MySQL data
The following steps outline how to copy a table from one MySQL database to another:
Exporting the data
- Login to phpMyAdmin.
- Select the source database.
- Open the table you wish to export.
- Export the table as a file with a .sql extension.
Importing the data
- Select the destination database.
- Click the Import tab.
- Click Browse and locate the file with the .sql extension you saved earlier.
- Click OK and then Go.
The newly-imported table will appear in the list of tables.
Note on Dropping (Deleting) a Database
You cannot Drop a database on DreamHost using phpMyAdmin; you can "delete" a database using the Control Panel -> Goodies -> Manage MySQL screen. Even if you do this, a database created on DreamHost is never fully dropped by using the Control Panel -> Goodies -> Manage MySQL screen. If you login to the host with the appropriate credentials, via phpMyAdmin or the shell command line, you'll still find your database. Dreamhost does not completely delete the database as the result of a Control Panel action. Be careful!
If you no longer want a database you have set up on DreamHost, and you have any sensitive data in the database that you want to obliterate, you might consider dropping all the tables from the database so that the data can not be viewed in this manner.
