MySQL Forums
Forum List  »  MyISAM

Re: Unable to transfer data using mysql?
Posted by: denpsia
Date: November 02, 2005 12:20AM

I tried the option mysql323 and it works. Thanks Kim Seong Loh. Replicating using mysqldump and mysql only duplicates same records with same primary key by overwriting them. Right?

Example
Client Server
ID 01 01
ID 02 02
ID 03 03
ID 04 04

In the example above the client will override the record data in the server, and not add four new records. Right?

**Another problem it create a new table with the data and did not insert records to old table.

Old Table name: Testtable (0 records)
new Table name: testtable (4 records)

denpsia



Edited 1 time(s). Last edit at 11/02/2005 12:48AM by denpsia.

Options: ReplyQuote


Subject
Views
Written By
Posted
4512
October 31, 2005 08:08PM
1876
November 01, 2005 05:43PM
Re: Unable to transfer data using mysql?
1936
November 02, 2005 12:20AM
1824
November 02, 2005 12:49AM
1796
November 02, 2005 05:26PM
1825
November 03, 2005 10:17PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.