nly need to run selects on data that's been inserted remotely, you
might be better served by replicating the remote tables you need to your
local server.
On Mon, Dec 7, 2009 at 7:16 PM, Bryan Cantwell wrote:
> Does anyone have a suggestion on how a database link (like in Oracle) could
>
At 12:16 PM -0600 12/7/09, Bryan Cantwell wrote:
Does anyone have a suggestion on how a database link (like in
Oracle) could be established between two Mysql databases on
different servers?
It would be awesome if I could write sql that will query both
databases in one query...
You are
Does anyone have a suggestion on how a database link (like in Oracle)
could be established between two Mysql databases on different servers?
It would be awesome if I could write sql that will query both databases
in one query...
--
MySQL General Mailing List
For list archives: http
"梁增辉" <[EMAIL PROTECTED]> wrote on 09/26/2005 09:24:11 AM:
> mysql，您好！
>
> I can't find any information about - How to create database
> link in MySQL. Can YOU help me please.
>
> 致
> 礼！
>
>
> 梁增辉
> [EMAIL PROTECTE
orum!
http://www.databasedevelopmentforum.com
> I can't find any information about - How to create database link in
MySQL. Can YOU help me please.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql，您好！
I can't find any information about - How to create database link in
MySQL. Can YOU help me please.
致
礼！
梁增辉
[EMAIL PROTECTED]
2005-09-26
mysql，您好！
I can't find any information about - How to create database link in
MySQL. Can YOU help me please.
致
礼！
梁增辉
[EMAIL PROTECTED]
2005-09-26
t; > (SID_NAME = MySQL5) /* Your DSN */
> > )
> >
> > Add the following to your tnsnames.ora file:
> >
> > MYSQL5 =
> > (DESCRIPTION=
> > (ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521))
> > (CONNECT_DATA=(SID=MYSQL5))
> > (HS=OK)
> > )
: database link
You may want to think about doing this the opposite way around also, and
look at pushing the data from Oracle in to MySQL. Oracle has something
called "heterogeneous services", which allows you to define ODBC
datasources
as valid entries in the tnsnames.ora file. Then you co
e:
>
> MYSQL5 =
> (DESCRIPTION=
> (ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521))
> (CONNECT_DATA=(SID=MYSQL5))
> (HS=OK)
> )
>
> Reload your Oracle listener (lsnrctl reload), and then connect to the
> Oracle
> database. To set the database link up:
>
&g
e:
>
> MYSQL5 =
> (DESCRIPTION=
> (ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521))
> (CONNECT_DATA=(SID=MYSQL5))
> (HS=OK)
> )
>
> Reload your Oracle listener (lsnrctl reload), and then connect to the
> Oracle
> database. To set the database link up:
>
&g
tl reload), and then connect to the Oracle
database. To set the database link up:
CREATE DATABASE LINK mysql5 CONNECT TO "user" identified by "password" using
'mysql5';
User and password should be a valid user within MySQL, that can connect from
the Oracle host. You s
espond to
[EMAIL PROTECTED]
To
"[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
cc
Subject
Re: database link
Hi Green,
Right now we are doing the same way. The current reporting db is on
oracle, so we use a cronjob and the scripts connects to main db using
database link and
s. It
> would drop the table and get the fresh data from oracle database. So
> can this be done using database link.
>
> Regards
> anandkl
>
>
>
>
> On 9/15/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
> Ananda Kumar < [EMAIL PROTECTED]
AM
To: mysql@lists.mysql.com
Subject: database link
Hi,
How can i connect from MYSQL db to an oracle database. Do we need to
create any database link or use some ODBC.
Please help
regards
anandkl
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
Ananda Kumar <[EMAIL PROTECTED]> wrote on 09/15/2005 10:33:16 AM:
> Hi,
> How can i connect from MYSQL db to an oracle database. Do we need to
create
> any database link or use some ODBC.
> Please help
> regards
> anandkl
The only way to get one MySQL database server
Hi,
How can i connect from MYSQL db to an oracle database. Do we need to create
any database link or use some ODBC.
Please help
regards
anandkl
Frank,
> Yep Jermey are right what he says - Anyone know about using Database
link in Mysql???
This is not built in. You will have to do this within your application.
You can also use some of the MySQL helper apps for this, like mysqldump
in combination with mysql (the command line tool), l
Yep Jermey are right what he says - Anyone know about using Database link in Mysql???
Regards
Frank
- Original Message -
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
To: "Egor Egorov" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, January 2
On Mon, Jan 20, 2003 at 03:49:00PM +0200, Egor Egorov wrote:
> On Monday 20 January 2003 06:36, MySQL wrote:
>
> > I'm woundering if Mysql can use Database link, like Oracle can???
> >
> > Eg. If i have some tables at my labtop, and want to make the same table(
Hi all,
I'm woundering if Mysql can use Database link, like Oracle can???
Eg. If i have some tables at my labtop, and want to make the same table(s) at my
server with this command:
create table test as select * from test@database_link (This is how you do it on
Oracle), but how do I do th
21 matches
Mail list logo
