I have been running Enterasys backups from cron (for MANY YEARS) with a
script that looks exactly like your command except that my cron script
lacks the "--no-create-info" flag. That's not a material difference.
Also, I have been *restoring* from the expected command (filling in the
complete paths to mysql and my.ini left as an exercise for the reader) too:
mysql --defaults-file=my.ini --user=netsight --password=<PASSWORD>
netsight < <RESTOREFILE>
I used to use the GUI to restore my backups until I timed it a couple
years ago. The GUI restore (on older hardware that's now been upgraded)
took 45 minutes, the CLI restore (the command above) took 7 minutes. I
pre-test almost every version of Netsight before installing it on the
production server, so I "restore" my backup on a vanilla server fairly
often [it's vanilla because I sometimes use it for other tests]. I've
been using the command-line mysql tools for this for long enough that
I've stopped worrying about it. Every major version, I try to remember
to lob a message to GTAC that I do things this way and does that set off
any alarm bells, and so far I've been told if it's been working, it
shouldn't break. In which case, I can and do use those other 38 minutes
to get back to work.
HTH,
- Joni
On 10/26/10 10:48 PM, Lucas Hazel wrote:
After initially being advised that it was not possible to backup the
NetSight database on the command line, thus automating the process, I
have determined the command that NetSight uses backup the database.
/usr/local/Enterasys_Networks/NetSight/mysql/bin/mysqldump
--defaults-file=/usr/local/Enterasys_Networks/NetSight/mysql/my.ini
--hex-blob --user=netsight --password=<PASSWORD> --lock-tables
--extended-insert --quick --no-create-info --complete-insert
--result-file=<RESULT FILE LOCATION> netsight
I have successfully restored from a backup made using this command, but
before I turn it into an automated process I’d like to be sure that it
is safe to do so. Does anyone else currently do backups in a similar
fashion?
---
To unsubscribe from enterasys, send email to [email protected] with the body:
unsubscribe enterasys [email protected]
