Welcome to Geeklog, Anonymous Sunday, May 10 2026 @ 04:24 pm EDT

Geeklog Forums

Changing backed database


Theophile

Anonymous
Since I'm running 3 geeklog sites on the same server, I decided to change the name of my original database from "geeklog" to "fubar." So I dumped "geeklog" into "fubar" and changed the database name in config.php. But now the install is drawing data from both databases. New stories are still weritten to the "geeklog" database but rss feeds (for example) are drawn from the new "fubar" database.

What should I do to completely change the database name?

THanks!
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
$_DB_name in config.php is the only place where the database name is defined - everything else in Geeklog (that needs the database name) refers to that variable.

Since you said you're running three site on the same server: Is it possible that there's some mixup here somewhere?

bye, Dirk
 Quote

Theophile

Anonymous
The old db name was "geeklog." The new one is "monopedilos"

Text Formatted Code
$_DB_host         = 'localhost';   // host name or IP address of your DB server
$_DB_name         = 'monopedilos';     // name of your database,

 

RSS feeds and the "Latest Forum Posts" phpbbbridge block get data from "monopedilos" database.

New stories and forum posts are still written to and read from "geeklog" database.

This means that, while the site looks ok for the most part, the Latest Forum Posts and RSS feeds both date to when I tried to change the DB name
 Quote

Status: offline

1000ideen

Forum User
Full Member
Registered: 08/04/03
Posts: 1298
So I dumped "geeklog" into "fubar"

What did you do? How did you dump? Is it your own server, is it webspace, is it cpanel? Cpanel got some adjustments which are quite different from e.g. confixx. I don`t doubt that Dirk is right, that the definition of the db is in config.php
 Quote

Theophile

Anonymous
It's my own server. I created a new database called "monopedilos" and mirrored the "geeklog" database into it:
Text Formatted Code
mysqldump -u root -p geeklog > geeklog.sql
mysql -u root -p  monopedilos < geeklog.sql
 

Then I changed the entry in config.php to the way it is shown in my previous post. However, new stories still appeared into the "geeklog" database instead of the "monopedilos" database.
 Quote

Status: offline

1000ideen

Forum User
Full Member
Registered: 08/04/03
Posts: 1298
Sorry, I don`t know such server things. Maybe someone else... Question
 Quote

All times are EDT. The time is now 04:24 pm.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content