Hello Kevin,
Thursday, July 03, 2003, 12:28:38 AM, you wrote:
For example you can do this: /with Perl/
Make connection to first database , then fill data from table source in array, then
make
connection to another database and fill data from array to another
table.
K> Hello,
K> I have two mys
On Wed, Jul 02, 2003 at 02:28:38PM -0700, Kevin wrote:
> Hello,
>
> I have two mysql databases running on different hosts - the database are
> similiar in structure. I would like to copy specific tables from one db to
> another db on a scheduled basis.
>
> Is there a command to replicate a table
Hello,
I have two mysql databases running on different hosts - the database are
similiar in structure. I would like to copy specific tables from one db to
another db on a scheduled basis.
Is there a command to replicate a table from one db to another on a
different host?
TIA
-roy
--
MySQL G
, 2003 10:28 AM
-->To: Joe Stump; MySQL (E-mail)
-->Subject: RE: table copy
-->
-->I have tried using myisamchk, but I do not believe it is fixing the
-->problem because I am still getting the same errors. Here's the
output I
-->get from it:
-->
-->
-->ba
ySQL (E-mail)
Subject: RE: table copy
REPAIR TABLE tbl_name QUICK;
You could try that or check out myismchk (sp?)
--Joe
--
Joe Stump <[EMAIL PROTECTED]>
http://www.joestump.net
"Label makers are proof God wants Sys Admins to be happy."
-Original Message-
From: Cas
ednesday, May 28, 2003 7:56 AM
To: MySQL (E-mail)
Subject: table copy
I made the mistake of copying the MYI, MYD, and frm files of a table while
the mysql server was running. Unfortunately the table is now reporting the
following error:
./mysqlshow: Cannot list columns in db: rt2, table: Key
I made the mistake of copying the MYI, MYD, and frm files of a table while the mysql
server was running. Unfortunately the table is now reporting the following error:
./mysqlshow: Cannot list columns in db: rt2, table: Keywords: Incorrect information in
file: 'Table.frm'
What is the easiest wa
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: "Oláh Barnabás" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, December 05, 2002 1:44 PM
Oláh,
Thursday, December 05, 2002, 2:44:24 PM, you wrote:
OB> I want to copy one table's structure to another (non existing) table, but i
OB> didn't find any command or example to do that. Exactly, the situation is the
OB> following:
OB> A dynamic database structure has tables. We want to copy any
On 5 Dec 2002, at 14:44, Ol h Barnab s wrote:
> "SELECT * INTO [temptablename] FROM [sourcetablename] WHERE id is null"
>
> and the SQL server creates a [temptablename] table with no records (or we
> hope that ;) )
> But we can't do this on MySQL server, 'cause MySQL isn't know the
> "SELECT...INT
Hello!
I want to copy one table's structure to another (non existing) table, but i
didn't find any command or example to do that. Exactly, the situation is the
following:
A dynamic database structure has tables. We want to copy any of tha tables
(while we don't know that table's structure) to anot
11 matches
Mail list logo