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

stardustrevolution · 2007-12-14 22:45:14

Everything installed fine but when I click backup I get the following:

The XML page cannot be displayed
Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later.

————————————————————————————————————————

Only one top level element is allowed in an XML document. Error processing resource ‘http://mydomain/textpatt…

<?xml version=“1.0”?><methodResponse><fault><value><struct><member><name>faultCode…

Is there a specific thing I need to change or delete to get this to work?

candyman · 2007-12-28 09:08:28

merz1 wrote:

Pls. always use gzipped! Otherwise you may run into other file size limitations when restoring the backup. As far as I remember there is some 2MB limitation when uploading via browser.

This limit is valid for rss_admin_db_manager too? I mean: if my db is more than 2Mb (gzipped) the phpMyAdmin won’t work? The Rob Sable’s plugin can break this limit?

merz1 · 2007-12-28 14:05:35

I believe (!) it depends on PHP and the limitations of file upload sizes defined in the PHP config. As far as I know/understand the problem bigger file sizes are only available through the MySql command line interface.

If the whole archive extends 2MB then you should consider saving/uploading single tables instead of the whole archive.

But maybe more competent people can answer this question better?

Joey · 2007-12-28 14:50:21

Hi all. Trying to install the plugin on a new txp website, but have some troubles with it. When building a backup I get an error output:

Warning: unlink(/usr/local/plesk/apache/vhosts/httpdocs/files/1198853265.sql) [function.unlink]: Onbekend bestand of map in /usr/local/plesk/apache/vhosts/httpdocs/textpattern/lib/txplib_misc.php(534) : eval()’d code on line 95

BACKUP FAILED. ERROR NO: 127

I already searched this thread and found that the problem might be the mysql/mysqldump path’s. However, I just checked this with my hosting provider, and the path’s seems to be OK. What else could be the problem?

candyman · 2007-12-29 08:51:20

Maybe the server on which the script is running is different from the one which host the database?

candyman · 2007-12-31 10:14:49

One question: is the rss_admin_db_manager server related? I mean: if I make a backup file on a server and then I move my domain to another host (with, obviously, a different db server) can I import the backup file without effort? Or I’ll get an error?

Thanks in advance and happy new year!

iblastoff · 2007-12-31 10:46:02

candyman wrote:

One question: is the rss_admin_db_manager server related? I mean: if I make a backup file on a server and then I move my domain to another host (with, obviously, a different db server) can I import the backup file without effort? Or I’ll get an error?

Thanks in advance and happy new year!

of course its server related. and you might get an error. you might not. depends on what database permissions/different paths/etc you have on each server.

Joey · 2008-01-02 18:07:35

candyman wrote:

Maybe the server on which the script is running is different from the one which host the database?

That can’t be the problems since they are both on the same server (I check it with my hosting provider). The hosting provider suggests that there is a problem with deleting the file (unlink). Somebody has any idea?

FireFusion · 2008-02-03 10:13:05

Hi Rob,

Is this getting updated for the 4.0.6 soon?

http://forum.textpattern.com/viewtopic.php?pid=170720#p170720

ruud · 2008-02-03 10:57:50

For those who don’t mind editing the plugin, for Textpattern 4.0.6, edit the plugin and change this:

if (@txpinterface == 'admin') {
    register_tab("extensions", "rss_db_man", "DB Manager");
    register_callback("rss_db_man", "rss_db_man");

    register_tab("extensions", "rss_sql_run", "Run SQL");
    register_callback("rss_sql_run", "rss_sql_run");

    register_tab("extensions", "rss_db_bk", "DB Backup");
    register_callback("rss_db_bk", "rss_db_bk");
}

into (adding the 3 add_privs lines):

if (@txpinterface == 'admin') {
    add_privs('rss_db_man', '1');
    register_tab("extensions", "rss_db_man", "DB Manager");
    register_callback("rss_db_man", "rss_db_man");

    add_privs('rss_sql_run', '1');
    register_tab("extensions", "rss_sql_run", "Run SQL");
    register_callback("rss_sql_run", "rss_sql_run");

    add_privs('rss_db_bk', '1');
    register_tab("extensions", "rss_db_bk", "DB Backup");
    register_callback("rss_db_bk", "rss_db_bk");
}

iblastoff · 2008-02-03 11:44:06

FireFusion wrote:

Hi Rob,

Is this getting updated for the 4.0.6 soon?

http://forum.textpattern.com/viewtopic.php?pid=170720#p170720

rob hasn’t posted in this forum for nearly half a year now. anyone know if hes still active with TXP-related stuffs?

diniscorreia · 2008-02-04 00:28:15

Hi all,

Anyone knows if the user need Publisher privileges to use the plugin?

Textpattern CMS

Textpattern CMS support forum

#193 2007-12-14 22:45:14

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

#194 2007-12-28 09:08:28

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

#195 2007-12-28 14:05:35

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

#196 2007-12-28 14:50:21

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

#197 2007-12-29 08:51:20

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

#198 2007-12-31 10:14:49

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

#199 2007-12-31 10:46:02

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

#200 2008-01-02 18:07:35

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

#201 2008-02-03 10:13:05

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

#202 2008-02-03 10:57:50

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

#203 2008-02-03 11:44:06

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

#204 2008-02-04 00:28:15

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

Board footer