Dear Steve,

> (eg adding "drop table columns_priv; before the CREATE TABLE
columns_priv;

You can use various options for mysqldump, like --add-drop-table. This
will add a drop table statement :)

Anyway, it's always a good idea to re-create tables and their data. One
reason: By default, mysqldump will add TYPE=MyISAM to every create table
statement, so old ISAM tables will be set up with the new (and better)
MyISAM format. Another reason: Tables will automatically be in
"optimized" state.

Regards,

--
  Stefan Hinz
  Geschäftsführer / CEO iConnect e-commerce solutions GmbH
  #  www.js-webShop.com www.iConnect.de
  #  Gustav-Meyer-Allee 25, 13355 Berlin
  #  Tel: +49-30-46307-382  Fax: +49-30-46307-388

----- Original Message -----
From: "Steve Wright" <[EMAIL PROTECTED]>
To: "Grigory Bakunov" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, August 07, 2001 10:40 AM
Subject: Re: Truncated User List


> I've tried mysqldump, it worked perfectly, my data is now on the new
machine.
> I did have to alter the output file so the tables in the mysql
database where
> recreated without error.
> (eg adding "drop table columns_priv; before the CREATE TABLE
columns_priv;
> line)
> What I want to know now is why didn't just moving the /var/lib/mysql/
> databases work ?
> I was given to understand if I wanted to exactly duplicate all the
databases
> on a machine I could just tar them & move them ?
> Is this not the case ?
>
> With Thanks
> Steve
>
> ---
> On Tuesday 07 August 2001 06:32, you wrote:
> > Date |Mon, 6 Aug 2001 13:51:09 +0100
> > From |Steve Wright <[EMAIL PROTECTED]>
> >
> > Hello!
> >
> >
> > SW> Hi,
> > SW> Wondering if anyone can here can help,
> > SW> We've got a small selection of MySQL databases used by our
customers
> > (for SW> websites).
> > SW> Until now we've used the Debian package of MySQL (latest deb.
version),
> > SW> however the systems are being updated & we're starting to use
source
> > builds, SW> (this is where the problem starts).
> >
> > SW> I have 3.23.39 built & installed, we installed the old databases
on the
> > new SW> machine by shutting down the sql server & duplicating the
> > /var/lib/mysql SW> directory structure.
> > SW> When the users are listed on the new machine however half are
missing,
> > I am SW> very confused as I don't seem to be able to make them
reappear !
> > SW> I have looked in the /var/lib/mysql/mysql/user. files & can see
them &
> > SW> /etc/my.cnf is looking in the right place....
> >
>
> > You must use mysqldump utility for data export and then
> > import old data to the table.
> > It's much clean way.
> > http://www.mysql.com/doc/m/y/mysqldump.html
> >
> > ___________________________________________________________________
> > For technical support contracts, visit https://order.mysql.com/
> > This email is sponsored by SWSoft, http://www.asplinux.ru/
> >    __  ___     ___ ____  __
> >   /  |/  /_ __/ __/ __ \/ /    Grigory Bakunov <[EMAIL PROTECTED]>
> >  / /|_/ / // /\ \/ /_/ / /__   MySQL AB / SWSoft
> > /_/  /_/\_, /___/\___\_\___/
> >        <___/   www.mysql.com
> >
> >
>
> ---------------------------------------------------------------------
> > Before posting, please check:
> >    http://www.mysql.com/manual.php   (the manual)
> >    http://lists.mysql.com/           (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
> > <[EMAIL PROTECTED]> Trouble
> > unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
> ---------------------------------------------------------------------
> Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to