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 <eid...@we...> wrote:
> Hi.
>=20
> 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=3D<PW> --addtodest <TARGETDIR>
> or one file via dump
> mysqldump -u <USERNAME> -p<PW> -x --all-databases >dump.sql
> (or --databases db1 db2 ...)
>=20
> 'mysqlhotcopy' would probably run faster and produce smaller
> files (if this is an issue), but 'files', that would have to
> be tarred.
>=20
> As long as we don't upload any files to the Wiki, the database
> backup is all we need I guess.
>=20
> Bernd.
>=20
>=20
> -------------------------------------------------------
> This SF.Net email is sponsored by the 'Do More With Dual!' webinar happen=
ing
> 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 H=
P,
> AMD, and NVIDIA. To register visit http://www.hp.com/go/dualwebinar
> _______________________________________________
> naviserver-devel mailing list
> nav...@li...
> https://lists.sourceforge.net/lists/listinfo/naviserver-devel
>
|
