Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
move from local to remote quickly and easily?
i have never found a system for moving between a locally developed textpattern site and one on the server. i would like to be able to do this often, but i’ve never figured it out. one problem is the xampp installation has quite different setup than the one online. do you have any tricks for moving between the two?
Offline
#2 2010-04-07 18:11:45
- els
- Moderator
- From: The Netherlands
- Registered: 2004-06-06
- Posts: 7,458
Re: move from local to remote quickly and easily?
Have you seen Destry’s article Moving a Live Textpattern Site to a Local Server? (At the bottom of the page you’ll find Going the Other Direction.)
It’s a lengthy article, but in short these are the steps to take:
- Create your remote database (on the hosted Web account).
- Move a copy of your local TxP file tree to the remote location.
- Do an SQL dump of the local database tables.
- Upload the dump to the remote database.
- Edit the moved config.php file (now sitting at the remote location) to reflect the correct information for the remote database (name, password, dbname, etc.)
- Go to Admin > Preferences and change the site URL and the paths to the files and temp directories
(Copied from Destry’s article, but I added #6, you need to do it.)
Once you’ve installed the setup in both places, for future moves you only need to do steps 3-6.
Offline
Re: move from local to remote quickly and easily?
thanks Els, the problem i have is that if i want to do this very often, steps 3-6 can break up the flow of the project. so it’s something i would only do about once a week at the most frequent.
Offline
Re: move from local to remote quickly and easily?
Just to specify the question from my point of view:
- Are you talking about a publishing workflow?
- Are you talking about a website development workflow?
Edit: Sorry, didn’t see the 1st two replies.
Last edited by merz1 (2010-04-07 18:38:02)
Get all online mentions of Textpattern via OPML subscription: TXP Info Sources: Textpattern RSS feeds as dynamic OPML
Offline
Re: move from local to remote quickly and easily?
I do what Els said, but I also use rss_admin_db_manager, edited to work with current versions of TXP. That plugin seems to make my life a little easier when I have to do this; here’s how:
The DB Backup tab under Extensions allows you to quickly export the database without finagling about with mysqldump or phpMyAdmin. Once you have your dump file, you can upload it to the files directory on your publish server, and “Restore” that backup there to bring the databases in sync. You still have to edit the site paths in Textpattern’s preference tables, which you can do in Textpattern’s Admin > Preferences tab, or within phpMyAdmin.
One more thing: Sine I use cnk_versioning to keep my Textpattern templates in the file system, its rare that I need to sync the databases. cnk_versioning imports templates from the file system into the database upon a page refresh when the site’s Production Status is Debugging or Testing.
What this means is that I can edit and test my template files on my dev server, and deploy the templates by copying them to the server— I use a version control system for this. Once the template files on the server are up-to-date, I can just refresh the site to import the changes— then change the Production Status back to Live when I’m done for the day. This works for me because I don’t need to keep the content completely in sync across my development and publish servers.
Offline
Re: move from local to remote quickly and easily?
thanks for the reply john. i have actually never been able to see rss_admin_db_manager tabs show up in my CMS. sounds like it might be a bit easier than phpmyadmin.
cnk_versioning sounds good too, but maybe a bit above me though. i do like the idea of versioning, would be cool to have this feature on the level of just pages inside the CMS. kind of like google docs.
Offline
Re: move from local to remote quickly and easily?
mrtunes wrote:
i have actually never been able to see rss_admin_db_manager tabs show up in my CMS.
See post #240 at http://forum.textpattern.com/viewtopic.php?id=10395&p=24 for a version of the plugin that works with TXP 4.0.6 and beyond.
Last edited by joebaich (2010-04-08 01:15:32)
Offline