I was facing the same issue, at last i just close the application and restarted, it resolved the issue.

The other solutions did not work for me, for anyone still looking for a solution I managed to open my model by closing the workbench and double clicking the actual .MWB file in the file explorer.

I hope that helps someone.

For me, was by **closing other tabs** (maybe the tabs that related to eer digram)


Issue is still present in 8.0.17

I had &quot;Error unserializing GRT data data string too long&quot;.

Closing the open &#39;local Instance&#39; database tab allows you to open the model as normal.

I know it&#39;s the same advice as others, just logging a comment for posterity sake that it&#39;s 5 years on and still a problem.

Somehow, through the magic of Angular, if you use `ng-model` and provide it a boolean, your checkbox will be checked if said boolean is true, and unchecked if false.

    &lt;input type=&quot;checkbox&quot; ng-model=&quot;video.hidden&quot;&gt;

While this alone is fairly baffling, I&#39;m actually trying to reverse the checked state, because unlike the todo example where `todo.done` means the box gets checked, my model is more like `todo.incomplete`.

Unfortunately my first guess didn&#39;t work:

    &lt;input type=&quot;checkbox&quot; ng-model=&quot;!video.hidden&quot;&gt;

I&#39;m in a position where the model has been dictated to me, so I can&#39;t change it and don&#39;t want to have to massage it on the client (because I&#39;m sending client objects back to the server, since it&#39;s running in a trusted environment).

**Update**

This works in 1.3 and doesn&#39;t give you strings (1.2.xxx gave you strings instead of booleans):

    &lt;input type=&quot;checkbox&quot; ng-model=&quot;video.hidden&quot; ng-true-value=&quot;false&quot; ng-false-value=&quot;true&quot;&gt;


AngularJS: Reverse Checkbox State

WordPress 3.5 has been released recently, I used the WordPress Media Upload system via thickbox and `window.send_to_editor` for some options in my WordPress theme (backgrounds, logos etc...).

But as you know WordPress has integrated a new Media Manager, I wanted to used this new feature to upload images/files as custom fields. So I spent the morning to find a way to get the wished result.

I found with this solution, which can be useful for some of you. Thanks to give me your feedback on the code or any improvements you have in mind!

HTML Sample:

    &lt;a href=&quot;#&quot; class=&quot;custom_media_upload&quot;&gt;Upload&lt;/a&gt;
	&lt;img class=&quot;custom_media_image&quot; src=&quot;&quot; /&gt;
	&lt;input class=&quot;custom_media_url&quot; type=&quot;text&quot; name=&quot;attachment_url&quot; value=&quot;&quot;&gt;
	&lt;input class=&quot;custom_media_id&quot; type=&quot;text&quot; name=&quot;attachment_id&quot; value=&quot;&quot;&gt;


jQuery Code:

    $(&#39;.custom_media_upload&#39;).click(function() {
			
		var send_attachment_bkp = wp.media.editor.send.attachment;
			
		wp.media.editor.send.attachment = function(props, attachment) {
	
			$(&#39;.custom_media_image&#39;).attr(&#39;src&#39;, attachment.url);
			$(&#39;.custom_media_url&#39;).val(attachment.url);
			$(&#39;.custom_media_id&#39;).val(attachment.id);
				
			wp.media.editor.send.attachment = send_attachment_bkp;
		}
			
		wp.media.editor.open();
			
		return false;
	});

If you want to see every settings contained in the `attachment` variable you can do a `console.log(attachment)` or `alert(attachment)`.

WordPress 3.5 custom media upload for your theme options

I&#39;m having a lubuntu-64bit and installed  MySQL-workbench to open the EER model. but it just doesn&#39;t open up.. 

It shows error 

    Error unserializing GRT data
    error unserializing object (invalid struct)

The same EER file opens fine in windows.. I&#39;m new to this I need to create Database using these on this machine please help.. 




mysql workbench error opening EER

I'm having a lubuntu-64bit and installed MySQL-workbench to open the EER model. but it just doesn't open up..
It shows error
<pre><code class="hljs language-vbnet">Error unserializing GRT data
error unserializing object (invalid struct)
</code></pre>
The same EER file opens fine in windows.. I'm new to this I need to create Database using these on this machine please help..

I have a table that has columns like this for example:

    id,col1,col2,col3,col4

Now, I want to check if `ANY` of `col1, col2, col3, col4` have the passed in value.

The long way to do it would be..

    SELECT * FROM table WHERE (col1 = 123 OR col2 = 123 OR col3 = 123 OR col4 = 123);

I guess it&#39;s the opposite version of `IN`.

Is there an easier way to do what I want?

Checking multiple columns for one value

Per [the MySQL docs][1], there are four TEXT types:

 1. TINYTEXT
 2. TEXT
 3. MEDIUMTEXT
 4. LONGTEXT

What is the maximum length that I can store in a column of each data type assuming the character encoding is UTF-8?


  [1]: http://dev.mysql.com/doc/refman/5.7/en/blob.html

TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT maximum storage sizes

I&#39;m working on a web project with MySql database on Java EE. We needed a view to summarize data from 3 tables with over 3M rows overall. Each table was created with index. But I haven&#39;t found out a way to take advantages in the indexes in the conditional select statement retrieval from the view that we created with [group by].

I&#39;ve getting suggestions from people that **using views in MySql is not a good idea**. Because you can&#39;t create index for views in mysql like in oracle. But in some test that I took, indexes can be used in view select statement. Maybe I&#39;ve created those views in a wrong way.

I&#39;ll use a example to describe my problem.

We have a table that records data for high scores in NBA games, with index on column [happend_in]

    CREATE  TABLE `highscores` (
       `tbl_id` int(11) NOT NULL auto_increment,
       `happened_in` int(4) default NULL,
       `player` int(3) default NULL,
       `score` int(3) default NULL,
       PRIMARY KEY  (`tbl_id`),
       KEY `index_happened_in` (`happened_in`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

insert data(8 rows)

    INSERT INTO highscores(happened_in, player, score)
    VALUES (2006, 24, 61),(2006, 24, 44),(2006, 24, 81),
    (1998, 23, 51),(1997, 23, 46),(2006, 3, 55),(2007, 24, 34), (2008, 24, 37);

then I create a view to see the highest score that Kobe Bryant got in each year

    CREATE OR REPLACE VIEW v_kobe_highScores
    AS
       SELECT player, max(score) AS highest_score, happened_in
       FROM highscores
       WHERE player = 24
       GROUP BY happened_in;

I wrote a conditional statement to see the highest score that **kobe** got in **2006**; 

    select * from v_kobe_highscores where happened_in = 2006;

When I explain it in toad for mysql, I found out that mysql have scan **all rows** to form the view, then find data with condition in it, without using index on [happened_in]. 

    explain select * from v_kobe_highscores where happened_in = 2006;
![explain result][1]


The view that we use in our project is built among tables with millions of rows. Scanning all the rows from table in every view data retrieval is unacceptable. Please help! Thanks!

@zerkms Here is the result I tested on real-life. I don&#39;t see much differences between. I think @spencer7593 has the right point. **The MySQL optimizer doesn&#39;t &quot;push&quot; that predicate down in the view query.**
![real-life test][3]


  [1]: http://i.stack.imgur.com/9fk7A.png
  [3]: http://i.stack.imgur.com/hNJvu.png

How do I get MySQL to use an INDEX for view query?

When I attempt to connect to a MySQL server from PHP, I see the following error:

&gt; Deprecated: The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /path/to/filename.php on line 123

The code on the referenced line is:

    mysql_connect($server, $username, $password);

I am certain that the arguments are correct, and this exact code has been working for years without problem.  Indeed, I obtained it from a well-sourced tutorial on PHP.

1. Why is this happening?

2. How can I fix it?

3. I understand that it&#39;s possible to suppress deprecation errors by setting `error_reporting` in `php.ini` to exclude `E_DEPRECATED`:

        error_reporting = E_ALL ^ E_DEPRECATED

 What will happen if I do that?

The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead

This question has been asked a couple of times in SO and many times in other sites. But I didn&#39;t get any satisfiable answer.  
  
My problem:  
I have a java web application which uses simple **JDBC** to connect to **mysql** database through **Glassfish** application server.  
  
I have used connection pooling in glassfish server with the following configurations:  
Initial Pool Size: 25  
Maximum Pool Size: 100  
Pool Resize Quantity: 2  
Idle Timeout: 300 seconds  
Max Wait Time: 60,000 milliseconds  
  
The application has been deployed for last 3 months and it was running flawlessly too.  
But from last 2 days the following error is coming at the time of login.  
  
**Partial StackTrace**  
  
    com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: No operations allowed after connection closed.Connection was implicitly closed due to underlying exception/error:  
  
    ** BEGIN NESTED EXCEPTION **  
  
    com.mysql.jdbc.CommunicationsException  
    MESSAGE: Communications link failure due to underlying exception:  
  
    ** BEGIN NESTED EXCEPTION **  
  
    java.io.EOFException  
    MESSAGE: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.  
  
    STACKTRACE:  
  
    java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.  
    at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1997)  
    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2411)  
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2916)  
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)  
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)  
    at com.mysql.jdbc.Connection.execSQL(Connection.java:3256)  
    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1313)  
    at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1448)  
    ............  
    ............  
    my application traces....  
  
  
**What caused this error suddenly ?** I have lost a lot of time for this.
  
**EDIT :** The problem even persists after restarting the server. As per DBA two of the important mysql server configurations are:  
**wait_timeout :** 1800 seconds  
**connect_timeout :** 10 seconds  
**NOTE :** Other applications deployed in the same server connecting to the same database and using different pools are running smoothly.  
  
**EDIT-2 :** After reading a lot of things and expecting some positive outcome I made these changes to my connection pool.  
  
**Max Wait Time :** 0 (previously it was 60 seconds)  
**Connection Validation :** Required  
**Validation Method :** table  
**Table Name :** Demo  
**Validate Atmost Once :** 40 seconds  
**Creation Retry Attempts :** 1  
**Retry Intervals :** 5 seconds  
**Max Connection Usage :** 5  
  
And this worked as the application is running for 3 days consistently. But I got a very strange and interesting result of out this. While monitoring the connection pool, I found these figures:  
  
**NumConnAcquired :** 44919 Count  
**NumConnReleased :** 44919 Count  
**NumConnCreated :** 9748 Count  
**NumConnDestroyed :** 9793 Count  
**NumConnFailedValidation :** 70 Count  
**NumConnFree :** 161 Count  
**NumConnUsed :** -136 Count  
  
**How** can the `NumConnFree` become 161 as I have `Maximum Pool Size = 100` **?**  
**How** can the `NumConnUsed` become -136, a *negative* number **?**  
**How** can the `NumConnDestroyed` **&gt;** `NumConnCreated` **?**  


what is java.io.EOFException, Message: Can not read response from server. Expected to read 4 bytes, read 0 bytes

I have installed MySQL Community Edition 5.5 on my local machine and I want to allow remote connections so that I can connect from external source.

How can I do that?

MySQL: How to allow remote connection to mysql

When I try to export my database through MySQL Workbench remotely from localserver,

I am getting some below version error:

&gt;mysqldump Version Mismatch  [Content] mysqldump.exe is version 5.5.16, but the MySQL Server to be dumped has version 5.6.10-log. Because the version of mysqldump is older than the server, some features may not be backed up properly. It is recommended you upgrade your local MySQL client programs, including mysqldump to a version equal to or newer than that of the target server. The path to the dump tool must then be set in Preferences -&gt; Administrator -&gt; Path to mysqldump Tool

I am trying to find a solution - I searched for solution on google but couldn&#39;t find a good answer to solve the issue.

Does anyone know, how to fix this issue in MySQL Workbench?

mysqlworkbench giving version error on exporting database

**Error Code: 2013. Lost connection to MySQL server during query**

I am using MySQL Workbench. Also, I am running a batch of inserts, about 1000 lines total (Ex. `INSERT INTO mytable SELECT * FROM mysource1; INSERT INTO mytable SELECT * FROM mysource2;...mysource3...mysource4` multiplied 1000 times) Each batch takes a considerable amount of time, some of them, more than 600 seconds.

**How can I configure workbench, to continue working overnight, without stopping and without losing the connection?**

MySQL Workbench: How to keep the connection alive

This has been asked a few times but I cannot find a resolution to my problem. Basically when using mysqldump, which is the built in tool for the MySQL Workbench administration tool, when I dump a database using extended inserts, I get massive long lines of data. I understand why it does this, as it speeds inserts by inserting the data as one command (especially on InnoDB), but the formatting makes it REALLY difficult to actually look at the data in a dump file, or compare two files with a diff tool if you are storing them in version control etc. In my case I am storing them in version control as we use the dump files to keep track of our integration test database.

Now I know I can turn off extended inserts, so I will get one insert per line, which works, but any time you do a restore with the dump file it will be slower.

My core problem is that in the OLD tool we used to use (MySQL Administrator) when I dump a file, it does basically the same thing but it FORMATS that INSERT statement to put one insert per line, while still doing bulk inserts. So instead of this:

    INSERT INTO `coupon_gv_customer` (`customer_id`,`amount`) VALUES (887,&#39;0.0000&#39;),191607,&#39;1.0300&#39;);

you get this:

    INSERT INTO `coupon_gv_customer` (`customer_id`,`amount`) VALUES 
     (887,&#39;0.0000&#39;),
     (191607,&#39;1.0300&#39;);

No matter what options I try, there does not seem to be any way of being able to get a dump like this, which is really the best of both worlds. Yes, it take a little more space, but in situations where you need a human to read the files, it makes it MUCH more useful.

Am I missing something and there is a way to do this with MySQLDump, or have we all gone backwards and this feature in the old (now deprecated) MySQL Administrator tool is no longer available?

Using mysqldump to format one insert per line?

I am wondering how do I export table data into a csv? I read that I need to use mysql workbench command line but I can not figure out how to launch the cmd line(don&#39;t know what the command is).

Running on Windows 7 64bit.

Content Type	Original Author	Original Content on Stackoverflow
Question	rakesh	View Question on Stackoverflow
Solution 1 - Mysql	Soumyaansh	View Answer on Stackoverflow
Solution 2 - Mysql	Fuzz	View Answer on Stackoverflow
Solution 3 - Mysql	Zaman	View Answer on Stackoverflow
Solution 4 - Mysql	Fi Horan	View Answer on Stackoverflow

mysql workbench error opening EER

Mysql Problem Overview

Mysql Solutions

Solution 1 - Mysql

Solution 2 - Mysql

Solution 3 - Mysql

Solution 4 - Mysql

WordPress 3.5 custom media upload for your theme options

AngularJS: Reverse Checkbox State

Attributions