Textpattern CMS

#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)

#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.

#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!

#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

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

uli

Moderator

From: Cologne

Registered: 2006-08-15

Posts: 4,310

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}

#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

#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 :-?

#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?

#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…

---

Some Txp stuff

#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

#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!

#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 />