Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Pages: 1
4.2 What's in the database?
- Forms?
- Sections?
- Pages/Templates?
- Comments?
- Articles?
- Images?
- Stylesheet(s)?
- Plugins?
- RSS/Atom?
- Other stuff?
If I do a backup or download of the MySQL database from my host to my local PC, what else must I copy in order to have all the pieces of a Textpattern weblog/website? (also, if this type of question is answered specifically for version 4.2 somewhere, please let me know where)
Thanks.
“Well, I, uh, don’t think it’s quite fair to condemn a whole program because of a single slip-up, sir.” General ‘Buck’ Turgidson
Offline
Re: 4.2 What's in the database?
All of the above are stored (with the exception of RSS/Atom which is generated on the fly) and images/files which hold references to the files on the file system.
As well as the database you’ll need (at a minimum) the /images and /files directories. It’s probably best to FTP an entire copy of the root node (the one containing /image, /files, /textpattern, index.php, .htaccess, and so on) down to your local machine. If you want to work offline you may need to change a few config settings in config.php and about 3 preferences in the txp_prefs table (the paths to stuff).
Hope that helps.
The smd plugin menagerie — for when you need one more gribble of power from Textpattern. Bleeding-edge code available on GitHub.
Txp Builders – finely-crafted code, design and Txp
Offline
Re: 4.2 What's in the database?
Hi again, apart from the images and files folders, everything is stored into the database.
(‘references’ to the images and files are stored into the DB as well)
There is an entry on backing up in the faq and an entry in textbook
I have never read those docs, so I hope they’re good :-)
I usually dump the database (using phpmyadmin or rss_admin_db_manager), copy the /images & /files folder and the /textpattern folder (or at least /textpattern/config.php).
edit: seems like stef won this race, but i’ll be back, mwuhahaaaa
Last edited by JanDW (2010-07-01 16:45:13)
TXPDream – A Textpattern Tag Library for Adobe Dreamweaver. (updated for 4.2.0) | jdw_if_ajax – Only serve certain parts of a page when requested with AJAX
Offline
Re: 4.2 What's in the database?
Thanks to both of you. That’s a big help and confirms my fuzzy recollections. I’m often unsure whether something I’m reading about Textpattern is still true for the latest version.
I appreciate the help.
“Well, I, uh, don’t think it’s quite fair to condemn a whole program because of a single slip-up, sir.” General ‘Buck’ Turgidson
Offline
Pages: 1