title: How to delete a bad trigger
body: <p>On Mysql Version 5.0.77, I ran this </p>
  
  <pre><code>CREATE TRIGGER ins_trap_to_memory AFTER INSERT on Table1
  FOR EACH ROW 
  INSERT INTO Table1_Copy SELECT NEW.*;
  </code></pre>
  
  <p>It ran, but now the database is disconnecting whenever I try to do certain things:</p>
  
  <p>Can't view triggers-</p>
  
  <pre><code>mysql&gt; SHOW TRIGGERS LIKE '%'\G
  ERROR 2006 (HY000): MySQL server has gone away
  No connection. Trying to reconnect...
  Connection id:    7
  Current database: mydb
  
  ERROR 2013 (HY000): Lost connection to MySQL server during query
  </code></pre>
  
  <p>Can't drop the problem trigger-</p>
  
  <pre><code>mysql&gt; DROP TRIGGER ins_trap_to_memory;
  ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3
  </code></pre>
  
  <p>Can't query information_schema.TRIGGERS-</p>
  
  <pre><code>mysql&gt; select * from information_schema.TRIGGERS;
  ERROR 2006 (HY000): MySQL server has gone away
  No connection. Trying to reconnect...
  Connection id:    12
  Current database: information_schema
  
  ERROR 2013 (HY000): Lost connection to MySQL server during query
  </code></pre>