Re: Moving a MySQL database
providing you're using the same or a newer mysql server on your new system, you just need to copy the whole data directory of your mysql installation. copying the files is sufficient, but do not change the filenames nor directory structure in itself.
in case you're switching from 3.x to 4.0.x, you should also run the given scripts over your new database, to get the new privileges. this is documented anywhere in the mysql-doc under 'updating'.
--
Yves Goergen
nospam.list@unclassified.de
Please don't CC me (causes double mails)
-----Ursprüngliche Nachricht-----
Von: "Roberto Sanchez" <rcsanchez97@yahoo.es>
An: "debian-user" <debian-user@lists.debian.org>
Gesendet: Freitag, 22. August 2003 17:03
Betreff: Moving a MySQL database
> I have a MySQL database residing on a RH9 server. I have started building a
> Debian server running woody to replace it. Is there an easy way to grab the
> whole database and move it over as is?
>
> -Roberto
>
> ___________________________________________________
> Yahoo! Messenger - Nueva versión GRATIS
> Super Webcam, voz, caritas animadas, y más...
> http://messenger.yahoo.es
>
>
> --
> To UNSUBSCRIBE, email to debian-user-request@lists.debian.org
> with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org
>
Reply to: