smtlaissezfaire (owner)

Revisions

gist: 214359 Download_button fork
public
Public Clone URL: git://gist.github.com/214359.git
Embed All Files: show embed
Text only #
raw 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41

mysql> show full tables;
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id:    12
Current database: designcause_dev
 
+---------------------------+------------+
| Tables_in_designcause_dev | Table_type |
+---------------------------+------------+
| addresses                 | BASE TABLE | 
| causes_index              | VIEW       | 
| competitions_index        | VIEW       | 
  ...
| votes                     | BASE TABLE | 
+---------------------------+------------+
46 rows in set (0.01 sec)
 
mysql> show create table causes_index;
+--------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+
| View         | Create View                                                                                                                                                                                                                                                                                                                                                                                                                                                            | character_set_client | collation_connection |
+--------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+
| causes_index | CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `causes_index`.... | utf8                 | utf8_general_ci      | 
+--------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+
1 row in set (0.00 sec)
 
mysql> show create table competitions_index;
ERROR 2013 (HY000): Lost connection to MySQL server during query
mysql> show create view competitions_index;
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id:    2
Current database: designcause_dev
 
ERROR 2013 (HY000): Lost connection to MySQL server during query
mysql> show create view competitions_index;
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id:    1
Current database: designcause_dev
 
ERROR 2013 (HY000): Lost connection to MySQL server during query