?
Solved

redgate mysql compare how do I connect to two remotely hosted databases?

Posted on 2010-09-14
4
Medium Priority
?
461 Views
Last Modified: 2013-12-12
I have shared hosting apache php 4.4.8 mysql 4.1.22.

I want to compare the structure using redgate's mysql compare.  How do I connect to these dbs?  Is there a port I need to specify?  It is even possible?

Thanks, I don't know too much about apache.
0
Comment
Question by:jackjohnson44
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 7

Expert Comment

by:tlovie
ID: 33678158
I think that redgate's tools are for MS SQL Server version.  I'm not aware of their tools working on MYSQL

you could use http://www.quest.com/toad-for-mysql/ I believe it has compare features
0
 
LVL 7

Accepted Solution

by:
tlovie earned 2000 total points
ID: 33678570
The screenshot shows that you have to enter the login credentials for both databases.  In the example, you put in the server/port combination.  You'd have to probably configure MySql to use TCP sockets, rather than unix pipes.

http://www.red-gate.com/products/MySQL_Compare/index.htm?gclid=CJ-kgf-TiKQCFZpN5QoduVOTLA

other than that, red-gates tools are incredbibly easy to use!!
0
 
LVL 7

Expert Comment

by:tlovie
ID: 33678572
Also note that Red-gate's mysql compare is for Mysql version 5.0 and greater.
0

Featured Post

Want to be a Web Developer? Get Certified Today!

Enroll in the Certified Web Development Professional course package to learn HTML, Javascript, and PHP. Build a solid foundation to work toward your dream job!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Your data is at risk. Probably more today that at any other time in history. There are simply more people with more access to the Web with bad intentions.
By, Vadim Tkachenko. In this article we’ll look at ClickHouse on its one year anniversary.
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question