CodeCharge Studio
search Register Login  

Visual PHP Web Development

Visually Create Internationalized Web Applications, Web Reports, Calendars, and more.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> General/Other

 How to select records from MySQL server A and insert to the table of MySQL server B

Print topic Send  topic

Author Message
tony

Posts: 10
Posted: 08/11/2009, 3:37 AM

please help thanks!
View profile  Send private message
damian

Posts: 838
Posted: 08/11/2009, 8:22 AM

http://forums.codecharge.com/posts.php?post_id=107600 ?

_________________
if you found this post useful take the time to help someone else.... :)
View profile  Send private message
Oper


Posts: 1195
Posted: 08/11/2009, 11:41 AM

Same Server or Different Server?
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)

http://www.PremiumWebTemplate.com
Affiliation Web Site Templates

Please do backup first
View profile  Send private message
tony

Posts: 10
Posted: 08/11/2009, 3:14 PM

Thanks for your reply.
I want to select some records from one server and insert into a Different Server,any ideas?
View profile  Send private message
Oper


Posts: 1195
Posted: 08/12/2009, 1:16 PM

what we are doing right now is
open 2 Connection (both server)

and copy from one connection to another safe fields value in temporary variable

and the Insert.

another method if tehre are too many records is Open one connection create a Text File with the Records and the Import to the 2nd Tablbe / server

both work ok

_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)

http://www.PremiumWebTemplate.com
Affiliation Web Site Templates

Please do backup first
View profile  Send private message
tony

Posts: 10
Posted: 08/12/2009, 5:06 PM

Thanks for your solution Oper!
View profile  Send private message

Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Internet Database

Visually create Web enabled database applications in minutes.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.