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

THE BLUE DRAGON · 2008-04-23 19:14:16

Hi need some help please.
When I’m trying to make a backup in .sql file I’m geting the next error: BACKUP FAILED. ERROR NO: 2
mmm…what is error #2 please?

I got textpattern 4.0.6 with ruud’s fix on rss_admin_db_manager v4.3

merz1 · 2008-04-23 19:31:41

Hmm, the code part regarding $error is:

      $error = "";

      if (function_exists('passthru')) {
        passthru($backup_cmd, $error);
      } else {
        $dumpIt=popen($backup_cmd, 'r');
        pclose($dumpIt);
      }

      if(!is_writable($bkpath)) {
        pagetop("DB Manager", "BACKUP FAILED: folder is not writable");
      } elseif($error) {
        unlink($backup_path);
        pagetop("DB Manager", "BACKUP FAILED.  ERROR NO: ".$error);
      } else if(!is_file($backup_path)) {
        pagetop("DB Manager", "BACKUP FAILED.  ERROR NO: ".$error);
      } else if(filesize($backup_path) == 0) {
        unlink($backup_path);
        pagetop("DB Manager", "BACKUP FAILED.  ERROR NO: ".$error);
      } else {
        pagetop("DB Manager", "Backed Up: ".$DB->db." to ".$filename);
      }

Doesn’t help much but at least it tells you that the error number is coming from the database engine itself. Google didn’t help to bring up something for #2 :-(

Is the gzip backup working? If yes the not zipped file is too big. If I remember right there is a (2MB?) border.

Last edited by merz1 (2008-04-23 19:32:47)

azw · 2008-04-23 19:40:10

There are several previous messages about that error here:
Google search for Error No. 2

In particular, this one may be helpful by Arnski:
http://forum.textpattern.com/viewtopic.php?id=10395&p=16 (post # 153)

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

THE BLUE DRAGON · 2008-04-23 20:10:40

Thanks to you two!
and the gzip backup is not working too.
I think I will stay with phpmyadmin for now,
it’s scary for me to deal with the database and the config file.

uli · 2008-05-05 23:19:18

Once again for subscribers of this thread:

Correct paths for MAMP locale:

mysqldump Path:
/Applications/MAMP/Library/bin/mysqldump

mysql Path:
/Applications/MAMP/Library/bin/mysql

darock · 2008-06-07 03:51:05

does this plugin allow for us to backup the content (articles) of the site rather than just the installation? I couldn’t figure that out from just reading the description

iblastoff · 2008-06-07 04:19:51

darock wrote:

does this plugin allow for us to backup the content (articles) of the site rather than just the installation? I couldn’t figure that out from just reading the description

yes it backs up everything including plugins.

Timid&friendly · 2008-06-07 09:44:54

May i make a suggestion :D …. What would be a nice extra is that you could rename the mysql dumps from within the plugin interface

merz1 · 2008-06-07 11:32:49

darock: The plug-in allows to backup all the database tables. The TXP installation (file system on webserver) must be saved in another step i.e. via FTP.

uli · 2008-06-07 13:32:22

I think darock wants to backup only articles, not everything else. This can be done on Extensions > DB Manager. Second column right hand side, line “textpattern”. Be sure not to click “Drop” ;)

Last edited by uli (2008-06-07 13:33:23)

lee · 2008-06-14 09:46:07

Anyone have a copy of this plugin please, Rob’s site has been down for a few days now.

Best wishes
Lee

maniqui · 2008-06-14 16:00:06

Hi lee,

use this one: http://forum.textpattern.com/viewtopic.php?pid=170943#p170943 (already fixed to work with 4.0.6)

lee · 2008-06-14 17:11:06

Thanks all.

georgeM · 2008-07-31 04:12:59

Hi guys,

Not sure why I am getting the following error when trying to install this plugin (latest fixed 4.0.6 version):

Warning: Incorrect string value: ‘\xF6nen\nh1. Textpattern Database Manager

\n\n

The rss_admin_db_manager plugin adds 3 new tabs to your Textpattern admin interface. Each tab contains different functionality to help manage \nyour MySQL database. You can think of this plugin as a lightweight replacement for phpMyAdmin. \n\n

I am running a fresh install of TXP v4.0.6, using the fix from Ruud (compiled into a fixed plugin a couple posts below Ruud’s fix). I tried changing languages, but this didn’t help. It looks like it’s a MySQL error to me. MySQL is v5, with PHP v5 as well (running through IIS7).

One thing that I see within the plugin help (before clicking “INSTALL” and returning to Admin » Plugins page) is this:

<p>h1. Textpattern Database Manager</p> <p>The rss_admin_db_manager plugin adds 3 new tabs to your Textpattern admin interface. Each tab contains different functionality to help manage<br /> your <a href="http://www.mysql.com/">MySQL</a> database. You can think of this plugin as a lightweight replacement for <a href="http://www.phpmyadmin.net/home_page/">phpMyAdmin</a>.</p> <h2>Database Backup</h2>

(seems like some of the description is getting mapped up into the MySQL statement?)

Anyways, I’ve been up working quite late, so maybe I’m just having brainfarts. If anyone does know what could be wrong, I appreciate the help!

Last edited by georgeM (2008-07-31 04:13:27)

uli · 2008-07-31 09:22:41

Two posts above yours is a link to colak’s fixed 4.0.6-ready version. Try that one.
Edit: hrrm… just noticed that’s probably the one you’re having problems with.

Last edited by uli (2008-07-31 14:06:03)

Textpattern CMS

Textpattern CMS support forum

#226 2008-04-23 19:14:16

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

#227 2008-04-23 19:31:41

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

#228 2008-04-23 19:40:10

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

#229 2008-04-23 20:10:40

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

#230 2008-05-05 23:19:18

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

#231 2008-06-07 03:51:05

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

#232 2008-06-07 04:19:51

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

#233 2008-06-07 09:44:54

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

#234 2008-06-07 11:32:49

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

#235 2008-06-07 13:32:22

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

#236 2008-06-14 09:46:07

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

#237 2008-06-14 16:00:06

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

#238 2008-06-14 17:11:06

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

#239 2008-07-31 04:12:59

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

#240 2008-07-31 09:22:41

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

Board footer