git/list[1] front-page[2] threads[3] people[4] search[5] about
 

Re: Mirroring mySQL using Git

From
LRLuciano Rocha <luciano@eurotux.com>
Date
May 6, 2008, 13:24 UTC
Message-ID
<20080506132422.GA13125@bit.office.eurotux.com>
In-Reply-To
<4B58A837F454E14AA0453EDBADE96A62B5F2A2@mildred.leeds-art.ac.uk>
On Tue, May 06, 2008 at 02:03:01PM +0100, Ryan Taylor wrote:
Show 7 quoted lines
> Hi,
> 
> I'm wanting to mirror my mysql databases from my live web box to my dev
> box. The database are updated by a CMS on the live box and I need to be
> able to transfer these updates to the dev box.
> 
> Is this possible with git?

You'd be better off with asynchronous replication. See <http://dev.mysql.com/doc/refman/5.0/en/replication.html>.

Note that you go the git route, or other file-based solution, you'll have to freeze operations to the filesystem where the DBs reside, or you'll corrupt the copy.

-- 
Luciano Rocha <luciano@eurotux.com>
Eurotux Informática, S.A. <http://www.eurotux.com/>
Previous: Ryan TaylorNext: Matthias Kestenholz
Message 2 of 3 in “Mirroring mySQL using Git”
  1. Ryan TaylorMay 6, 2008
  2. Luciano RochaMay 6, 2008
  3. Matthias KestenholzMay 6, 2008

Read the whole thread, see it on lore, or plain text.

$ cat FOOTERMessages come from the public archive at lore.kernel.org/git, fetched every hour. The front page is chosen and written each morning by an AI editor and can be wrong; the threads themselves are the record. About and API. For agents: an MCP server at https://gitlist.dev/mcp, and any thread, story or person page as Markdown by adding .md to its URL (or sending Accept: text/markdown). Details in /llms.txt.