MySQL setup cloning?

From: Carl Fink (carl_at_fink.to)
Date: 06/30/05

  • Next message: Steve Lamb: "Re: Perl upgrade risks" 
    Date: Wed, 29 Jun 2005 20:56:56 -0400
To: debian-user@lists.debian.org

    Is there some simple way to duplicate a MySQL setup from one server to
    another, with all tables, queries, and accounts/passwords? Perhaps just
    copying certain files?

    I'm not a MySQL expert (obviously), just trying to have a warm backup server
    ready if the main one goes down. I don't need two-way replication at all,
    just the ability to manually copy everything over once a day or so.

    Thanks.
    --
    Carl Fink carl@fink.to
    Jabootu's Minister of Proofreading
    http://www.jabootu.com 

    -- 
To UNSUBSCRIBE, email to debian-user-REQUEST@lists.debian.org 
with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org
  • Next message: Steve Lamb: "Re: Perl upgrade risks"

    Relevant Pages

    • Re: MySQL setup cloning?
      ... > Is there some simple way to duplicate a MySQL setup from one server to ... > another, with all tables, queries, and accounts/passwords? ... > I'm not a MySQL expert, just trying to have a warm backup server ...
      (Debian-User)
    • Re: Homegrown synchronization
      ... copying the zip file sitting there on the server to ... It is a filecopy of the zipped backend file from the server to the ... with the server whose SyncApp zips ups the production backend file ...
      (microsoft.public.access.replication)
    • Re: Homegrown synchronization
      ... copying the zip file sitting there on the server to ... It is a filecopy of the zipped backend file from the server to the ... with the server whose SyncApp zips ups the production backend file ... forced logoff functionality in the SyncApp. ...
      (microsoft.public.access.replication)
    • Re: Network Question on Cluster - Windows 2003 Enterprise R2 server
      ... are you opening the SMB connection using NetBIOS or DNS name resolution? ... I tried a copying data from one node to another server, which both servers should use the public network connection but this does not happen. ...
      (microsoft.public.windows.server.clustering)
    • Re: Howto: ssh X11 display to Win2k
      ... you should now be able to start the VNC server as per my ... > first reply and connect to it with vncviewer from your win2k box. ... Copying vncviewer to /usr/local/bin ...
      (linux.redhat.misc)