1
ruggierigm
how to update database information when moved to a new hosting site
  • 2008/2/18 14:48

  • ruggierigm

  • Just popping in

  • Posts: 34

  • Since: 2004/6/19


The host of my site killed everything I had, I want to know if I upload my files and then create a new database and load it with the original data how do I get xoop’s to use the new database? The location and the name of the database will be different because the naming rules on the new host.
Thanks, Gabe

2
Peekay
Re: how to update database information when moved to a new hosting site
  • 2008/2/18 15:22

  • Peekay

  • XOOPS is my life!

  • Posts: 2335

  • Since: 2004/11/20


You need to ask your new hosts for the 'server-path' to the new site, then edit 'mainfile.php' and use that path as 'xoops_root_path', e.g.

define('XOOPS_ROOT_PATH''/var/www/vhosts/example.com/httpdocs');

Change also (if needed) the HTTP address, e.g.

define('XOOPS_URL''http://www.example.com');

If the new host has their MySQL databases hosted on a different server than their websites, replace:

define('XOOPS_DB_HOST''localhost');


with:

define('XOOPS_DB_HOST''192.168.123.456');

using the IP address of their DB server.

And of course ensure MySQL database name, username and passwords are updated to the new ones.

The BIG problem with XOOPS is that it uses absolute paths for images in the image manager, so if the site is on a new domain you may need to open the exported SQL file in a text editor before importing and search for:

[img align=left]http://www.oldsite.com/img472dea365fad8.jpg[/img ]

replacing it with:

[img align=left]http://www.example.com/img472dea365fad8.jpg[/img ]


HTH.
A thread is for life. Not just for Christmas.

3
ruggierigm
Re: how to update database information when moved to a new hosting site
  • 2008/2/18 18:48

  • ruggierigm

  • Just popping in

  • Posts: 34

  • Since: 2004/6/19


This did the trick, thanks you saved me from having to do a new install.

Login

Who's Online

332 user(s) are online (257 user(s) are browsing Support Forums)


Members: 0


Guests: 332


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Nov 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits