Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
#13 2009-08-29 11:53:21
- els
- Moderator
- From: The Netherlands
- Registered: 2004-06-06
- Posts: 7,458
Re: Desperate database issue
OK, now all you have to do is change this:
$txpcfg['table_prefix'] = 'txp_';into
$txpcfg['table_prefix'] = '';Offline
#14 2009-08-29 11:59:00
- carrotrope
- Member
- From: Edinburgh
- Registered: 2007-03-16
- Posts: 39
Re: Desperate database issue
Els and Jonathan: I love you.
You have absolutely no idea how much time/stress you’ve saved me – THANK YOU!
Offline
#15 2009-08-29 12:00:21
- els
- Moderator
- From: The Netherlands
- Registered: 2004-06-06
- Posts: 7,458
Re: Desperate database issue
Glad it’s solved :)
Edit: I edited the upgrade instructions on Textbook to explicitely mention the config.php file ;)
Last edited by els (2009-08-29 12:02:40)
Offline
Re: Desperate database issue
OK Jez,
now go and make a complete backup of your site files and database..!
Keith
Blyth, Northumberland, England
Capture The Moment
Offline
Re: Desperate database issue
keith wrote:
OK Jez, now go and make a complete backup of your site files and database..!
With no intent to hijack this thread, what’s the current “best” method of doing this? 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: Desperate database issue
There are a few ways.
Easiest(?) is to install the rss_admin_db_manager plugin and run that.
Conversely, you can download and install phpMyAdmin to your server space; and most(?) hosting deals come with a database backup function in their Control Panel.
I back up the site files simply by dragging and dropping the whole Texpattern folder onto my local drive via FTP.
Keith
Blyth, Northumberland, England
Capture The Moment
Offline
Re: Desperate database issue
Glad you got it working Jez! And I would use phpMyAdmin for backups, or even better, use a daily cron script. Here is one example of using phpMyAdmin.
Offline
#20 2009-08-29 18:04:48
- masa
- Member
- From: Asturias, Spain
- Registered: 2005-11-25
- Posts: 1,091
Re: Desperate database issue
jstubbs wrote:
And I would use phpMyAdmin for backups, or even better, use a daily cron script.
I set up a cron job as per Bert’s suggestion
This will store backups on the server in a directory of your choice.
Then I created backup scripts in my FTP client to mirror the contents of the backup- and the web content directories to a local folder on my computer on a regular schedule.
Offline