Van writes:
> sinisa@stripped wrote:
> >
> > Denis Voitenko writes:
> > > I am in a process of moving four databases from Access to MySQL. The
Linux
> > > box that I am moving the database to has no backup device except a floppy
> > > drive :-) so I've been thinking about copying files nightly to a NT
server
> > > that has a tape drive over SMB. Now, which files would I need to backup?
Do
> > > I mysqldump the databases before I back them up?
> > >
> > > Denis Voitenko
> > > denis@stripped
> > >
> > >
> > >
> > >
> > >
> >
> > Try to run mysqldump (with -e and -q options at least) through gzip
> > stream to the tape.
> >
> > I never heard that tape devices can be exported by Windoze .......
> >
> > There are other methods.
> >
> > Sinisa
> Another thought: Hook up to the MySQL dbase through ODBC from the NT
> box via Access, do a mysqldump, and use WinAT to backup up the Access
> DBase. Not very elegant, but, in lieiu of a UNIX solution, this should
> provide something somewhat adequate. I'm currently replicating MySQL to
> MSSQL 6.5 over ODBC to an NT Server that backups to Tape. Much cleaner,
> but, Access should suffice.
> Regards,
> Van
Hi Van!
Very cute solution.
There are better ones:
1. NT backup software accepts streams (why not ?). You than run
mysqldump from NT, through gzip to backup software.
2. NT backup software has a client for Linux (why not ?). You run
mysqldump on linux through gzip to backup client on Linux.
3. You transfer tape device to Linux. The best solution !!!! You do
backups on Linux with a pleasure, and on NT you run some backup
client, like BRU or some other, there are a few around,, for example.
Sinisa
+----------------------------------------------------------------------+
| TcX ____ __ _____ _____ ___ == mysql@stripped |
| /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic |
| /*/ /*/ /*/ \*\_ |*| |*||*| mailto:sinisa@stripped|
| /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus |
| /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____ |
| ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ |
| /*/ \*\ Developers Team |
+----------------------------------------------------------------------+
