Textpattern CMS

#1 2007-11-20 16:33:46

EddieG5

Member

From: Georgia

Registered: 2004-03-03

Posts: 96

Switching Databases?

Hello all,

I recently set-up a TXP on a site, but need to change the database name for it. Is there a way I can elegantly/easily do that or do I have to do the TXP setup all over again and reload all my articles?

Thanks!

#2 2007-11-20 17:13:19

iblastoff

Plugin Author

From: Toronto

Registered: 2006-06-11

Posts: 1,197

Website

Re: Switching Databases?

well..what exactly are you changing? just the db name? does the ‘new’ db name have your txp info already in it or are you moving to a completely new/blank db?

generally you can just update the config.php and your admin->preferences paths if need be and you should be fine. if you actually need to import/export db info (aka your new db is completely blank) then theres plenty of documentation on that. faq or use rss_admin_db_manager

Last edited by iblastoff (2007-11-20 17:18:43)

---

my plugins || iblastoff.ca

#3 2007-11-20 18:08:50

EddieG5

Member

From: Georgia

Registered: 2004-03-03

Posts: 96

Re: Switching Databases?

This is what I’m trying to do:

I have a site setup at:

http://www.mysite.com/ideas/

This site is driven by TXP.

I want everything to stay the same, except for the database. In other words, when I’m finished, the site will still be: http://www.mysite.com/ideas/

But the database will be changed. I tried using the rss_admin_db_manager … I exported my database and then tried to import into the new database I created and then changed the config.php file with the new database info. But that doesn’t seem to work.

#4 2007-11-20 18:22:52

ruud

Developer Emeritus

From: a galaxy far far away

Registered: 2006-06-04

Posts: 5,068

Website

Re: Switching Databases?

Export the tables (!) from the old database (using PHPmyAdmin for example), import them in the new database, then change the database name in textpattern/config.php

#5 2007-11-20 19:06:26

EddieG5

Member

From: Georgia

Registered: 2004-03-03

Posts: 96

Re: Switching Databases?

Perfect. Worked like a charm!

#6 2007-11-21 04:54:38

Mary

Sock Enthusiast

Registered: 2004-06-27

Posts: 6,236

Re: Switching Databases?

Um, you know that phpMyAdmin lets you rename databases, right?

#7 2007-11-21 07:58:57

ruud

Developer Emeritus

From: a galaxy far far away

Registered: 2006-06-04

Posts: 5,068

Website

Re: Switching Databases?

Um, no… but I learn something new every day ;)