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

gemal · 2007-02-16 18:25:53

wilshire wrote:

The rss_admin_db_manager Textpattern plugin gives you full control over your Textpattern database. You can think of this plugin as a lightweight replacement for phpMyAdmin. It adds 3 tabs to your admin interface and gives you the ability to do the following:

One feature request:

The “Previous Backup Files” should be sorted by date

sagariha · 2007-02-25 12:55:08

The gzip file is created but it is only 20bytes… – Solved (at least for me)

As I read the PHP-error log I got down to the fact, that the mysql-dump Version on my site can’t use the “ignore-table”-command.
(With some of my sites it works, with others not).

So I changed around line 69 in the Plugin-Code (Plugin-Version v4.3) to:

$nolog = ($rss_dbbk_txplog) ? "" : "";
// $nolog = (isset($bk_table) && gps("bk_table") == "txp_log") ? "" : $nolog;

With this quick and dirty hack … it’s working again!

@wilshire: Maybe it’s neccessary to add an Version-Check or to add an Option to disable the “ignore-Table”-Command?!

Last edited by sagariha (2007-02-25 12:58:26)

bici · 2007-03-05 23:08:15

when i try and use the plugin: rss_db_bk

i get this error : Warning: strftime() expects parameter 2 to be long, string given in /users/home/giovanni/domains/bicilogic.com/public_html/textpattern/lib/txplib_misc.php(512) : eval()’d code on line 219

how do i fix it.

PS in spite of this the DB back-up works fine…

pfctdayelise · 2007-05-20 15:15:39

that this plugin exists, and is easy to use and JUST WORKS, totally blows my mind. so I just wanted to say the author/s are awesome, and thanks.

FireFusion · 2007-05-29 09:01:35

Would it be possible to add a find and Replace feature to this plugin that allows us to quickly things in articles, pages, forms, custom fields etc.

I think this would make this plug-in the ultimate killer app for TXP.

merz1 · 2007-05-31 13:09:30

Pls. have a look at this search and replace comment.

Some more examples would be helpful…

rsskga · 2007-06-23 06:43:06

I just installed this plugin so that I could export my Postmaster subscriber list into a csv format. I’d also like to bulk import subscribers to my Postmaster database table from a csv file. Is this possible? And if so, could someone explain how I would do it? Thank you!

hhriebe · 2007-07-10 20:19:36

I get this error when I try to install the plugin locally:

Warning: Incorrect string value: ‘\xF6nen\nh1. Textpattern Database Manager
some of the help text, then the message:
Plugin rss_admin_db_manager install failed!

The freshly downloaded plugin code looks fine in the preview window; the error happens when I hit install. I’ve had this error with both 4.0.4 and 4.0.5 – other plugins have installed fine.

Mary · 2007-07-11 03:02:33

This is caused by a combination of three things: your database is using latin1 rather than utf8, you have MySQL’s strict mode on, and the plugin appears to be trying to use a unicode character (which I suspect is some sort of mistake or corruption in the plugin file, rather than intentional inclusion). Turning strict mode off should allow you to install the plugin, but the plugin should be checked to make sure the problem is fixed.

To turn off strict mode:

If you open up your my.ini or my.cnf, and you should find a line similar to this:

# Set the SQL mode to strict
sql-mode="STRICT_ALL_TABLES"

You may have other values in there as well (NO_AUTO_CREATE_USER, NO_ENGINE_SUBSTITUTION, etc), but the STRICT_ALL_TABLES is the one you want to remove, even if only temporarily. Save your changes and restart your MySQL server.

Info on MySQL’s SQL modes

hhriebe · 2007-07-11 03:39:23

Great analysis! It was actually STRICT_TRANS_TABLES, but that did the trick. But it begs the question: should I be using UTF8 with Txp or did you just mean that this would have allowed the plugin to insert its unicode character? As you say, the plugin needs fixing anyway since this will prevent installation where one does not have access to the MySQL configuration file if necessary.

Thanks for your help!

damienbuckley · 2007-07-18 01:36:47

I havent gone through the whole forum though I may have a fix for people getting the following error:

Warning: unlink(/home/ourwynn/public_html/files/1183096682-ourwynn_main.sql.gz) [function.unlink]: No such file or directory in /home/ourwynn/public_html/textpattern/lib/txplib_misc.php(512) : eval()’d code on line 95
textpattern
CategoriesWriteArticlesImagesFilesLinksCommentsEvent CategoriesSectionsPagesFormsStyleDiagnosticsPreferencesUsersVisitor LogsPluginsImportDB ManagerRun SQLDB BackupUnlim Cats

BACKUP FAILED. ERROR NO: 127

I had the same problem on one of two otherwise identical hosting servers and couldnt work out why one worked and one didnt until I remembered that on the one that worked I have PHP safe mode turned off as I run Slideshow Pro. Having turned PHP safe mode off on the faulty server, the backup now runs perfectly. I’d like to add a disclaimer that you should check with your hosting company as to whether or not they allow you to turn off PHP safe mode and also check if there are any security issues with turning it off prior. Obviously every hosting company has a different setup and requirements so please check first.

rsskga · 2007-07-19 22:07:24

I’m having the same issue that steventer had. I followed through the forum thread to understand how some edits allowed him to solve the problem, but because the plugin has been updated, the code he edited no longer exists. So, I don’t know how to go about fixing things. Any help?

steventer wrote:

Doesn’t work for me; this is all I get in the downloaded file:

mysqldump Ver 8.23 Distrib 3.23.58, for pc-linux (i686)
By Igor Romanenko, Monty, Jani & Sinisa
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Dumping definition and data mysql database or table
Usage: mysqldump [OPTIONS] database [tables]
OR mysqldump [OPTIONS] —databases [OPTIONS] DB1 [DB2 DB3…]
OR mysqldump [OPTIONS] —all-databases [OPTIONS]

-A, —all-databases Dump all the databases. This will be same as —databases with all databases selected. -a, —all Include all MySQL specific create options. -#, —debug=… Output debug log. Often this is ‘d:t:o,filename`. —character-sets-dir=… Directory where character sets are -?, —help Display this help message and exit. -B, —databases To dump several databases. Note the difference in usage; In this case no tables are given. All name arguments are regarded as databasenames. ‘USE db_name;’ will be included in the output -c, —complete-insert Use complete insert statements. -C, —compress Use compression in server/client protocol. —default-character-set=… Set the default character set -e, —extended-insert Allows utilization of the new, much faster INSERT syntax. —add-drop-table Add a ‘drop table’ before each create. —add-locks Add locks around insert statements. —allow-keywords Allow creation of column names that are keywords. —delayed-insert Insert rows with INSERT DELAYED. —delete-master-logs Issue RESET MASTER on the master just after taking the dump, and before unlocking tables. This will automatically enable —first-slave. —master-data This will cause the master position and filename to be appended to your output, before unlocking tables. This will automatically enable —first-slave. -F, —flush-logs Flush logs file in server before starting dump. -f, —force Continue even if we get an sql-error. -h, —host=… Connect to host. -l, —lock-tables Lock all tables for read. —no-autocommit Wrap tables with autocommit/commit statements. -K, —disable-keys ‘/*!40000 ALTER TABLE tb_name DISABLE KEYS */; and ‘/*!40000 ALTER TABLE tb_name ENABLE KEYS */; will be put in the output. -n, —no-create-db ‘CREATE DATABASE /*!32312 IF NOT EXISTS*/ db_name;’ will not be put in the output. The above line will be added otherwise, if —databases or —all-databases option was given. -t, —no-create-info Don’t write table creation info. -d, —no-data No row information. -O, —set-variable var=option give a variable a value. —help lists variables —opt Same as —add-drop-table —add-locks —all —quick —extended-insert —lock-tables —disable-keys -p, —password[=…] Password to use when connecting to server. If password is not given it’s solicited on the tty. -P, —port=… Port number to use for connection. -q, —quick Don’t buffer query, dump directly to stdout. -Q, —quote-names Quote table and column names with ` -r, —result-file=… Direct output to a given file. This option should be used in MSDOS, because it prevents new line ‘\n’ from being converted to ‘\n\r’ (newline + carriage return). -S, —socket=… Socket file to use for connection. —tables Overrides option —databases (-B). -T, —tab=… Creates tab separated textfile for each table to given path. (creates .sql and .txt files). NOTE: This only works if mysqldump is run on the same machine as the mysqld daemon. -u, —user=# User for login if not current user. -v, —verbose Print info about the various stages. -V, —version Output version information and exit. -w, —where= dump only selected records; QUOTES mandatory! -X, —xml dump a database as well formed XML -x, —first-slave Locks all tables across all databases. EXAMPLES: “—where=user=‘jimf’” “-wuserid>1” “-wuserid<1” Use ~~T (—tab=…) with —fields~~… —fields-terminated-by=… Fields in the textfile are terminated by … —fields-enclosed-by=… Fields in the importfile are enclosed by … —fields-optionally-enclosed-by=… Fields in the i.file are opt. enclosed by … —fields-escaped-by=… Fields in the i.file are escaped by … —lines-terminated-by=… Lines in the i.file are terminated by …

Default options are read from the following files in the given order:
/etc/my.cnf /var/lib/mysql/my.cnf ~/.my.cnf
The following groups are read: mysqldump client
The following options may be given as the first argument:
—print-defaults Print the program argument list and exit
—no-defaults Don’t read default options from any options file
—defaults-file=# Only read default options from the given file #
—defaults-extra-file=# Read this file after the global files are read

Possible variables for option —set-variable (-O) are:
max_allowed_packet current value: 25165824
net_buffer_length current value: 1047551

Wandering Mango · 2007-07-21 05:20:05

I’m trying to get rs_admin_db_manager working, but am encountering “BACKUP FAILED. ERROR NO: 2” when I try to do a backup. I’m not even sure what “error no: 2” is – can anyone fill me in? In any case, here are the vitals:

Textpattern 4.04
mysqldump 8.23
mysql database version 5.0.37-log
rss_admin_db_manager 4.3

Debug line:

mysqldump -hpaomysql23.soerver.net -u*** -p*** -Q —add-drop-table qaj > /home/content/j/a/i/qaj/html/files/1184995060-qaj.sql

When I say not to lock tables, or to skip backing up the log file, I get a 20 byte backup – just containing the mysqldump help file. I’m supposing this is because certain options are not recognised. Any help would be appreciated.

Last edited by Wandering Mango (2007-07-21 05:20:33)

ellen · 2007-07-28 11:49:45

Hello,

I’ve installed the plugin in my local TXP installation (Mac OS X + MAMP) and it creates backups when I klick the .gzip link. Unfortunately the backup seems to be empty. I unpacked and checked the .sql file and it contained nothing. I’ve tried four times and each backup has not more than 20 bytes… What am I doing wrong?

My intention is to use the backup for creating the tables on my server.

Last edited by ellen (2007-07-28 11:52:02)

hhriebe · 2007-07-28 17:11:19

I had a similar experience when I accidentally left the “mysqldump Path” and “mysql Path” configuration fields empty. They should at least contain the words mysqldump and mysql – if you still get errors then you need to specify the complete path.

Textpattern CMS

Textpattern CMS support forum

#136 2007-02-16 18:25:53

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

#137 2007-02-25 12:55:08

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

#138 2007-03-05 23:08:15

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

#139 2007-05-20 15:15:39

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

#140 2007-05-29 09:01:35

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

#141 2007-05-31 13:09:30

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

#142 2007-06-23 06:43:06

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

#143 2007-07-10 20:19:36

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

#144 2007-07-11 03:02:33

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

#145 2007-07-11 03:39:23

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

#146 2007-07-18 01:36:47

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

#147 2007-07-19 22:07:24

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

#148 2007-07-21 05:20:05

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

#149 2007-07-28 11:49:45

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

#150 2007-07-28 17:11:19

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

Board footer