Go to main content

Textpattern CMS support forum

You are not logged in. Register | Login | Help

#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!):

  1. Paging. Displaying every single row in the table at once could get intense.
  2. 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

#64 2005-08-29 17:24:55

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

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

#65 2005-08-30 01:49:40

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

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

Updated to version 4.0.2Download

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

#66 2005-08-30 13:45:32

theturninggate
Member
Registered: 2004-11-07
Posts: 185
Website

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

#67 2005-08-30 13:49:45

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

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

#68 2005-08-31 14:58:56

theturninggate
Member
Registered: 2004-11-07
Posts: 185
Website

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

#70 2005-09-02 17:55:18

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

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

#72 2005-09-07 04:34:26

RHD
Member
From: mid-Atlantic US
Registered: 2004-11-09
Posts: 29
Website

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

Board footer

Powered by FluxBB