Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
#133 2007-01-07 14:22:52
Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more
Did you check the most simple options?
Backup Path:- Points to some local directory inside your root (htdocs) directory.
- The path looks like /<some directories>/htdocs/files.
mysqldump Path: mysqldump
mysql Path: mysql
No parameters no nothing.
You are having a network problem!
- Don’t use a servername except maybe localhost or 127.0.0.1.
- Where does the host name (the -h part) come from? Config.php? That’s the place where you have to change something.
Jason at Textdrive said it loud and clear that mysqldump is not allowed to connect to your public IP. You must use an internal IP (?) or localhost or 127.0.0.1.:
Yes you don’t have TCP permissions so
mysqldump -hburnaby.textdrive.com
should be
mysqldump -hlocalhost
or just leave the -h off
As Rob said before
I would check out differences in MySQL versions, differences in mysqldump versions and differences in the location of the executables (…).
All of the issues I have seen with the plugin involve one of those 3 issues.
Sorry, but nothing more to add.
Last edited by merz1 (2007-01-07 14:24:07)
Get all online mentions of Textpattern via OPML subscription: TXP Info Sources: Textpattern RSS feeds as dynamic OPML
Offline
#134 2007-02-05 10:29:15
Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more
Just have to mention that I just installed this plugin on a site being hosted by Dreamhost, and after activating, I clicked backup, and whammo. Done. I can’t wait to back-up the rest of my sites. Thanks a bunch!
Offline
#135 2007-02-05 11:35:49
Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more
On Dreamhost, too.
Following a hint by Bert Garcia, I set up a cron job using AutoMySQLBackup, let the server take care for doing all backup maintenance at 03:00 a.m. and send me an e-mail in case something goes awry.
THIS is pleasure!
Offline
#136 2007-02-16 18:25:53
Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more
wilshire wrote:
The rss_admin_db_manager Textpattern plugin gives you full control over your Textpattern database. You can think of this plugin as a lightweight replacement for phpMyAdmin. It adds 3 tabs to your admin interface and gives you the ability to do the following:
One feature request:
The “Previous Backup Files” should be sorted by date
Offline
#137 2007-02-25 12:55:08
- sagariha
- New Member
- Registered: 2004-05-08
- Posts: 7
Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more
The gzip file is created but it is only 20bytes… – Solved (at least for me)
As I read the PHP-error log I got down to the fact, that the mysql-dump Version on my site can’t use the “ignore-table”-command.
(With some of my sites it works, with others not).
So I changed around line 69 in the Plugin-Code (Plugin-Version v4.3) to:
$nolog = ($rss_dbbk_txplog) ? "" : "";
// $nolog = (isset($bk_table) && gps("bk_table") == "txp_log") ? "" : $nolog;
With this quick and dirty hack … it’s working again!
@wilshire: Maybe it’s neccessary to add an Version-Check or to add an Option to disable the “ignore-Table”-Command?!
Last edited by sagariha (2007-02-25 12:58:26)
Offline
#138 2007-03-05 23:08:15
Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more
when i try and use the plugin: rss_db_bk
i get this error : Warning: strftime() expects parameter 2 to be long, string given in /users/home/giovanni/domains/bicilogic.com/public_html/textpattern/lib/txplib_misc.php(512) : eval()’d code on line 219
how do i fix it.
PS in spite of this the DB back-up works fine…
…. texted postive
Offline
#139 2007-05-20 15:15:39
Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more
that this plugin exists, and is easy to use and JUST WORKS, totally blows my mind. so I just wanted to say the author/s are awesome, and thanks.
Offline
#140 2007-05-29 09:01:35
- FireFusion
- Member
- Registered: 2005-05-10
- Posts: 698
Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more
Would it be possible to add a find and Replace feature to this plugin that allows us to quickly things in articles, pages, forms, custom fields etc.
I think this would make this plug-in the ultimate killer app for TXP.
Offline
#141 2007-05-31 13:09:30
Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more
Pls. have a look at this search and replace comment.
Some more examples would be helpful…
Get all online mentions of Textpattern via OPML subscription: TXP Info Sources: Textpattern RSS feeds as dynamic OPML
Offline
#142 2007-06-23 06:43:06
Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more
I just installed this plugin so that I could export my Postmaster subscriber list into a csv format. I’d also like to bulk import subscribers to my Postmaster database table from a csv file. Is this possible? And if so, could someone explain how I would do it? Thank you!
Swim Kitten, A Magento Site
When nothing but incredibly revealing dresses and swimwear will do
Offline
#143 2007-07-10 20:19:36
- hhriebe
- New Member
- From: West Vancouver, BC, Canada
- Registered: 2007-06-20
- Posts: 8
Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more
I get this error when I try to install the plugin locally:
Warning: Incorrect string value: ‘\xF6nen\nh1. Textpattern Database Manager
some of the help text, then the message:
Plugin rss_admin_db_manager install failed!
The freshly downloaded plugin code looks fine in the preview window; the error happens when I hit install. I’ve had this error with both 4.0.4 and 4.0.5 – other plugins have installed fine.
Henning Riebe
Embracing Emptiness
HenningVision
Offline
#144 2007-07-11 03:02:33
- Mary
- Sock Enthusiast
- Registered: 2004-06-27
- Posts: 6,236
Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more
This is caused by a combination of three things: your database is using latin1 rather than utf8, you have MySQL’s strict mode on, and the plugin appears to be trying to use a unicode character (which I suspect is some sort of mistake or corruption in the plugin file, rather than intentional inclusion). Turning strict mode off should allow you to install the plugin, but the plugin should be checked to make sure the problem is fixed.
To turn off strict mode:
If you open up your my.ini or my.cnf, and you should find a line similar to this:
# Set the SQL mode to strict
sql-mode="STRICT_ALL_TABLES"You may have other values in there as well (NO_AUTO_CREATE_USER, NO_ENGINE_SUBSTITUTION, etc), but the STRICT_ALL_TABLES is the one you want to remove, even if only temporarily. Save your changes and restart your MySQL server.
Offline