Re: Linking Mysql tables across databases
Rob Keeling [EMAIL PROTECTED] wrote: Is there a way to create a linked mysql table? I have one master database, which has a table of data I would like to use with three other projects, I want to try to avoid copying the data between three databases, or putting everything in one database, (which could have data protection problems). Is replication the solution for you? http://dev.mysql.com/doc/mysql/en/Replication.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Linking Mysql tables across databases
Is there a way to create a linked mysql table? I have one master database, which has a table of data I would like to use with three other projects, I want to try to avoid copying the data between three databases, or putting everything in one database, (which could have data protection problems). I know I can do this with MS access, but can I do it in a proper database? Thanks Rob Keeling -- -- I love deadlines. I love the whooshing noise they make as they go by. - Douglas Adams -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Linking Mysql tables across databases
Hey Rob, If all the databases are on the same server you can point to every table just with DB_name.Tablename if you have the permissions. Best Regards Alejandro -Mensaje original- De: Rob Keeling [mailto:[EMAIL PROTECTED] Enviado el: Lunes, 06 de Septiembre de 2004 01:22 p.m. Para: [EMAIL PROTECTED] Asunto: Linking Mysql tables across databases Is there a way to create a linked mysql table? I have one master database, which has a table of data I would like to use with three other projects, I want to try to avoid copying the data between three databases, or putting everything in one database, (which could have data protection problems). I know I can do this with MS access, but can I do it in a proper database? Thanks Rob Keeling -- -- I love deadlines. I love the whooshing noise they make as they go by. - Douglas Adams -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]