Go to main content

Textpattern CMS support forum

You are not logged in. Register | Login | Help

#277 2010-04-10 06:40:57

azw
Member
Registered: 2007-01-29
Posts: 279

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

Have you looked at messages # 272 and #274? The solutions mentioned there might help you.

Last edited by azw (2010-04-10 06:41:47)

Offline

#278 2010-04-10 12:58:16

els
Moderator
From: The Netherlands
Registered: 2004-06-06
Posts: 7,458

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

I added the links to the various patches posted in this thread to the first post.

Offline

#279 2010-04-21 03:37:41

donie
New Member
Registered: 2010-04-21
Posts: 2

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

ruud wrote:

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");
}

aha, this works!

Offline

#280 2010-05-04 20:36:34

inkywillow
Member
From: France
Registered: 2009-12-22
Posts: 37

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

Hi,

I have just installed the plugin version posted by uli and am having no luck at all. I keep getting “FAILED TO RESTORE: 1” when trying to restore a backup. I am running MAMP on OSX and txp 4.2.0

Any ideas anyone?


The Design Works – Freelance website designer

Offline

#281 2010-05-05 14:26:49

uli
Moderator
From: Cologne
Registered: 2006-08-15
Posts: 4,260

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

At the moment I’ve no working local installation to test against and help you any further. Have you thought of trying one of the other two versions linked in post #1?


In bad weather I never leave home without wet_plugout, smd_where_used and adi_form_links

Offline

#282 2010-05-05 16:10:35

inkywillow
Member
From: France
Registered: 2009-12-22
Posts: 37

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

I’ll give that a try this evening, thanks. What is error 1 btw?


The Design Works – Freelance website designer

Offline

#283 2010-05-28 08:00:55

Timid&friendly
Member
From: The Netherlands
Registered: 2006-05-28
Posts: 252
Website

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

I have the same error message FAILED TO RESTORE: 1

Using 4.2


I think, therefore I AM, … … er … I think :-?

Offline

#284 2010-10-07 11:53:23

helmz
Member
Registered: 2010-09-14
Posts: 65

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

How I get a table in excel of my database(by pressing a button)? How can I just show a table of my database?

Offline

#285 2010-10-07 12:40:32

redbot
Plugin Author
Registered: 2006-02-14
Posts: 1,410

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

helmz wrote:

How I get a table in excel of my database(by pressing a button)? How can I just show a table of my database?

I fear it’s not so easy, but I hope someone more expert proves me wrong, in the past I badly needed something similar…

Offline

#286 2010-10-08 08:09:52

merz1
Member
From: Hamburg
Registered: 2006-05-04
Posts: 994
Website

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

How can I just show a table of my database?

The best way is to use a database management software for MySQL.
Examples: MySQL Workbench or SQLyog

Using a spreadsheet program is not recommended.


Get all online mentions of Textpattern via OPML subscription: TXP Info Sources: Textpattern RSS feeds as dynamic OPML

Offline

#287 2010-11-05 16:55:47

oyster
New Member
Registered: 2010-11-01
Posts: 5

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

Thanks for the fix!

Offline

#288 2010-12-20 18:12:42

Dimitri
Member
From: Johannesburg
Registered: 2010-10-31
Posts: 129

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

I have tried 3 different links on the first post. It installed fine but refused to make a backup.
Working with 4.2.0 with WAMP

BACKUP FAILED. ERROR NO: 1
debug mode : mysqldump -hlocalhost -uroot -p -Q —add-drop-table pet > C:\wamp\www/1292868674-pet.sql

Have anyone been successful doing it on live server or localhost with 4.2.0
Care to share with us

Thanx


<txp:way_too_cool />

Offline

Board footer

Powered by FluxBB