Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
developing on testing server then uploading to web
Currently I develop txp sites on my computer then copy and paste each page on to an installed txp site on the web. which can take about an hour.
Is there an easier way? Or how does every body else do it??
I’ve tried naming the online server database, username and password the same and then copying and upload the SQL data. I always get errors.
ta
Offline
Re: developing on testing server then uploading to web
JasonUK wrote:
Is there an easier way?
What are you using to manage your local DB? What are you using to manage your live DB? It should be a quick job to dump the appropriate tables from your local DB and upload them to the live site.
The two DBs don’t have to have the same name, nor username/passwords. The key there is not to overwrite config.php, and once you have the live site going, to leave txp_prefs and txp_users out of the mysqldump.
Code is topiary
Offline
#3 2008-03-12 22:22:18
- els
- Moderator
- From: The Netherlands
- Registered: 2004-06-06
- Posts: 7,458
Re: developing on testing server then uploading to web
TextBook: moving sites
Offline
Re: developing on testing server then uploading to web
I use phpMyAdmin for both live and local.
So if I have my developed version on my computer and a new txp site up on the live server.
-Do I just go to phpmyadmin (local) press export,
-select all tables except txp_prefs and txp_users.
-save on a txt file and import on to live database.
That doesn’t seem to work. I’m doing something wrong. I get an error while importing.
Edit: I’ve only just seen the last post after adding this post. I’ll give that link a try. thanks
Last edited by JasonUK (2008-03-12 23:02:36)
Offline
#5 2008-03-12 23:15:56
- els
- Moderator
- From: The Netherlands
- Registered: 2004-06-06
- Posts: 7,458
Re: developing on testing server then uploading to web
There is a link in TextBook to an article Moving a Live Textpattern Site to a Local Server. At the bottom of that article you’ll find a chapter about going the other direction :)
Offline
Re: developing on testing server then uploading to web
Thanks Els
That last link was an excellent tutorial. I have now got it sorted.
Offline