Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Alternative backup technique for 4.0.7
I’ve just posted in the plugin support section
And got myself wondering… Has anyone ever documented a technique for backing up and (significantly) reinstalling a Textpattern installation using PHPMyAdmin or equivalent?
I’ve been happily using a modified version of rss_admin_db_manager with 4.0.6 and have recently built a new, different site using 4.0.7… and can’t seem to get anything nice when I follow the usual procedure with rss_admin_db_manager on a different host… In fact it’s screwed up things so badly that I’ve had to drop all of my tables and start again.
Anyone any pointers, please?
Thanks.
Offline
Re: Alternative backup technique for 4.0.7
You could take a look at this TXP Tip. Might be helpful.
Offline
#3 2008-12-17 22:08:47
- masa
- Member
- From: North Wales, UK
- Registered: 2005-11-25
- Posts: 1,094
Re: Alternative backup technique for 4.0.7
I did use that plugin, too, but later settled for the automysqlbackup solution described here
In addition to that, I set up a scheduled ftp mirroring to a local computer – runs smoothly.
Offline
Re: Alternative backup technique for 4.0.7
So near , yet so far… Thank you for the TXP Tip
Using PHPMyAdmin:
- I’ve created a backup of my site (from Textdrive) DONE
- I’ve imported the backup to the new home (1and1) DONE
It’s all there except… I can’t login to Textpattern as me anymore!?
Anything I might’ve missed in the recipe somewhere?
Many thanks,
Gavnosis
Offline
#5 2008-12-18 01:27:16
- redbot
- Plugin Author
- Registered: 2006-02-14
- Posts: 1,410
Re: Alternative backup technique for 4.0.7
gavnosis wrote:
It’s all there except… I can’t login to Textpattern as me anymore!?
So you are getting a “wrong user or password “ warning (or something similar)?
Try this, re-inserting your name and password. It should do the trick.
Offline
Re: Alternative backup technique for 4.0.7
Thanks redbot,
I’ve tried another ‘Publisher’ user and pass and then moved on to your SQL query
update txp_users set pass=password(lower('pass')) where name='user';
Each time get the same old message:
Could not login with that name/password.
Thanks for your advice, anyway.
:-(
Offline
Re: Alternative backup technique for 4.0.7
In fact, it’s worse than that, because even when I’ve tried resetting my password at the Textpattern login prompt, and had a new one mailed to me, it hasn’t been accepted…
Offline
#8 2008-12-18 11:04:49
- redbot
- Plugin Author
- Registered: 2006-02-14
- Posts: 1,410
Re: Alternative backup technique for 4.0.7
gavnosis wrote:
… I’ve tried another ‘Publisher’ user and pass and then moved on to your SQL query…
Actually you don’t need to create another “publisher” user, just open phpmyadmin and run the query.
Are you sure you are doing it correctly? Excuse me if I insist but it should work
update txp_users set pass=password(lower('pass')) where name='user';where ‘pass’ is your password, and ‘user’ is the login username.
P.S. By the way, there is something I don’t undestand: if you can’t login to txp how could you create a new user??
Last edited by redbot (2008-12-18 11:07:10)
Offline
Re: Alternative backup technique for 4.0.7
Hi Redbot,
I’ve been in to PHPMyAdmin for the new textpattern site, and run the the query in the SQL tab – it hit go and this is what it said:
Affected rows: 0 (Query took 0.0005 sec)
SQL query:
UPDATE txp_users SET pass = password( lower( ‘pass’ ) ) WHERE name = ‘user’
And then gone back to my login screen and entered (just like you said)
- Name user
- Password pass
…And still the same old message:Could not login with that name/password.
Should I be concerned that there are 0 affected rows?
ps The other publisher was created on the original site, so there are two publisher accounts on the (working) original site
Last edited by gavnosis (2008-12-18 11:13:57)
Offline
#10 2008-12-18 11:17:31
- redbot
- Plugin Author
- Registered: 2006-02-14
- Posts: 1,410
Re: Alternative backup technique for 4.0.7
Excuse me for the silly question: in you query did you replace the word ‘pass’ with your real password and ‘user’ with your real username?
Offline
Re: Alternative backup technique for 4.0.7
I should change my picture to red for embarrassed… Put the real thing in and worked a treat. Oops!
Thank you for your patience! I’m in, I’m happy, the sun’s shining and I’v e probably made someone smile…
;-)
Offline
#12 2008-12-18 12:07:55
- redbot
- Plugin Author
- Registered: 2006-02-14
- Posts: 1,410
Re: Alternative backup technique for 4.0.7
gavnosis
Eheh never mind… I understood your error because I’m a master myself in this kind of things ;)
Offline