PDA

View Full Version : Database Question - Domain Transfer



DataMan
07-23-2008, 04:42 AM
I'm in the process of transferring my domain to HostMonster. I've successfully transferred the site files as well as re-building the MySQL database. I'm currently running Joomla v1.x. There is a difference between how the database was named in the old hosting and the new
Old : boomer_joom1
New: boomercl_joom1

Is the "boomercl" prefix locked in or, can I change the db prefix in phpMyAdmin to the old naming structure? I would like to get this resolved before the domain transfer is finalized.

Thanks,

DataMan

Falcon1986
07-23-2008, 07:02 AM
I believe that is fixed. Hostmonster automatically adds the first 8 letters of your domain name to database names that you create.

Did you try importing a backed up database from your previous host?

You may have to contact HM Support directly to alter the database names. However, is there not a way within the Joomla configuration to specify the database to use?

shadmego
07-23-2008, 07:51 AM
In Joomla!, locate the file named configuration.php. It should be in the main folder where you installed Joomla! ... most likely public_html. There is a php variable in that file where you can name the database, user and password for the database, which should eliminate the need to change the name at the mysql end.

~regards

DataMan
07-23-2008, 11:25 AM
Thanks to all who offered assistance. Ended up using Shadmego's suggestion... elegant and simple. Will wait until the domain transfer thinger completes to see if all is happy.

:)

DataMan

amaudy
07-23-2008, 03:08 PM
Just change config file on joomla.