Change of Database Name

3 posts by 2 authors in: Forums > CMS Builder
Last Post: March 28, 2008   (RSS)

By rasbro - March 27, 2008

Hello,

What changes need to be made in CMS Builder if I rename the MySQL database name? Do I only need to update the MySQL Settings area of CMS Builder Admin page?

Thanks,
Brian

Re: [rasbro] Change of Database Name

By Dave - March 27, 2008

The main problem is once you change/rename your database name then CMS Builder won't be able to connect anymore.

There's two ways to do it. Try this sequence:

1) Change the database name in CMS Builder (Admin > General Settings)
2) Rename the database itself
3) Continue using CMS Builder

Or...

Just edit /data/settings.dat.php and search for "[mysql]" and you'll see a line you can change that specifies the database. It looks like this:

database = "cms"

Hope that helps! Let me know if you have any other questions about that.
Dave Edis - Senior Developer
interactivetools.com