-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Neil, et al --
...and then Neil Tompkins said...
%
% Hi
Hi!
%
% Thanks for that information. But I think I want to purchase a software
% application, due to my lack of knowledge for mySQL. In addition to this,
% my ISP doesn't allow that much control over the operating system.
Sure, I can recommend some. It's called, um, David's Fabulous Backup
Software, and for the monthly license fee of, uh, let's say $1000 you get
a custom installation and configuration. It's very closely modeled after
mysqldump and uses only open-source software (primarily mysqldump).
OK, all kidding aside, that's what mysqldump is for and it does its job
well. I'm no mysql greybeard but other than a system backup tool
(Veritas NetBackup, Legato Networker, tar, BRU, whatever) I don't know of
anything that fits your bill ("does not involve mysql" as I understand
it).
%
% Can anyone recommend a software app. I could buy to be able to dump data
% and table structures to a text file. Ideally as mentioned before I need to
% run this on a hourly basis.
You must be doing something very important to have to back up your data
multiple times per day. I'm not being at all facetious when I say that;
most people back up their data once a night or even once a week.
To what do you plan to write your backups? Tape? Another directory on
the same server? Your home hard drive over the 'net? Backing up your
database ten to twenty times per day will chew up a lot of space even if
the instance is small, and if it's not separate from your server then
you've gained nothing if the disk head crashes (same disk) or the server
gets hacked or goes wacko (different disk or RAID or whatnot) or the
place burns down.
You say your ISP doesn't allow that much control over the operating
system. Do they not offer backups as part of your package, or as a part
that you could buy?
I don't know what you're doing or where you're hosting or how much data
is involved, but if you really have something important enough that you
have to back it up hourly then I would 1) look into other ISPs/ASPs and
2) check out having one or more slave servers, which can replicate the
data in real time and then go offline to allow backups. Oh, yeah; let me
know which tape company you'll use so that I can buy some stock!
Usually I'd recommend myself to someone who needs individual services
such as the ability to back up his database, but I won't touch this one;
anything that really needs to be backed up that frequently needs serious,
industrial-strength work. I can design and implement it, though, at my
usual consulting rates; you might want to sit down with me (or anyone
else, but *someone*) and see what you really need and what it's going to
cost you.
%
% Rgds,
% Neil
HTH & HAND
mysql query,
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED] -- Mary Baker Eddy, "Science and Health"
http://www.justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg!
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.7 (FreeBSD)
iD8DBQE96pOCGb7uCXufRwARAhQtAKDkE9P8ZNUV1E6aISM/X2f7274J0ACgonbn
H+Ws5zJmRHs1h0TKjd4vyPo=
=Kixn
-----END PGP SIGNATURE-----
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
