Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
#1 2009-11-12 05:16:12
- civilized
- New Member
- Registered: 2009-11-12
- Posts: 5
Restored database not visible to TextPattern
I’m moving from TextDrive to Joyent Accelerator, and I backed up my DB from TextDrive, saved it on my Mac, the uploaded it to my Joyent Account apparently successfully (all the fields show numbers indicating population), but the ‘home page’ at the new location shows the default Welcome to your Site page.
How do I get TextPattern to see the DB?
Offline
Re: Restored database not visible to TextPattern
See that /textpattern/config.php can access your new DB.
There may be other paths to check. Can you login to site.com/textpattern? If so, check Admin > Diagnostics which is helpful after a move.
txtstrap (Textpattern + Twitter Bootstrap + etc…)
Offline
#3 2009-11-12 17:18:10
- civilized
- New Member
- Registered: 2009-11-12
- Posts: 5
Re: Restored database not visible to TextPattern
Thanks, Josh.
Offline
#4 2009-11-12 17:41:14
- civilized
- New Member
- Registered: 2009-11-12
- Posts: 5
Re: Restored database not visible to TextPattern
Josh, I took a look a the diagnostics, but I’m sorry to say it means nothing to me.
How do I know if config.php can see the database? I let textpattern set it all up, then restored the DB into textpattern. Was that the right thing to do?
NEW: What’s my table prefix supposed to be? That’s blank in the config.php.
Last edited by civilized (2009-11-12 19:10:05)
Offline
Re: Restored database not visible to TextPattern
If config.php cannot see the database, you will receive an error that you cannot connect to the database. You will not be able to login to site.com/textpattern or check Admin > Diagnostics. If that is all working, then a database connection is established.
Diagnostics: if items are marked red at the top of diagnostics, that can help you look for places to start investigating.
You don’t need a table prefix unless you expressly set it up (one uses it for example when you want to use one mysql database for multiple purposes. The prefix serves to prevent duplicate table names – if you have one database for one txp installation, you can ignore this).
Some things to check:
- do the database details in your config.php match the new database you see with the new articles?
- did you transfer all the database tables from your old database to your new database correctly (e.g. if you transferred only the textpattern table, you will have copied the articles but not the site setup, page templates and forms)?
TXP Builders – finely-crafted code, design and txp
Offline
#6 2009-11-12 20:10:00
- civilized
- New Member
- Registered: 2009-11-12
- Posts: 5
Re: Restored database not visible to TextPattern
> did you transfer all the database tables from your old database to your new database
> correctly (e.g. if you transferred only the textpattern table, you will have copied the
> articles but not the site setup, page templates and forms)?
If I may, let’s start with this. How do I restore the entire database, please?
[edit: Your first two paragraphs appear to be covered: preflight checks out okay, the database is connected but not showing my restored database, and no red fonts in the diagnostics]
Last edited by civilized (2009-11-12 20:11:20)
Offline
#7 2009-11-12 22:42:50
- els
- Moderator
- From: The Netherlands
- Registered: 2004-06-06
- Posts: 7,458
Re: Restored database not visible to TextPattern
civilized wrote:
How do I restore the entire database, please?
Have a look at this tutorial: Moving Installation from one Host to Another.
Offline
Re: Restored database not visible to TextPattern
See this article in the docs for the process of exporting and importing a database using phpmyadmin. The article uses dreamhost, but the process is more or less the same for any host. Of most interest to you is the import and export sections. Make sure you choose export from the overall database overview pane and not a sub-table so that you export the whole database.
EDIT: Els was quicker again :-)
Last edited by jakob (2009-11-12 22:46:57)
TXP Builders – finely-crafted code, design and txp
Offline
#9 2009-11-12 22:50:24
- civilized
- New Member
- Registered: 2009-11-12
- Posts: 5
Re: Restored database not visible to TextPattern
THAT’S what I’ve been looking for! Many, many thanks.
Offline