MySQL Forums
Forum List  »  MyISAM

Unable to transfer data using mysql?
Posted by: denpsia
Date: October 31, 2005 08:08PM

Hi Everybody,

I am having problem transfering data from server to local mySQL database. The server is not on same place. There is no records inserted on server. The "table1.sql" is created locally. How can I fix this to make it work? Thanks.


Inside Sync.bat file:

mysqldump --host=localhost --user=guest --password=guest testdb table1 > table1.sql

mysql --host=200.200.3.200\192.168.50.200 --user=test --password=test testdb < table1.sql




Follow up. From server to client is working. Server Ver is 3.23 while client is 4.1.11. What is the problem?

Inside SyncServ.bat file:

mysqldump --host=192.168.50.200 localhost --user=test --password=test testdb table1 > table1.sql

mysql --host=localhost --user=guest --password=guest testdb < table1.sql


Bat file above works. But inserting records from cleint to server is not working.

I need help. Thanks.


denpsia

Options: ReplyQuote


Subject
Views
Written By
Posted
Unable to transfer data using mysql?
4510
October 31, 2005 08:08PM
1876
November 01, 2005 05:43PM
1936
November 02, 2005 12:20AM
1823
November 02, 2005 12:49AM
1796
November 02, 2005 05:26PM
1824
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.