Steve Wright schrieb am Dienstag, 7. August 2001, 18:49:43:
> I don't mean to sound ungrateful to those who are trying to help me, I just
> need to grasp an understanding of what is causing my problem & why.
> mysqldump has helped me & solved moving my databases, however I can still
> recreate
Ok, I follow that, in future when moving databases I will use mysqldump.
However, I still wish to know why moving the databases by duplicating the
files & directory structure does not work. This is 100% repeatable and I
can't see why (unless file(s) exist I am not copying).
If for some reason s
[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
I shut the server down but did not flush the tables, presumably that
shouldn't matter (data saved to disk at server shutdown) ?
Also if I replace the binary files (debian) on the old server with the new
compile I can restart sql (now source build) & use my databases perfectly,
its only when I
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 di
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 de
