<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2802" name=GENERATOR></HEAD>
<BODY style="MARGIN-TOP: 2px; FONT: 10pt Arial; MARGIN-LEFT: 2px">
<DIV>Thanks for that, turns out that I did not need to do that after all just
had to add some parameters and it worked ok so far.</DIV>
<DIV> </DIV>
<DIV>Thanks and Happy New Year to Plug Members</DIV>
<DIV> </DIV>
<DIV>Jon<BR><BR>>>> mike.gilks@westnet.com.au 4:38:03 pm 31/12/2005
>>><BR>On Saturday 31 December 2005 15:37, Jon Miller wrote:<BR>> I
have a file that creates a mysql database when I do the following:<BR>> mysql
<create.sql<BR>> The database already exists, but I was told I need to re
enter the command<BR>> and now I'm getting the database already exist.
Is there a way to running<BR>> this command with some form or overwrite
command or update command.<BR>><BR>In the script 'create.sql' you probably
have a line which says<BR>create database somedb<BR>or similar.<BR>This needs to
be changed to <BR>create database if not exists somedb<BR>then if the database
is already there it will be ignored.<BR><BR>If you are creating tables in the
same script you will have to do the same for <BR>all the tables also.<BR><BR>See
the documentation at<BR><A
href="http://dev.mysql.com/doc/refman/4.1/en/create-database.html">http://dev.mysql.com/doc/refman/4.1/en/create-database.html</A><BR><BR>Hope
this
helps.<BR><BR>Love<BR>Mike.<BR>_______________________________________________<BR>PLUG
discussion list: plug@plug.org.au<BR><A
href="http://www.plug.org.au/mailman/listinfo/plug">http://www.plug.org.au/mailman/listinfo/plug</A><BR>Committee
e-mail: committee@plug.linux.org.au<BR></DIV></BODY></HTML>