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....
SW> I feel I may have overlooked something, can anyone help ?
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