Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
#61 2005-08-26 20:27:33
- aba
- Plugin Author
- Registered: 2004-04-14
- Posts: 119
Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more
> wilshire wrote:
> The plugin is not simply accessing the database. It makes calls to programs included in the mysql installation (with mysqldump being one of them). phpMyAdmin makes use of the same programs.
phpMyAdmin has it’s own export in php and doesn’t need/use mysqldump.
Offline
#62 2005-08-26 21:19:04
- Mary
- Sock Enthusiast
- Registered: 2004-06-27
- Posts: 6,236
Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more
This will be immensely helpful for me as a user and plugin developer. Beautiful work Rob, I’m already in love with it.
Two feature requests (aha! now I’m on the other side of one!):
- Paging. Displaying every single row in the table at once could get intense.
- Fields with large entries causes ‘gross’ scrolling. How about something like this?
I’m all giddy now and off to play…
Offline
#63 2005-08-26 21:35:37
- els
- Moderator
- From: The Netherlands
- Registered: 2004-06-06
- Posts: 7,458
Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more
wilshire wrote:
Don’t you have access to run a dump from the command line?
If I knew where to find that command line…
In either case, if your host doesn’t allow access to the command you won’t be able to do backups with the plugin.
That’s what I feared… A pity, because I really could use this on one of my sites with this host to let the users make backups themselves. Ah well, since I paid for it, I’m going to try the plugin on another site with another host ;)
Offline
Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more
Good ideas Mary. The scrollable tables should be pretty easy to implement. The paging will prolly have to wait until I can work out the rest of the problems I’m working on.
Offline
Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more
Updated to version 4.0.2 – Download
There were some lingering table locking issues having to do with backups and restores that seem to be worked out now thanks to the help of bauhouse.
I added the markup necessary to style the SQL results using the CSS Scrollable table method as Mary suggested but couldn’t quite get the CSS working right. If you use the hpw_admincss plugin you can add the styling as you wish.
If you install the latest version and still have backup/restore problems let me know.
Offline
Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more
I tried to make a dump. It said that I failed with error 127, and gave me the following information in debug mode:
mysqldump -hlocalhost -uproject -pseoul —add-drop-table projectseoul > /home/httpd/vhosts/projectseoul.com/httpdocs/files/1125409398-projectseoul.sql
Warning: unlink(/home/httpd/vhosts/projectseoul.com/httpdocs/files/1125409398-projectseoul.sql): No such file or directory in /home/httpd/vhosts/projectseoul.com/httpdocs/textpattern/lib/txplib_misc.php(429) : eval()’d code on line 82
Any ideas?
Thanks.
Offline
Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more
Sounds like a personal problem ;) (Sorry, couldn’t resist)
The script can’t find the location of the mysqldump executable. See this post above.
Offline
Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more
My host said they don’t make command-line access available. Bother … First thing I’ve ever not liked about them. :(
So this just isn’t going to work, is it?
EDIT: I did get the correct paths to mysql and mysqldump from the hosting provider, but when I tried to make the dump received the 127 error again, with this (which is different from what I’d gotten before):
Warning: unlink(/home/httpd/vhosts/projectseoul.com/httpdocs/files/1125529175-projectseoul.sql): No such file or directory in /home/httpd/vhosts/projectseoul.com/httpdocs/textpattern/lib/txplib_misc.php(429) : eval()’d code on line 82
Last edited by theturninggate (2005-08-31 23:03:33)
Offline
#69 2005-09-01 08:32:56
- heikki74
- Member
- From: Finland
- Registered: 2004-08-17
- Posts: 100
Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more
Would it be easy to add a feature that let’s you backup just some of the tables in the database?
For example by specifying (automatically or manually) the table prefix. This would be handy if there is many textpattern installations sharing the same database. Another case is when you want to move site’s content but not settings (I’m not sure if txp_prefs table could mess another installation).
The idea came from this post: Mysql backup.
Last edited by heikki74 (2005-09-01 08:33:26)
Offline
Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more
theturninggate – The 127 error still means that the path the mysqldump and mysql executables are incorrect. The warning doesn’t matter. Its just inidicating that the plugin is trying to delete a backup file that was never created.
heikki74 – It would be possible to add something like that but I don’t think I’ll have the time anytime soon.
Offline
#71 2005-09-02 19:08:02
- heikki74
- Member
- From: Finland
- Registered: 2004-08-17
- Posts: 100
Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more
No problem. I was just worried that you might have too much spare time. :)
Offline
Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more
Here’s an odd one:
I get the 127 error when I try to back up my DB. Tried turning locking off; no dice. Turned debug mode on, ran the echoed command on my command line and it worked. Refreshed the DB Backup tab and my backup was sitting there, ready to be downloaded.
So, apparently the paths to mysql and mysqldump are correct, but something else is wacky.
Server details: RedHat 7.3, Apache 1.3.29 and MySQL 3.23.56 (4.0.23a according to rss_admin_db_manager, though, which makes me question the rest of what my host tells me).
Site details: Txp 4.0.1, db_manager 4.02.
I run another site on the same host, different server but supposedly identical software, same versions of Txp and db_manager and the DB backup works flawlessly. Hrm.
Offline