Go to main content

Textpattern CMS support forum

You are not logged in. Register | Login | Help

#1 2007-09-09 09:13:10

ultramega
Member
Registered: 2006-02-26
Posts: 221

Copying existing content to newer installation

I’m going to re-create my own personal site from scratch. I’d like to of course have existing content, but newer version of txp. Should I install new version to a subfolder, and use mysql-dump to export/import just content from old? Or install copy of current version and update it to new vs. of txp? What would be the easiest option? I’d like to have the old one running seamlessly until the new one is ready. I only have one database on my host, which should obviously be not messed during re-design.

Offline

#2 2007-09-09 09:23:03

ruud
Developer Emeritus
From: a galaxy far far away
Registered: 2006-06-04
Posts: 5,068
Website

Re: Copying existing content to newer installation

  1. install a new TXP in a subfolder using the prefix v2_ for the tables.
  2. run the setup (this will create tables which you will overwrite later on with the old TXP tables)
  3. dump the old TXP tables (without the v2_ prefix)
  4. in the export files, change the table names, so they have a v2_ prefix. For example. txp_category becomes v2_txp_category
  5. restore these renamed TXP tables (overwriting the v2_ tables created during the new TXP setup. You may have to delete the existing v2_ tables first). This should give you two separate sets of TXP tables that don’t conflict due to the prefix.
  6. in the admin interface for the new TXP install you should correct the file paths to point to the subdirectory where the new TXP is installed.

Offline

#3 2007-09-09 10:07:41

ultramega
Member
Registered: 2006-02-26
Posts: 221

Re: Copying existing content to newer installation

Great! Thanks for a very clear answer!

Offline

Board footer

Powered by FluxBB