to issue a commit?
-Original Message-
From: sheeri kritzer [mailto:[EMAIL PROTECTED]
Sent: Friday, May 05, 2006 3:02 PM
To: Luke Vanderfluit
Cc: MySQL List
Subject: Re: importing a dumpfile from with the mysql client
On 5/4/06, Luke Vanderfluit [EMAIL PROTECTED] wrote:
[snip]
I started
On 5/4/06, Luke Vanderfluit [EMAIL PROTECTED] wrote:
[snip]
I started this process remotely then went to the site to finish it.
But when the dump finished (several hours later) I was not able to
execute the following commands from my original location.
mysql SET FOREIGN_KEY_CHECKS = 1;
mysql
, one I have wondered about myself.
Is there a way in mysql to attach to session to issue a commit?
-Original Message-
From: sheeri kritzer [mailto:[EMAIL PROTECTED]
Sent: Friday, May 05, 2006 3:02 PM
To: Luke Vanderfluit
Cc: MySQL List
Subject: Re: importing a dumpfile from
-
From: sheeri kritzer [mailto:[EMAIL PROTECTED]
Sent: Friday, May 05, 2006 3:02 PM
To: Luke Vanderfluit
Cc: MySQL List
Subject: Re: importing a dumpfile from with the mysql client
On 5/4/06, Luke Vanderfluit [EMAIL PROTECTED] wrote:
[snip]
I started this process remotely then went to the site
Hi.
I recently imported a dumpfile into mysql4.1.18
I did this using the 'source' syntax from inside the mysql client.
this is syntax I used:
mysqlcreate database dbname;
mysqluse dbname;
-unset the creation of bin-logs in my.cnf
mysql SET SQL_LOG_BIN = 0
then some tips to fast import dump