Re: Mysql and Database Link
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), like this: laptop> mysqldump myDB | mysql -h myserver myDB Regards, -- Stefan Hinz <[EMAIL PROTECTED]> Geschäftsführer / CEO iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: "MySQL" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, January 21, 2003 7:36 PM Subject: Re: Mysql and Database Link 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 20, 2003 4:35 PM Subject: Re: Mysql and Database Link > 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(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 this in Mysql > > > > You can use CREATE .. SELECT statement: > > http://www.mysql.com/doc/en/CREATE_TABLE.html > > > > but you must create indexes manually. > > I think you misunderstand. Those are not really the same. Links in > Oracle (as described to me) allow you to connect multiple servers > together--so you can join between tables on different servers, for > example. > > Jeremy > -- > Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! > <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ > > MySQL 4.0.8: up 1 days, processed 46,297,176 queries (320/sec. avg) > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Mysql and Database Link
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 20, 2003 4:35 PM Subject: Re: Mysql and Database Link > 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(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 this in Mysql > > > > You can use CREATE .. SELECT statement: > > http://www.mysql.com/doc/en/CREATE_TABLE.html > > > > but you must create indexes manually. > > I think you misunderstand. Those are not really the same. Links in > Oracle (as described to me) allow you to connect multiple servers > together--so you can join between tables on different servers, for > example. > > Jeremy > -- > Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! > <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ > > MySQL 4.0.8: up 1 days, processed 46,297,176 queries (320/sec. avg) > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Mysql and Database Link
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(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 this in Mysql > > You can use CREATE .. SELECT statement: > http://www.mysql.com/doc/en/CREATE_TABLE.html > > but you must create indexes manually. I think you misunderstand. Those are not really the same. Links in Oracle (as described to me) allow you to connect multiple servers together--so you can join between tables on different servers, for example. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.8: up 1 days, processed 46,297,176 queries (320/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
