On 8/4/06, Chris White <[EMAIL PROTECTED]> wrote:
On Friday 04 August 2006 10:35 am, Daniel da Veiga wrote:
> What if each .sql contains a "DROP TABLE IF EXISTS" statement at the
> start? Something to be carefull if its the program that generated the
> backup likes to add this tags.
What if my website code breaks? This train of "what if" type questions can
easily be answered by a quick skim through the sql before running it. If you
believe that to be tiresome, think of how long it's going to take you to get
order from chaos when things go down.
I dont know exactly what's the purpose of your message. I was just
warning the OP that he should take a look at the SQL before running
it, not taking your advice blindly:
To answer what I think was your original question, no, m-s.sql
wouldn't interfere with a-l.sql's >insertions because they run in
sequence, first a-l, then m-s.
You're wrong, they may run in sequence and still, m-s can interfer in
what a-l has done, it all depends on the program used to generate the
sql and the defaults it put (create tables, drop tables if exist or a
simple sequence of the sql generated in a-l).
Think better before you hit "send".
--
Daniel da Veiga
Computer Operator - RS - Brazil
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
------END GEEK CODE BLOCK------
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
