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.) to
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
se
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 th