wrote:
> - Original Message -
> > From: "Peng Yu"
> >
> > Suppose I have two servers (one on mac and one on ubuntu), at any
> > time I only change one server but not both servers. After I have done
> >
> > I think that probably it is OK to synchr
- Original Message -
> From: "Peng Yu"
>
> Suppose I have two servers (one on mac and one on ubuntu), at any
> time I only change one server but not both servers. After I have done
>
> I think that probably it is OK to synchronize these two servers at
>
servers (one on mac and one on ubuntu), at any time
I only change one server but not both servers. After I have done
changes on A, I want to propagate the changes to B. After I have done
changes on B, I want to propagate the changes to A.
I think that probably it is OK to synchronize these two servers at
ere, MySQL, InterBase, NexusDB and Firebird!
Database questions? Check the forum:
http://www.databasedevelopmentforum.com
I have a two databases, one in a production environment (let's call it
db_prod) and the other in a testing environments (Let's call it db_test).
What is the bes
>> What is the best way to synchronize the database schemas? db_test has had a
>> few indexes and constraints added to several tables and I need to generate a
>> MySQL script to apply these changes to db_prod.
Ruby on Rails comes with tools to dump and load db schemas;
it
On 1/21/10 12:03 PM, "Price, Randall" wrote:
> I have a two databases, one in a production environment (let's call it
> db_prod) and the other in a testing environments (Let's call it db_test).
>
> What is the best way to synchronize the database schemas? db_
t (let's call it
> db_prod) and the other in a testing environments (Let's call it db_test).
>
> What is the best way to synchronize the database schemas? db_test has had a
> few indexes and constraints added to several tables and I need to generate a
> MySQL script to
vegiv...@gmail.com [mailto:vegiv...@gmail.com] *On Behalf Of *Johan
> De Meersman
> *Sent:* Friday, January 22, 2010 1:06 AM
> *To:* Daevid Vincent
> *Cc:* mysql@lists.mysql.com; Price, Randall
>
> *Subject:* Re: Best way to synchronize two database schemas
>
> Simple: pr
ts to do. A "diff" if you will.
>
> ÐÆ5ÏÐ
> Light travels faster than sound. This is why some people appear bright
> until you hear them speak.
>
> _
>
> From: vegiv...@gmail.com [mailto:vegiv...@gmail.com] On Behalf Of Johan De
> Meersman
> Sent: Friday,
to:vegiv...@gmail.com] On Behalf Of Johan De
Meersman
Sent: Friday, January 22, 2010 1:06 AM
To: Daevid Vincent
Cc: mysql@lists.mysql.com; Price, Randall
Subject: Re: Best way to synchronize two database schemas
Simple: prefix the change files with mmddhhmm formatted timestamps, so
they sort corr
above methodology.
>
> > -Original Message-
> > From: vegiv...@gmail.com [mailto:vegiv...@gmail.com] On
> > Behalf Of Johan De Meersman
> > Sent: Thursday, January 21, 2010 10:35 AM
> > To: Price, Randall
> > Cc: mysql@lists.mysql.com
> > Subject: Re:
-Original Message-
> From: vegiv...@gmail.com [mailto:vegiv...@gmail.com] On
> Behalf Of Johan De Meersman
> Sent: Thursday, January 21, 2010 10:35 AM
> To: Price, Randall
> Cc: mysql@lists.mysql.com
> Subject: Re: Best way to synchronize two database schemas
>
&
x27;s call it
> db_prod) and the other in a testing environments (Let's call it db_test).
>
> What is the best way to synchronize the database schemas? db_test has had a
> few indexes and constraints added to several tables and I need to generate a
> MySQL script to apply these ch
I have a two databases, one in a production environment (let's call it db_prod)
and the other in a testing environments (Let's call it db_test).
What is the best way to synchronize the database schemas? db_test has had a
few indexes and constraints added to several tables and
Check this out
http://dev.mysql.com/tech-resources/articles/syncman/index.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
eplication - but the manual should tell you whether
this is a problem or is handled well by MySQL.
--
Rhino
- Original Message -
From: "abhishek jain" <[EMAIL PROTECTED]>
To:
Sent: Sunday, May 07, 2006 11:41 AM
Subject: How to synchronize two databases
Dear Friends,
Dear Friends,
I have two databases with the same name and table structure but the content
is different, I need to synchronize them i mean the data inside one database
need to be updated with the other one leaving the etries which are similar.
Let me give a single example:
DB1:table1
Rows like
Well I know about it and I am working on MySQL
Replication, the point is that you dont have control
over replicatation when your MySQL server is installed
by your ISP on shared server,
In that case it is simply not possible :)
Moreover, the simple setup I have, I prefer this then
the nittygrittie
It is very easier with mysql replication concipt, this automatic
replication from Master server to Slave server and real time. I wonder
how you do not know about this.
http://dev.mysql.com/doc/mysql/en/replication.html
Love kumar ..
[EMAIL PROTECTED] wrote:
SQLyog Enterprise's Database Sync Tool
SQLyog Enterprise's Database Sync Tool is the answer
for your queries.
www.webyog.com
Rgds,
Karam
--- Paul Godard <[EMAIL PROTECTED]> wrote:
> Hi
>
> I use mysql/php on several client web sites (each
> client has its own
> db). For development purpose, I have a local web
> server with
> php/
The mySQL command should read :
mysql -u username -p[password] db_name < dumpfile
Note that you can give the password on the command line but it is best
to get into the habit of just providing -p and typing in the password
when prompted.
BTW, when doing the mysqldump for tables that already exis
On Wed, 9 Feb 2005 15:48:12 +0200, Paul Godard <[EMAIL PROTECTED]> wrote:
> >On Wed, 9 Feb 2005 13:10:16 +0200, Paul Godard <[EMAIL PROTECTED]> wrote:
> >> Hi
> >>
> > > I use mysql/php on several client web sites (each client has its own
> >> db). For development purpose, I have a local web se
On Wed, 9 Feb 2005 13:10:16 +0200, Paul Godard <[EMAIL PROTECTED]> wrote:
> Hi
>
> I use mysql/php on several client web sites (each client has its own
> db). For development purpose, I have a local web server with
> php/mysql. When a web site is still in development, this is the
> master db, ev
Hi
I use mysql/php on several client web sites (each client has its own
db). For development purpose, I have a local web server with
php/mysql. When a web site is still in development, this is the
master db, even if a copy has been uploaded on the live web server at
my isp. When a site is co
This may not be entirely a database question, but it certainly involves
MySQL databases.
BACKGROUND:
I'm working with a small business that hosts their own web site for order
taking/managing orders via internet. It only consists of one DSL line, one
web server (apache/bind/tomcat) and one databa
cept for one caveat - when I make a change to the
> database structure I have to make the same change to all the client
> databases. Before I roll up my sleeves I thought I'd ask if there is
> an easy way to synchronize the structure of databases so I can make
> my changes to clientdb1
same change to all the client databases. Before I roll up my sleeves I
thought I'd ask if there is an easy way to synchronize the structure of
databases so I can make my changes to clientdb1 and then apply the changes
to clientdb2...N.
Thanks!
Lance
sql,
OTECTED]>
Sent: Saturday, May 11, 2002 1:07 AM
Subject: Re: Distributed MySQL : How to synchronize ?
> On Fri, May 10, 2002 at 04:51:15PM +0200, Christophe Demange wrote:
> > Hello,
> >
> > I have a question:
> >
> > We want to real-time synchronize a MySQL databas
0 May 2002 23:07
> To: Christophe Demange
> Cc: [EMAIL PROTECTED]
> Subject: Re: Distributed MySQL : How to synchronize ?
>
>
> On Fri, May 10, 2002 at 04:51:15PM +0200, Christophe Demange wrote:
> > Hello,
> >
> > I have a question:
> >
> > We want to re
On Fri, May 10, 2002 at 04:51:15PM +0200, Christophe Demange wrote:
> Hello,
>
> I have a question:
>
> We want to real-time synchronize a MySQL database part with a
> distant database. We have a central database containing all the
> data. This database must share several
Hello,
I have a question:
We want to real-time synchronize a MySQL database part with a distant
database.
We have a central database containing all the data. This database must share
several parts (records) with the local databases.
All transactions made in the central database must be
Hi!
>>>>> "Rich" == Rich Foreman <[EMAIL PROTECTED]> writes:
Rich> Hi,
Rich> I have two servers (one remotely hosted, and one locally) that I would like
Rich> to have the same database on for backup purposes.
Rich> I would like the two databases to
In the last episode (Jan 15), Rich Foreman said:
> I have two servers (one remotely hosted, and one locally) that I
> would like to have the same database on for backup purposes. I would
> like the two databases to synchronize automatically and all the time.
>
> Is there currentl
Hi,
I have two servers (one remotely hosted, and one locally) that I would like
to have the same database on for backup purposes.
I would like the two databases to synchronize automatically and all the time.
Is there currently any way to do this?
Remote server: FreeBSD running MySQL 3.23.40
On Fri, Oct 26, 2001 at 05:52:58PM +0800, sj wrote:
> hi,
>
> I have two machine, install mysql, create same database.
>
> I want these two database can be the same at any time. in other
> word, if one table be inserted a record in one machine, then the
> same table in another machine can be i
hi,
I have two machine, install mysql, create same database.
I want these two database can be the same at any time. in other word, if
one table be inserted a record in one machine, then the same table in
another machine can be inserted same record also.
Who can tell me how to realize this fu
Hi,
I am looking for an easy way to synchronize two mysql-databases (only
the sql-structure). I want to compare two structure dumps, find out the
differences and get alter table statements as result.
CU
Dorthe
-
Before
37 matches
Mail list logo