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