mysqlhotcopy doesn't work as the db is on a remote host. The -x flag to mysqldump also doesn't work, no permission...
I'm grabbing a dump file once per day. On 7/8/05, Bernd Eidenschink <[EMAIL PROTECTED]> wrote: > Hi. > > just a thought, Stephen: > Is it possible for you as an Admin to start the Database Update > from another server via ssh? If so, you could backup and delete > the database dump in one step and run all that via a cronjob > from another server?! > If they have 'mysqlhotcopy', this is what I use on one of our > servers: > /usr/bin/mysqlhotcopy $database -u <USERNAME> \ > -h localhost --password=<PW> --addtodest <TARGETDIR> > or one file via dump > mysqldump -u <USERNAME> -p<PW> -x --all-databases >dump.sql > (or --databases db1 db2 ...) > > 'mysqlhotcopy' would probably run faster and produce smaller > files (if this is an issue), but 'files', that would have to > be tarred. > > As long as we don't upload any files to the Wiki, the database > backup is all we need I guess. > > Bernd. > > > ------------------------------------------------------- > This SF.Net email is sponsored by the 'Do More With Dual!' webinar happening > July 14 at 8am PDT/11am EDT. We invite you to explore the latest in dual > core and dual graphics technology at this free one hour event hosted by HP, > AMD, and NVIDIA. To register visit http://www.hp.com/go/dualwebinar > _______________________________________________ > naviserver-devel mailing list > naviserver-devel@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/naviserver-devel >
