[plugin] [ORPHAN] rss_admin_db_manager - database backups and more

ellen · 2007-07-29 17:04:15

hhriebe schrieb:

I had a similar experience when I accidentally left the “mysqldump Path” and “mysql Path” configuration fields empty. They should at least contain the words mysqldump and mysql – if you still get errors then you need to specify the complete path.

The fields aren’t empty and in the meantime I brought the website manually to my server. I’ve installed rss_admin_db_manager too and the same thing happens. I get this error message:

Warning: unlink(/var/www/web80/html/test/files/1185727086-usr_web80_1.sql.gz): Datei oder Verzeichnis nicht gefunden in /var/www/web80/html/test/textpattern/lib/txplib_misc.php(534) : eval()’d code on line 95
Backup error 126

REading through the forum I recognized that other people have had the same problem but I found no solution?!

ellen · 2007-07-31 11:20:59

Specified complete paths – same error.
What can I do about it???????????????????????

arnski · 2007-08-21 18:02:26

For all folks still getting the Error No: 02

I got it working using another MySQL-User (you can’t change that via the admin-interface, but you can change the config.php-file located in your textpattern-folder).

The user seems to need special rights “selecting a database” or something – DB-experts might correct me.

I got to this solution when i used the console.app under OS X to watch the httpd-error log. It spit out the following error-message:

mysqldump: Got error: 1044: Access denied for user ‘’@‘localhost’ to database ‘textpattern_test’ when selecting the database

I simply changed to the root-user which might not be the best solution in a production-environment ;)

So basically i think you need to specify a user with these “selecting the database”- rights or change your current users rights accordingly.

Hope it helps,

Arne

maniqui · 2007-09-07 14:20:01

For some reason, the plug-in stopped working (ie. making back-ups) after I changed the folder path (I checked the folders permissions and are the same from /files/ folder).

I changed it back to /files/ but it still not working. It just creates a 20 bytes file.

I have tried uninstalling and installing it again with no luck.

maniqui · 2007-09-07 18:13:43

I managed to “fix it” by deleting the plug-in and also deleting every reference to rss_dbbk (in the txp_prefs table) using phpMyAdmin.

Then, I installed the plug-in again and voilà! It worked when I tried to create a new backup.

castanet · 2007-10-20 14:16:13

I am using rss_admin_db_manager to search and replace text across articles, like this:
update textpattern set body = replace(body,“old text”,“new text”);
The selected text is being replaced in the database, and I can see it when I open up the articles. But each article then needs to be saved down again before the changes are visible on the site. Am I doing it wrong?
Thanks for a great plugin.

the_ghost · 2007-10-29 18:25:42

castanet wrote:

I am using rss_admin_db_manager to search and replace text across articles, like this:
update textpattern set body = replace(body,“old text”,“new text”);
The selected text is being replaced in the database, and I can see it when I open up the articles. But each article then needs to be saved down again before the changes are visible on the site. Am I doing it wrong?
Thanks for a great plugin.

Maybe you have cache plugin installed?

merz1 · 2007-10-29 21:49:30

@castanet: There are two fields where the body is stored. One is the textile version and one is the translated HTML version which is sent to the browser. If you do a restore you may/must replace content in both fields. I think it is ‘body’ and ‘body_html’.

candyman · 2007-11-16 08:21:52

For some reason, the plug-in stopped working (ie. making back-ups). I’ve changed the folder path in the past (checking the folders permissions and are the same from /files/ folder) and it worked well too. Now, it doesn’t and I don’t know why: appears only ERROR NO. 2.

It just creates a 20 bytes file.

I have tried uninstalling and installing it again with no luck.

I tried to fix it by deleting the plug-in and also deleting every reference to rss_dbbk (in the txp_prefs => prefs_id table) using phpMyAdmin: no results at all.

Where may lay the problem?

candyman · 2007-11-16 11:20:59

I noticed that, when I try to backup using the gzipped option, I get this: BACKUP FAILED. ERROR NO: 2 but, if I try to backup using the .sql option, I get 20k files.

Hope this may help.

Last edited by candyman (2007-11-16 11:23:12)

candyman · 2007-11-16 21:19:04

hhriebe wrote:

I had a similar experience when I accidentally left the “mysqldump Path” and “mysql Path” configuration fields empty. They should at least contain the words mysqldump and mysql – if you still get errors then you need to specify the complete path.

What are the complete path? The instructions talk about complete path to the executable but I don’t understand which values I have to put to avoid the “20k bug”.
Hope someone can help me.

Thanks in advance.

Last edited by candyman (2007-11-16 21:27:14)

iblastoff · 2007-11-16 21:28:30

the complete path depends on your webhost.

typically its probably something like this : /usr/local/bin/mysqldump

could be and most likely different for you. you may have to look at your hosting documentation or ask them directly. if you have ssh access to your host then you could easily find out as well.

personally i have had 0% success using this plugin on the various hosts i’ve tried it on, whether i use full paths or not. i typically get one of the random “BACKUP ERROR: #”‘s or that 20 byte file when trying to gzip. it only works on my local testing server which pretty much renders it useless to me. others clearly have no issues with it though. just seems to vary host to host.

on a separate note, not to be another “but EE can do this” touter, but the built-in db backup found in expressionengine works just fine on the same servers i’ve tested rss_admin_db_manager on. so it seems like there could be a more universal solution for txp as well?

Last edited by iblastoff (2007-11-16 21:38:51)

candyman · 2007-11-16 21:54:22

Many thanks, iblastoff!
I’ve made a step forward: now, with the full path, for mysqldump and mysql I obtain this:

BACKUP FAILED. ERROR NO: 127

And now? :/

candyman · 2007-11-16 22:03:31

Oops: it means it can’t find the executable…

Tried with: /usr/bin/mysqldump and /usr/bin/mysql and returned to ERROR NO.2.

It’s a problem: this plugin is VERY important for me.

iblastoff · 2007-11-16 22:13:58

then you have the wrong paths. look at your host documentation, ask your host, or check via ssh (if you have access) for the correct executable path for your host. no guarantee it will work after that though (never worked for me)

Textpattern CMS

Textpattern CMS support forum

#151 2007-07-29 17:04:15

Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more

#152 2007-07-31 11:20:59

Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more

#153 2007-08-21 18:02:26

Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more

#154 2007-09-07 14:20:01

Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more

#155 2007-09-07 18:13:43

Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more

#156 2007-10-20 14:16:13

Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more

#157 2007-10-29 18:25:42

Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more

#158 2007-10-29 21:49:30

Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more

#159 2007-11-16 08:21:52

Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more

#160 2007-11-16 11:20:59

Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more

#161 2007-11-16 21:19:04

Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more

#162 2007-11-16 21:28:30

Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more

#163 2007-11-16 21:54:22

Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more

#164 2007-11-16 22:03:31

Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more

#165 2007-11-16 22:13:58

Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more

Board footer