Re: Moving a MySQL database

From: Yves Goergen (nospam.list_at_unclassified.de)
Date: 08/22/03

  • Next message: Mike Mueller: "icewm menu questions" 
    To: "debian-user" <debian-user@lists.debian.org>
Date: Fri, 22 Aug 2003 17:33:12 +0200

    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
> 
-- 
To UNSUBSCRIBE, email to debian-user-request@lists.debian.org 
with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org
  • Next message: Mike Mueller: "icewm menu questions"

    Relevant Pages

    • Re: RH 8.0 Where is libmysqlclient.so.10 library
      ... > We are using a seperate machine as mysql database server. ... > My question is do i need to install mysql to get this library ??. ...
      (linux.redhat.install)
    • Re: [PHP] copy tables
      ... The content is in a mysql database. ... how about using a status column in the "dev" server that keeps track ... SELECT query accordingly. ...
      (php.general)
    • Re: Embeded MySQL with C#
      ... How can I embed mysql in C#. ... > Like SQL Server and Oracle, etc, it is a server-based RDBMS. ... > is relatively simple - all you require is a .NET data provider. ... > to the mySql database - this is achieved by means of a connection string. ...
      (microsoft.public.dotnet.framework.adonet)
    • Re: Embeded MySQL with C#
      ... How can I embed mysql in C#. ... Like SQL Server and Oracle, etc, it is a server-based RDBMS. ... the mySql database - this is achieved by means of a connection string. ... What .NET data provider are you using? ...
      (microsoft.public.dotnet.framework.adonet)
    • SOS! Root filled, want to recover MySQL data!
      ... logged into my server an hour ago just to find that the root partition ... the data directory associated with my MySQL ...
      (comp.os.linux.setup)