ExponentCMS DB set up

ExponentCMS DB set up

Posted by: chagriver
Posted on: 2009-01-16 02:27:00

I'm trying to set up a database so that I can install an ExponentCMS. I have a live domain and want to establish a development copy of the domain currently running Exponent on DreamHost. I've set up a subdomain so that I can point the DNS to DreamHost and build the database. What IP address should I use for mysql?

Re: ExponentCMS DB set up

Posted by: sXi
Posted on: 2009-01-16 02:38:00

You need to setup any databases from Panel.


First, create a Hostname:

Goodies > Manage MySQL

- Add New Hostname

- New Hostname: (eg.) sql.domain.com

- Click Create this new hostname now!


Then, create a database:

Goodies > Manage MySQL

- Scroll down to "Create a new MySQL database:"

- Fill in the form and click Add new database now!


Now that's done, use the Hostname (sql.domain.com) - as opposed to an IP or 'localhost' - within your script to have it connect to your database.

phpMyAdmin is available at http://sql.domain.com for importing/exporting.




How To Install PHP.INI / ionCube on DreamHost

Re: ExponentCMS DB set up

Posted by: chagriver
Posted on: 2009-01-16 03:35:00

I understand how to set up a db.

This is the scenario:

The DNS is currently pointed to a host of a live CMS created on a different host. I want to recreate the website with the same CMS and a new database on dreamhost.

I have created a new subdomain and want to change the A record so that it points to the IP for the mysql db on dreamhost.

What IP do I need for the A record so this website can be duplicated?

Thanks

Re: ExponentCMS DB set up

Posted by: rlparker
Posted on: 2009-01-16 03:44:00

I think that is "the hard way" to do it, actually. Have you seen:

http://wiki.dreamhost.com/DNS_-_Viewing_site_before_DNS_change and
http://wiki.dreamhost.com/DNS_-_Accessing_your_Database_before_DNS_change

--rlparker
--DreamHost Tech Support

Re: ExponentCMS DB set up

Posted by: chagriver
Posted on: 2009-01-16 05:02:00

oh this is very cool, this boll weavil may have found a home, still can't access the mysql.chagrinriver.mywebhoster.com with phpmyadmin but it should resolve soon.

Thanks!!

Tags: dreamhostsubdomain