Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
#1 2008-04-09 12:49:03
- marana
- New Member
- From: Southern Arizona
- Registered: 2008-04-05
- Posts: 5
Updating MySQL tables from development environment
I am running multiple TXP sites on a single, hosted MySQL instance using unique table name prefixes. It works fine.
I have chosen not to use TXP to make extensive site design changes online for fear that real-time rework will expose unexpected design problems publicly. So, I do my redesign on a development server, where changes can be tested, with the intent of replacing the live, online version when I am through.
I would prefer to just upload the TXP tables associated with the redesigned site to my host instance of MySQL along with my modified version of TXP, but have encountered some problems.
What is the recommended way to do this??
Is my only option to use TXP to manually update all the pages, forms and style sheets on the production site with the redesign and do a cut-over inside Textpattern. Your experience with similar issues will be appreciated.
Offline
Re: Updating MySQL tables from development environment
Does TXP on the development server have the same table prefix as on the live server?
Offline
#3 2008-04-09 18:14:13
- marana
- New Member
- From: Southern Arizona
- Registered: 2008-04-05
- Posts: 5
Re: Updating MySQL tables from development environment
Yes. I have developed a 4 character prefix naming convention for each site I build, like ‘ABC_’ or ‘TXP_’ or ‘RCB’ to identify table contents for each TXP project. This prefix is appended to each of the 17 tables that TXP builds when a new site is built. This permits me to backup and restore the entire MySQL database or just a specific project.
Offline
Re: Updating MySQL tables from development environment
If you want to copy a development TXP install to a live server where TXP has the same table prefix, just make sure the TXP versions are identical, then backup the TXP tables on the old server and restore them on the new server (for example using PHPmyAdmin or using the rss_db_admin plugin).
Offline
#5 2008-04-09 22:44:00
- marana
- New Member
- From: Southern Arizona
- Registered: 2008-04-05
- Posts: 5
Re: Updating MySQL tables from development environment
Thanks. I appreciate your prompt response.
Offline