tables (the default) in MySQL, then you can just copy the data and
configuration files from machine to machine. You'll have to install
MySQL on the new machine first, of course.
If you're running other table types (such as InnoDB), I believe you
have to dump them to SQL files (mysqldump will do the deed), and then
run the file on the new server. You can still drag the MyISAM tables
(such as for the 'mysql' database). I know the InnoDB tablespace is
portable across machines, but I've never tried to move it, so I can't
offer advice. Dumping the SQL and reinserting isn't much of a pain
unless your databases are huge.
cheers,
barneyb
On Wed, 11 Aug 2004 08:25:22 -0400, Burns, John D
<[EMAIL PROTECTED]> wrote:
> Our main dev server went nuts yesterday and I've been tasked to rebuild
> it. I'm trying to build another server just like the original as fast as
> possible so all of our developers aren't dead in the water without the
> dev server. I've run into a few questions/problems that I'd like to see
> if the list can help with.
>
> 1. Where can I download a 6.1 installer so I can install straight to 6.1
> without installing from the CD first and then upgrading? I tried
> downloading the one on the 6.1 upgrade page but when I try to run it it
> says "Please extract the installer to a different directory" and I've
> tried moving it to all kinds of directories with no luck, so I'm
> guessing that the installer wants to be extracted to the directory where
> CFMX 6.0 already exists? This is a brand new Dell with Windows 2003
> Server (I already know the gotchas for installing 6.1 on Win2k3 with
> IIS).
>
> 2. Our dev server also is running an instance of SQL server with
> approximately 15 databases inside. What's the best way to move all of
> the databases (and, if possible, the SQL settings and logins and
> security) from one server to the next. I wasn't sure if I could just
> copy the data files over or if I needed to run backups on each database
> to get those files. Any tips or tricks would be extremely helpful.
>
> 3. We also have an instance of MySQL installed, which I'm not 100% sure
> needs to be on the new server, but if it does, any tips or tricks for
> moving that over?
>
> Thanks in advance for the help!
>
> John Burns
--
Barney Boisvert
[EMAIL PROTECTED]
360.319.6145
http://www.barneyb.com
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
