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 move the databases to a new machine it doesn't work.
Is there more than just the /usr/local/mysql, /var/lib/mysql & /etc/my.cnf
that needs to be moved ?
(I'm trying flushing the tables then moving the databases now)
Steve
---
On Tuesday 07 August 2001 11:32, you wrote:
> If you want to do that, you have to flush all tables and shut the
> server down, IIUC. Then it should work, I think - and I think we
> did this before, but I am not sure.
>
> Steve Wright schrieb am Dienstag, 7. August 2001, 10:40:04:
> > 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
