Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
#16 2005-08-23 17:13:45
- heikki74
- Member
- From: Finland
- Registered: 2004-08-17
- Posts: 100
Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more
Great! Now.. where’s that plugin?
Offline
Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more
the ransom has been met, no? when is the plugin going to be available?
Offline
#18 2005-08-23 19:47:38
- cpk
- Member
- Registered: 2005-08-07
- Posts: 62
Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more
gimme gimme I want it – we neeeeeeeds precious plugin!
;-)
I would still donate for something like this tho’
cpk
Offline
Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more
Ohh… this is exactly what I want at this moment… (I guess)
Need to update/backup one single table in my database, I guess this plugin would do that trick for me…
Offline
Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more
Sorry folks, I was out of town and away from the computer all day.
The ransom was indeed met and the plugin is available for download
The contributors of $20 or more were:
- Jan Willem de Bruijn
- Heikki Ylönen
- New Signals Press
- Stephen Bau
If you are one of the above mentioned parties, please send me the link you would like to accompany your name in the plugin help and the plugin page on my site.
Thanks to everyone who contributed. Enjoy! More details on the ransom to follow on my site soon.
Offline
Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more
Good one Rob!
A very comprehensive tool. Even though a friend helped me to build an automated backup system for all my MySQL db’s, this will still be useful for when I want to take a backup before making changes, etc to the system.
Offline
Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more
Could this be used as a migration tool? Like if I change hosts, could I restore a backup from the old host to a db on the new? Or would the “db host,” “db name,” etc. need to be identical?
EDIT: Also, duh, thanks very much for putting this plug-in out there.
Last edited by RHD (2005-08-24 06:59:52)
Offline
Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more
First question(s).
Can I use this to restore one single table in my database?
Had to do a clean install of txp and would like to import all the articles from one of my old sql backups. (Learned a lesson when I messed around with some things I didn´t fully understood.) So now I want to restore all articles. The images, forms, css and other stuff can I manage the hard way. But rewriting all the articles is something I won´t do.
Is it the Textpattern table that hold all the article text? Yes
Once again I solved it on my own shortly after posting here. Deeply sorry for that. My solution was to restore the table in “MySql Administrator”.
Have a nice day folks, and thanx for the plugin :)
Last edited by skoggy (2005-08-24 11:56:41)
Offline
#24 2005-08-24 13:30:18
- els
- Moderator
- From: The Netherlands
- Registered: 2004-06-06
- Posts: 7,458
Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more
When I click .sql file in the db backup tab I get this: BACKUP FAILED: file not there. Am I supposed to create something first? Couldn’t find this in the help.
Offline
Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more
wilshire, thanks for the plugin. I really like the db manager and run sql tabs. It’s good not to have to flip back and forth between Textpattern and phpMyAdmin.
For Stephen Bau, you can link to http://www.builderscollective.com/ (although TextDrive currently has a server outage on their Bidwell server and the link is not currently working. I’m really looking forward to the hardware switch this week.)
I seem to be having a similar problem, different message, when trying to create an .sql file backup: BACKUP FAILED: file is empty. I am able to save a gzipped file, but when I examine the file, it is also empty. Any ideas?
Offline
Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more
I’m able to create backups in either format but after I deleted some test entries and tried to restore the database with those entries it said t worked but did not restore the entries. I had to use mysqlfront to restore teh .sql file to my server. Is the restore working for other people?
Offline
#27 2005-08-24 17:19:03
- heikki74
- Member
- From: Finland
- Registered: 2004-08-17
- Posts: 100
Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more
Yes.. I can create backups in both formats. Restoring them works also.
I tried it with my test site with a couple of articles.
Offline
Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more
A few notes…
- This has been tested for use with Textpattern 4.0 and above (as was supposed to be indicated by the plugin version number) but I falied to mentioned it otherwise. If you’re using an older version I can’t guarantee that it will work.
- If you’re having restore problems, the cause might be because of a bad backup. Download the backup and open the file to see if it contains an actual backup. It should be a series of SQL statements.
- If your backup or restore is failing, please post your TXP version/revision number, operating system and mysql version.
If you are getting a bad backup file and are able to email it to me, that would help as well.
Offline
#29 2005-08-24 20:28:16
- els
- Moderator
- From: The Netherlands
- Registered: 2004-06-06
- Posts: 7,458
Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more
TXP 4.0, revision 819. Both .sql file and gzipped file are giving BACKUP FAILED: file not there, so I can’t test if restore is working ;)
MySQL 4.0.25
Apache 2.0.46
Dumb question: my OS or the server’s?
Thanks in advance.
Offline