SEO

#1 (**permalink**) 02-28-2008, 07:52 AM

I need to synchronize 2 databases on the same server - everything except one
table.

Any suggestions on the best way to do this?

Thanks in advance.

#2 (**permalink**) 02-28-2008, 07:52 AM

On Wed, 28 Jun 2006 05:24:44 -0700, deko wrote:
> I need to synchronize 2 databases on the same server - everything except one
> table.
>
> Any suggestions on the best way to do this?

Let's start with a different question: why do you want to exclude this
one table?

--
I still want a phone with caller-IQ.
-- Tanuki in the monastery

#3 (**permalink**) 02-28-2008, 07:52 AM

deko wrote:
> I need to synchronize 2 databases on the same server - everything except
> one table.
>
> Any suggestions on the best way to do this?
>
> Thanks in advance.

If by "synchronize" you mean copy all the data, you may use mysqldump.

$ mysqldump --ignore-table=table_name first_db_name | mysql second_db_name

ciao
gmax

--
_ _ _ _
(_|| | |(_|>< The Data Charmer
_|
http://datacharmer.org/

#4 (**permalink**) 02-28-2008, 07:52 AM

"deko" <deko@nospam.com> wrote:

> I need to synchronize 2 databases on the same server - everything
> except one table.
>
> Any suggestions on the best way to do this?

This depends on what you mean by "synchronize". Maybe MySQLs
replication works for your problem. You need 2 MySQL instances
running on the same server for that.

http://dev.mysql.com/doc/refman/5.0/...ion-intro.html
http://dev.mysql.com/doc/refman/5.0/...e-servers.html

XL
--
Axel Schwenke, Senior Software Developer, MySQL AB

Online User Manual: http://dev.mysql.com/doc/refman/5.0/en/
MySQL User Forums: http://forums.mysql.com/

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

How to synchronize 2 databases on same server?