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