Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
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
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
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
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 | hblack.art | EMAP | A Sea change | Toolkit of Care
I do my best editing after I click on the submit button.
Offline
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
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 | hblack.art | EMAP | A Sea change | Toolkit of Care
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
Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more
anybody else got it running with 4.0.2 thanks
Offline
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