Oh, and a followup question that I forgot to ask--what if the two
systems have different db schemas? Is it possible to do some sort of
mapping between the two?
On Fri, Mar 21, 2008 at 1:48 PM, Waynn Lue <[EMAIL PROTECTED]> wrote:
> I'm thinking of buying a license for this tool to do a migration
I do not foresee any issues or problems with the upgrade or the way you are
handling it. MySQL replication should start fine. Just make sure the
snapshot of the database is as current as possible so the I/O etc. catches
up as quickly as possible (which has nothing to do with your 32/64bit
question,
I'm thinking of buying a license for this tool to do a migration from
one server to another, but it's been hard for me to find good
documentation on it after searching for awhile last night. Is it
possible for me to migrate from a 32-bit to a 64-bit system across a
network? How long would perceiv
Hi Saravanan,
Please check http://forums.mysql.com/read.php?97,18003,18003
-Raj.
-Original Message-
From: Saravanan [mailto:[EMAIL PROTECTED]
Sent: Friday, March 21, 2008 1:59 PM
To: mysql@lists.mysql.com
Subject: innodb transaction not works
Hi lists,
We are running database with mi
Hi lists,
We are running database with mixed tables myisam and innodb. I know that innodb
supports transactions. My server is running with default
transaction-isolation=REPEATABLE READ
Whenever our cron runs stats updation scripts. It locks whole table and make
other sql statements which upda
Hello
>>the process of the restore is painful.
i see
even in windows, i dont know why made the backup in that way,
(i dindt change any option to make the backup in the mysql administrator)
if you say that the restore would be painful
thank for your time
Moon's Father wrote:
>
> If you skip
On Fri, Mar 21, 2008 at 10:04 AM, Velen <[EMAIL PROTECTED]> wrote:
> This one is alright but is there an alternative that can be run with the
> mysql> prompt?
Not to dump a file, but to import, yes. Check out the LOAD DATA
INFILE command:
http://dev.mysql.com/doc/refman/5.0/en/load-d
This one is alright but is there an alternative that can be run with the
mysql> prompt?
Thanks.
Velen
- Original Message -
From: "Daniel Brown" <[EMAIL PROTECTED]>
To: "Velen" <[EMAIL PROTECTED]>
Cc:
Sent: Friday, March 21, 2008 6:00 PM
Subject: Re: Optimize db update
> On Fri, Mar 2
On Fri, Mar 21, 2008 at 9:14 AM, Velen <[EMAIL PROTECTED]> wrote:
> This does not solve my problem. DatabaseA and DatabaseB are on 2 seperate
> pc and the only communication that can be use between the two PC is a USB
> pendrive.
>
> Is there another way of copying a table from one Database to
This does not solve my problem. DatabaseA and DatabaseB are on 2 seperate
pc and the only communication that can be use between the two PC is a USB
pendrive.
Is there another way of copying a table from one Database to another?
I don't want to update TableA directly as I want to validate the dat
This is my test
13795620 8.0K -rw-rw 1 mysql mysql 146 Mar 21 17:58 mysql.100
13795622 8.0K -rw-rw 1 mysql mysql 146 Mar 21 17:58 mysql.101
13795623 8.0K -rw-rw 1 mysql mysql 106 Mar 21 17:58 mysql.102
On Thu, Mar 20, 2008 at 10:08 PM, Baron Schwartz <[EMAIL PROTECTED]>
11 matches
Mail list logo