Assuming that both databases are on the same mysqld instance setting
triggers to keep the table up to date should do what you want...
On Thu, Oct 9, 2008 at 10:34 AM, Eric Anderson <[EMAIL PROTECTED]> wrote:
>
> I've got two databases Foo and Bar. Both databases have a table called
> 'zoop_t'. F
On Mon, Mar 10, 2008 at 3:26 PM, Tim McDaniel <[EMAIL PROTECTED]> wrote:
> On Mon, 10 Mar 2008, Daniel Brown <[EMAIL PROTECTED]> wrote:
> > The same question just received an excellent answer from Rolando
> >Edwards about ten minutes ago. Check the archive here:
> >
> >
> >http://marc.inf
On Mon, 10 Mar 2008, Daniel Brown <[EMAIL PROTECTED]> wrote:
On Mon, Mar 10, 2008 at 2:58 PM, skills2go
<[EMAIL PROTECTED]> wrote:
I'm trying to copy a database table form one database to another
on a different server. Is it possible through myphpadmin, or do I
need software? If software, do
On Mon, Mar 10, 2008 at 2:58 PM, skills2go
<[EMAIL PROTECTED]> wrote:
>
> Hi Folks
>
> I'm trying to copy a database table form one database to another on a
> different server. Is it possible through myphpadmin, or do I need software?
> If software, do you know of any good programs to do this?
Hi,
It is
Rename table name to database.tablename.
db-1
db-2
rename db1.tablename to db2.tablename.
This might help you out.
murthy gandikota wrote:
How can I copy tables from one database to another on the same host?
Thanks for your help
Murthy
__
Perhaps the easiest way is with CREATE TABLE... SELECT. For example,
if I have a database called "NYCNH" (by coincidence, I do!) which
contains a table called "checks" and I want to copy that table to a
database called "TEST" I could do this:
mysql> create table test.checks select * from n
are you using:
INSERT INTO
SELECT
FROM ;
I am still a relative beginner and this was the way I was taught. I have
personally never had a problem (but then I was using Oracle in school).
Respectfully,
Ligaya Turmelle
"David Blomstrom" <[EMAIL PROTECTED]> wrote in message
news:[EMAI
On 20 Nov 2002, at 16:01, Steve Buehler wrote:
> Thank You. I am not sure which one is faster because I don't have any HUGE
> tables to test it on, but someone from the PHP mailing list gave me the
> following that works like a charm.
> create table table2 select * from table1
The problem with
Thank You. I am not sure which one is faster because I don't have any HUGE
tables to test it on, but someone from the PHP mailing list gave me the
following that works like a charm.
create table table2 select * from table1
Thanks
Steve
At 02:09 PM 11/20/2002 -0500, you wrote:
On 20 Nov 2002, a
On 20 Nov 2002, at 12:54, Steve Buehler wrote:
> What I am trying to do is to copy a mysql table to a new
> table name in a PHP script.
Use the query "SHOW CREATE TABLE $from_table" to get the SQL
statement for creating the table, then do
$create_table_sql = preg_replace(
At 15:16 -0400 10/14/02, Dennis wrote:
>At 02:51 PM 10/14/2002, you wrote:
>> > Is there a way to copy a table from one mySQL machine to another without
>>> implementing replication? The goal is be able to grab a copy of a table
>>> from some other machine (without regard to master/slave relati
At 02:51 PM 10/14/2002, you wrote:
> > Is there a way to copy a table from one mySQL machine to another without
> > implementing replication? The goal is be able to grab a copy of a table
> > from some other machine (without regard to master/slave relationships) in
> > some programmatic way withou
On Mon, 14 Oct 2002, Dennis wrote:
> Is there a way to copy a table from one mySQL machine to another without
> implementing replication? The goal is be able to grab a copy of a table
> from some other machine (without regard to master/slave relationships) in
> some programmatic way without havin
April 15, 2002 9:24 AM
Subject: Re: Copying tables
> Your message cannot be posted because it appears to be either spam or
> simply off topic to our filter. To bypass the filter you must include
> one of the following words in your message:
>
> sql,query
>
> If you just re
http://www.mysql.com/doc/R/E/RENAME_TABLE.html says:
As long as two databases are on the same disk you can also rename from one
database to another:
RENAME TABLE current_database.table_name TO other_database.table_name;
And as the user comments say, you can use ALTER TABLE with 3.22.
Copying c
15 matches
Mail list logo
