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 files.
mysql> SET FOREIGN_KEY_CHECKS = 0;
mysql> SET AUTOCOMMIT=0;
mysql> SOURCE foo.out-20060419-23
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> COMMIT;
My question is:
Since the import completed the database has grown in size and been
backed up etc.
Yet from the original session I have not executed those 2 commands.
Is it safe to execute them? Or would executing them cause corruption or
other unforseen stuff?
Is it unnecessary to execute them?
Is it safe to kill that original mysql session?
Since the commands were executed from a single session, and the database
has been extensively modified in the meantime, would executing those
commands from the same original session now, cause problems?
Thanks.
Kind regards.
Luke.
--
Luke Vanderfluit.
Analyst/Programmer.
Internode Systems Pty. Ltd.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
