To be honest, I'm not sure if you can just transport the db files. I'm sure
it won't work it you're using different versions of MySQL on the machines.
What I do when going from Win2K to FreeBSD is a mysqldump to extract the SQL
statements to recreate the table. I'll use SELECT ... INTO OUTFILE
Contact your ISP and ask them if they already have and/or are willing to
set-up something for you. Here's an instance. One host I have used before
is TierraNet. They use cron to run a CGI script, named crontask.cgi, at
3AM. You can put anything you want to in that script (Perl, C/C++, etc.)
What do you mean by bring data down? Would this be over a network? If
so, what OS would the other machine be running? I'll assume it's Unix
because that's my favorite. Seeing that mysql prints to STDOUT you could
write a script to interface with MySQL, get the output, encrypt it, and then
mysqldump
It comes with MySQL.
- Original Message -
From: Kevin [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, August 06, 2001 3:57 PM
Subject: WANTED: Utility to reverse engineer existing database
I need a utility that will probe my existing mysql database, analyze the
90+