Go to main content

Textpattern CMS support forum

You are not logged in. Register | Login | Help

#121 2006-11-29 20:07:39

Mary
Sock Enthusiast
Registered: 2004-06-27
Posts: 6,236

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

Pretty please, with sugar on: ability to truncate (empty) tables; the plugin won’t allow me to run that query (truncate table_name).

Offline

#122 2006-11-30 04:46:47

wilshire
Plugin Author
From: Akron, Ohio
Registered: 2004-08-27
Posts: 656
Website

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

Thanks for posting the update Merz. After the last set of updates, there were a couple more feature requests (one with sugar on) so there is another new version available. New features include:

  • The ability to run TRUNCATE statements (as suggested by Mary)
  • The ability to exclude the txp_log table from the backup file. Requires MySQL 4.1.9 and up (as suggested by Steve)
  • Better placement of the debug output

Download rss_admin_db_manager

Offline

#123 2006-11-30 06:09:54

net-carver
Archived Plugin Author
Registered: 2006-03-08
Posts: 1,648

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

Rob

Many thanks for updating this so quickly.


Steve

Offline

#124 2006-11-30 21:55:03

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

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

@Rob: On a newly installed 4.0.4 I get the following error:

It is the very first backup.

BACKUP FAILED. ERROR NO: 1

Warning: unlink(/mnt/…edited…/htdocs/files/1164923449-DB217749.sql.gz) [function.unlink]: No such file or directory in /mnt/…edited…/htdocs/textpattern/lib/txplib_misc.php(512) : eval()’d code on line 95

On my other site everything works fine with the new version.

Well, yes, I am talking about two different installations at two different providers.

  • Strato (Germany): Shared hosting, First backup, not working
  • 1&1 (Germany): Shared hosting, regular backup, working

Last edited by merz1 (2006-11-30 22:00:05)


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

Offline

#125 2006-11-30 22:18:03

wilshire
Plugin Author
From: Akron, Ohio
Registered: 2004-08-27
Posts: 656
Website

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

I would check out differences in MySQL versions, differences in mysqldump versions and differences in the location of the executables for each at the two hosting providers.

All of the issues I have seen with the plugin involve one of those 3 issues.

Offline

#126 2006-12-13 02:41:23

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

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

Rob a) thanks for the answer and b) excuse my late answer; I wasn’t subscribed to this thread.

Do you have some hints how to do the comparison?

Some procedure would be very welcome.
On one platform I have SSH access on the other I haven’t.
Both are on shared hosting platforms and not on dedicated root servers.

Would it be possible to get that info through the plugin?

Extended diagnosis for the NOT working system:

MySQL: 5.0.21
PHP-Extensions: … mysqli/0.1, mysql/1.0
Setting TXP to debug mode shows nothing.
Setting DB_backup to debug shows:

mysqldump -hrdbms.xxx.de -uxxx -pxxx -Q —add-drop-table —ignore-table=xxx.txp_log xxx | gzip > /xxx/htdocs/files/xxx-xxx.sql.gz

Extended diagnosis for the WORKING system:

MySQL: 5.0.26-standard-log
PHP-Extensions: … mysql
Setting TXP to debug mode: not tested
Setting DB_backup to debug shows: The same like above with different parameters and path


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

Offline

#127 2006-12-17 12:24:45

colak
Admin
From: Cyprus
Registered: 2004-11-20
Posts: 9,012
Website GitHub Mastodon Twitter

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

I have a problem as the plugin it is not backing up anymore. (the repair functions seem ok.)
In debug mode it returns:

mysqldump -hburnaby.textdrive.com -uyyy -pxxx -Q —add-drop-table ttt | gzip > /users/home/yyy/domains/hblack.net/web/public/hblack/files/1166357701-hblack.sql.gz

replaced some sensitive information up there.

The gzip file is created but it is only 20bytes… Basically containing nothing…

Any ideas from anyone?

Oh yes! I am using v4.3 of the plugin on a 404 txp install. The reason I upgraded the plugin was because the problem was evident in the previous version installed which was 4.1

Last edited by colak (2007-01-02 08:15:40)


Yiannis
——————————
NeMe | hblack.art | EMAP | A Sea change | Toolkit of Care
I do my best editing after I click on the submit button.

Offline

#128 2007-01-02 08:15:56

colak
Admin
From: Cyprus
Registered: 2004-11-20
Posts: 9,012
Website GitHub Mastodon Twitter

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

anyone?


Yiannis
——————————
NeMe | hblack.art | EMAP | A Sea change | Toolkit of Care
I do my best editing after I click on the submit button.

Offline

#129 2007-01-02 16:58:49

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

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

No, I have no idea.

Pls. contact your ISP to check if rights or path of mysql or mysqldump was changed.


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

Offline

#130 2007-01-03 08:23:51

colak
Admin
From: Cyprus
Registered: 2004-11-20
Posts: 9,012
Website GitHub Mastodon Twitter

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

i’m in textdrive. i do not think they did but i’ll ask in the txd forum


Yiannis
——————————
NeMe | hblack.art | EMAP | A Sea change | Toolkit of Care
I do my best editing after I click on the submit button.

Offline

#131 2007-01-04 19:52:02

colak
Admin
From: Cyprus
Registered: 2004-11-20
Posts: 9,012
Website GitHub Mastodon Twitter

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

OK I have posted for help in the txd forum and here is the response… Any ideas anyone?


Yiannis
——————————
NeMe | hblack.art | EMAP | A Sea change | Toolkit of Care
I do my best editing after I click on the submit button.

Offline

#132 2007-01-07 09:10:15

colak
Admin
From: Cyprus
Registered: 2004-11-20
Posts: 9,012
Website GitHub Mastodon Twitter

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

Anyone?


Yiannis
——————————
NeMe | hblack.art | EMAP | A Sea change | Toolkit of Care
I do my best editing after I click on the submit button.

Offline

Board footer

Powered by FluxBB