riginal Message -
From: "Daniel Brown" <[EMAIL PROTECTED]>
To: "Velen" <[EMAIL PROTECTED]>
Cc:
Sent: Friday, March 21, 2008 6:10 PM
Subject: Re: Optimize db update
> On Fri, Mar 21, 2008 at 10:04 AM, Velen <[EMAIL PROTECTED]> wrote:
> > This one i
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:
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
rsday, March 20, 2008 10:20 PM
Subject: Re: Optimize db update
> On Thu, Mar 20, 2008 at 1:41 PM, Velen <[EMAIL PROTECTED]> wrote:
> >
> > Actually I am updating TableA in DatabaseA with values from TableB in
DatabaseB. Database B is on a stand alone PC. I'm using VB6 t
Are the table structures identical ?
If so, you could just move the data files themselves.
Otherwise consider using
unload from table B into seperated format (mysql load format)
truncate table A
load data infile into table A
On Thu, Mar 20, 2008 at 2:20 PM, Daniel Brown <[EMAIL PROTECTED]> w
On Thu, Mar 20, 2008 at 1:41 PM, Velen <[EMAIL PROTECTED]> wrote:
>
> Actually I am updating TableA in DatabaseA with values from TableB in
> DatabaseB. Database B is on a stand alone PC. I'm using VB6 to create a
> .txt file containing data from TableB then using VB6 once more to
> recronstr
Hi,
Actually I am updating TableA in DatabaseA with values from TableB in
DatabaseB. Database B is on a stand alone PC. I'm using VB6 to create a .txt
file containing data from TableB then using VB6 once more to recronstruct the
table in DatabaseA then remove all data which are already in Tab
