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 f
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 with the mysql client
On 5/4/06, Luke Vanderfluit <[EMAIL PROTECTED]> wrote:
:) )
This is a good question, 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
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;
mysq
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:
mysql>create database dbname;
mysql>use dbname;
-unset the creation of bin-logs in my.cnf
mysql> SET SQL_LOG_BIN = 0
then some tips to fast import dump f
* Matthew Stuart
> Right having just got to grips with the mysqldump command, I would like
> to be able to know how to import the database back in to MySQL should
> anything happen to my PC.
Good thinking. :)
> Does mysqlimport have to be done in the command line window like
> mysqldump, and if s
Hi Mat
mysqldump produces files containing SQL statements. mysqlimport allows
you to load data from comma-delimited (or other) text files.
For example, the following line will dump the contents of the table
'goat_painters' in the database 'the_goat_database' into a file called
'goat_painters.
Matthew Stuart wrote:
Right having just got to grips with the mysqldump command, I would
like to be able to know how to import the database back in to MySQL
should anything happen to my PC.
Does mysqlimport have to be done in the command line window like
mysqldump, and if so, how? It's just th
Right having just got to grips with the mysqldump command, I would like
to be able to know how to import the database back in to MySQL should
anything happen to my PC.
Does mysqlimport have to be done in the command line window like
mysqldump, and if so, how? It's just that I tried to import st
