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!
What should I do to completely change the database name?
THanks!
10
13
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
Since you said you're running three site on the same server: Is it possible that there's some mixup here somewhere?
bye, Dirk
12
26
Quote
Theophile
Anonymous
The old db name was "geeklog." The new one is "monopedilos"
$_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
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
13
14
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
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
14
13
Quote
Theophile
Anonymous
It's my own server. I created a new database called "monopedilos" and mirrored the "geeklog" database into it:
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.
Text Formatted Code
mysqldump -u root -p geeklog > geeklog.sqlmysql -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.
12
19
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