Go to main content

Textpattern CMS support forum

You are not logged in. Register | Login | Help

#73 2005-09-08 09:31:17

kees-b
Member
From: middelburg, nl
Registered: 2004-03-03
Posts: 235
Website

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

When exporting a database from my textdrive (mysql 4.1) account and trying to import it on a server running mysql 4.0 the import generates an error because of charset compatability issues. They can be overcome by adding the --compatible=mysql40 parameter when using mysqldump. It would be very nice to have this as an option like the lock tables option.

Last edited by kees-b (2005-09-08 09:32:22)

Offline

#74 2005-09-08 11:33:34

alexandra
Member
From: Cologne, Germany
Registered: 2004-04-02
Posts: 1,370

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

Hi, i get this Warning:

<code>/usr/local/bin/mysqldump -htextpattern.kbbu.de -utxpa -ptxpres —add-drop-table —skip-lock-tables —skip-add-locks txpa | gzip > /www/htdocs/txpa/files/1126179035-txpa.sql.gz

Warning: popen,escapeshellcmd,proc_open,proc_nice() has been disabled for security reasons in /www/htdocs/txpa/textpattern/lib/txplib_misc.php(429) : eval()’d code on line 75

Warning: pclose(): supplied argument is not a valid stream resource in /www/htdocs/txpa/textpattern/lib/txplib_misc.php(429) : eval()’d code on line 76</code>

Anybody an idea what i have to fix?

Last edited by alexandra (2005-09-08 11:35:32)

Offline

#75 2005-09-10 21:42:23

andreas
Member
Registered: 2004-02-28
Posts: 453
Website

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

I tried to use the plugin but get an error message:

<code>
Warning: unlink(/home/www/ww6199/html/akv2/_db-backup/1126388389-usr_ww6199_4.sql.gz): File or Directory not found in /home/www/ww6199/html/akv2/textpattern/lib/txplib_misc.php(429) : eval()’d code on line 82
</code>

BACKUP FAILED. ERROR NO: 126

Any ideas? The paths to mysql and mysqldump are correct (I checked with my host)

Last edited by andreas (2005-09-10 21:43:16)

Offline

#76 2005-09-10 23:25:19

aba
Plugin Author
Registered: 2004-04-14
Posts: 119

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

> Warning: popen,escapeshellcmd,proc_open,proc_nice() has been disabled for security reasons in /www/htdocs/txpa/textpattern/lib/txplib_misc.php(429) : eval()’d code on line 75

> Anybody an idea what i have to fix?

It depends where you get this error. If it is your server, check the php.ini, if it is a hosted server you are probably out of luck. The message is misleading, these commands have been found in txplib_misc.php not disabled there. They are disabled globally.

Offline

#77 2005-09-17 22:35:32

serff
New Member
Registered: 2005-09-17
Posts: 4

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

> andreas wrote:

> I tried to use the plugin but get an error message:

><code>
>Warning: unlink(/home/www/ww6199/html/akv2/_db-backup/1126388389-usr_ww6199_4.sql.gz): File or >Directory not found in /home/www/ww6199/html/akv2/textpattern/lib/txplib_misc.php(429) : eval()’d code on line >82
></code>

>BACKUP FAILED. ERROR NO: 126

>Any ideas? The paths to mysql and mysqldump are correct (I checked with my host)

I was having this same problem and I think there is a bug in what ever calls mysqldump. I have a “(” in my password and so you put mysqldump -u me -p(jfkdjslkfj blah…. and mysqldump barfs on it. If you out quotes around the password, it works. For now, I’m just changing my password.

Offline

#78 2005-10-13 20:23:04

wet
Developer
From: Lenzing, Austria
Registered: 2005-06-06
Posts: 3,267
Website

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

I’d like to suggest one minor addition to clarify the location of backups for the novice user:

97: tr(tdcs(hed("Previous Backup Files in $file_base_path",1),7)).


Adding ‘DESCRIBE’ to the set of valid SQL commands might also come handy for those among us who haven’t inhaled TxP’s table structure yet (me).

Sorry to say but I am one of those poor souls whose hosting provider has disabled popen(), so backup and restore won’t work:

Warning: popen() has been disabled for security reasons in /www/xxxxx/textpattern/lib/txplib_misc.php(429) : eval()’d code on line 32

Offline

#79 2005-11-23 09:23:42

colak
Admin
From: Cyprus
Registered: 2004-11-20
Posts: 8,753
Website GitHub Twitter

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

Site hosted in textdrive. I get ‘ BACKUP FAILED. ERROR NO: 2’ when trying to backup an SQL file. gzipped files seem to be created fine.

Also can somebody explain the option: Lock Tables?


Yiannis
——————————
neme.org | hblack.net | State Machines | NeMe @ github
I do my best editing after I click on the submit button.

Offline

#80 2005-11-23 10:30:21

soulship
Member
From: Always Sunny Charleston
Registered: 2004-04-30
Posts: 669
Website

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

colak,

What server are you on? I have accounts on Pendrell, Bidwell and Burnaby and it seems to work fine on all three for me. I’m sure that doesn’t help, but it’s something to good to know.

<p style=“margin:0px 0px 0px 20px; color: #6C6C6C; font-weight: bold; font-size: 9pt;”>Quote: </p> <div style=“margin:0px 20px 0px 20px; padding:10px 10px 10px 10px; background-color:#EBEBEB; border:1px dotted #D1D1D1; font-size: 9pt;” ><em>—lock-tables, -lLocks all tables on the server before starting the dump. MySQL uses a READ LOCAL lock, which allows concurrent inserts.</em></div>

Offline

#81 2005-11-23 13:13:53

colak
Admin
From: Cyprus
Registered: 2004-11-20
Posts: 8,753
Website GitHub Twitter

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

> soulship wrote:

> colak,

What server are you on? I have accounts on Pendrell, Bidwell and Burnaby and it seems to work fine on all three for me. I’m sure that doesn’t help, but it’s something to good to know.

Hi Jamie
I’m on jervis.

Also thanks for the explanation re the lock tables. :)


Yiannis
——————————
neme.org | hblack.net | State Machines | NeMe @ github
I do my best editing after I click on the submit button.

Offline

#82 2005-11-23 13:53:11

andreizinca
New Member
Registered: 2005-08-10
Posts: 6

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

Hello Rob.

First, I want to thank you for such a wonderful plugin. It is a real time saver and very useful.

I have installed it on textpattern 4.0 with success. But, on textpattern 4.0.2 it sais plugin install failed.
What to do ?

Thank you!

Last edited by andreizinca (2005-11-23 13:53:28)

Offline

#83 2005-11-23 16:07:57

shishira
Member
From: Bangalore India
Registered: 2005-04-17
Posts: 62
Website

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

anybody else got it running with 4.0.2 thanks

Offline

#84 2005-11-23 16:36:14

soulship
Member
From: Always Sunny Charleston
Registered: 2004-04-30
Posts: 669
Website

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

I have it working in 4.02 on quite a few installs. I am wondering if you have someting blocked by your host maybe? I don’t know enough about the back side of this to know what functions might be turned away from a hosting co. though….

Offline

Board footer

Powered by FluxBB