Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Re: upm_db_admin: Requests and Progress
the_ghost wrote:
the size of backup will vary from one site to another.
Yes. I use too many plugins — my average DB size is 2-3Mb. Without automatic rotation, a daily “incremental” (in the loose sense of the word) across my 6 TXP installs would chew up 10-20Mb a day :-\
faster to import my own backup sql, than write a ticket, wait for response, write an argument why to restore backup, wait again for response and so on
True. Host support does often suck. Certainly backing your own stuff up is preferable. I just tend to do it ad-hoc (usually when I’m about to make big changes I might need to undo) rather than on a scheduled basis. Maybe it’s just me as I like to do things by hand!
Last edited by Bloke (2009-02-23 12:28:54)
The smd plugin menagerie — for when you need one more gribble of power from Textpattern. Bleeding-edge code available on GitHub.
Txp Builders – finely-crafted code, design and Txp
Offline
Re: upm_db_admin: Requests and Progress
Another short thought: Create a backup set
My provider (if I get it right) only allows one backup file to be up to two MB. Scratching that limit I think that a batch backup option makes sense:
- Create a new directory
- Backup every single table as one zipped backup file
- ‘Restore’ should be adopted to ‘batch backup’ accordingly
Without that ‘batch backup option’ I must manually backup every single table.
Does that make sense?
Get all online mentions of Textpattern via OPML subscription: TXP Info Sources: Textpattern RSS feeds as dynamic OPML
Offline
#15 2009-02-23 13:45:46
- FireFusion
- Member
- Registered: 2005-05-10
- Posts: 698
Re: upm_db_admin: Requests and Progress
Can backup be the default tab. To make it easier for clients
Offline
#16 2009-06-22 01:51:16
- Mary
- Sock Enthusiast
- Registered: 2004-06-27
- Posts: 6,236
Re: upm_db_admin: Requests and Progress
Those of you for whom the backup/restore portion of Rob’s plugin does not work: does that same server have PHP’s safe mode enabled?
Offline
Re: upm_db_admin: Requests and Progress
merz1 wrote:
Another short thought: Create a backup set
My provider (if I get it right) only allows one backup file to be up to two MB. Scratching that limit I think that a batch backup option makes sense:
So basically your dump command is limited or the query size? Or the file size? Which?
Mary wrote:
Those of you for whom the backup/restore portion of Rob’s plugin does not work: does that same server have PHP’s safe mode enabled?
For me just dump and other high level db talk command are just disabled. It’s really usual in cheap web hosting biz. Only way around it is to use export library (like phpmyadmin’s).
Last edited by Gocom (2009-06-22 02:51:17)
Offline
Re: upm_db_admin: Requests and Progress
So basically your dump command is limited or the query size? Or the file size? Which?
I think it’s the file size which is limited but I have no chance to test it right now.
Get all online mentions of Textpattern via OPML subscription: TXP Info Sources: Textpattern RSS feeds as dynamic OPML
Offline
Re: upm_db_admin: Requests and Progress
Mary wrote:
Those of you for whom the backup/restore portion of Rob’s plugin does not work: does that same server have PHP’s safe mode enabled?
- safe_mode: on
- $backup_cmd:
mysqldump -h127.0.0.1 -u... -p... --add-drop-table --skip-lock-tables dbname > /[...].sql - result from
popen($backup_cmd, 'r')in$dumpIton line #36:NULL
Offline
#20 2009-06-23 15:40:39
- Mary
- Sock Enthusiast
- Registered: 2004-06-27
- Posts: 6,236
Re: upm_db_admin: Requests and Progress
Thanks Jukka and Robert. Anyone else?
Offline
Re: upm_db_admin: Requests and Progress
Just happened on this one, and I thought “nice work, darth mary!” Looking forward to seeing this.
Offline
Re: upm_db_admin: Requests and Progress
any updates on this?
Last edited by iblastoff (2009-08-22 20:04:06)
Offline
#23 2009-08-23 10:26:25
- Mary
- Sock Enthusiast
- Registered: 2004-06-27
- Posts: 6,236
Re: upm_db_admin: Requests and Progress
No major updates to report, other than Nora Brown has agreed to help with the interface design.
Offline
Re: upm_db_admin: Requests and Progress
Hi,
Great to see this plugin being developed – it will be a lot quicker than using PHPMyAdmin :)
Cheers,
Nick
“Eat food. Not too much. Mostly plants.” – Michael Pollan
Offline