California’s jewel San Fransisco is sparkling with the colors of Oracle, as the world’s premier Oracle conference Oracle Open World draws very near. Database lovers from across the globe are gathering up in SFO to undergo a life-enchanting experience. This Log Buffer Edition covers that, and the posts related to MySQL and SQL Server in [...]

The MySQL developer tools team announces the availability of version 5.2.44
of the MySQL Workbench GUI tool. This version contains various fixes
and minor enhancements and includes 8 resolved bugs.

This version improves the Migration Tool to support additional RDBMSes
- PostgreSQL 8.x and 9.x
- Sybase Adaptive Server Enterprise 15.x
- Any RDBMS that implements the INFORMATION_SCHEMA views from the SQL-92 standard

Additionally, MySQL Utilities 1.1.0 have been included on the distribution.

For a full list of issues fixed in this release, see http://dev.mysql.com/doc/workbench/en/changes-5.2.x.html

Please get your copy from our Downloads site. In Windows, you can also
use the MySQL Windows Installer to update Workbench.

Sources and binary packages are available for several …

Calling all SF-Bay Area Sphinxes, Thursday, October 11, 2012 at 6:30 PM, Andrew Aksyonoff (CEO/Founder) will be speaking at the San Francisco MySQL Meetup.  He’ll take the audience into a world where Sphinx goes beyond ‘old-school’ fulltext search.  Into a reality where this unique engine performs blazing full-scans, easy multi-core and multi-box queries, and wicked (fast) [...]

New Benchmarks for Smaller Tables (10,000 Records) are now available

at www.paralleluniverse-inc.com/benchmarks.shtml .

Do you ever get annoyed by the backticks in the output when you run SHOW CREATE TABLES in MySQL? I do. There are certainly places where I like the backticks -- for example in the output of mysqldump -- but when I run SHOW CREATE TABLES I usually don't want the backticks, and I end up stripping them out.

Enter sql_quote_show_create. This session variable allows you to turn the backticks on and off in your session.

I'm sure this session variable has been around for years, but I just recently discovered it and I like it.

Here's a quick example to show it in action:

``` mysql> show create table sakila.film_text\G 1. row

 …

Do you ever get annoyed by the backticks in the output when you run SHOW CREATE TABLES in MySQL? I do. There are certainly places where I like the backticks -- for example in the output of mysqldump -- but when I run SHOW CREATE TABLES I usually don't want the backticks, and I end up stripping them out.

Enter sql_quote_show_create. This session variable allows you to turn the backticks on and off in your session.

I'm sure this session variable has been around for years, but I just recently discovered it and I like it.

Here's a quick example to show it in action:

``` mysql> show create table sakila.film_text\G 1. row

 …

Do you ever get annoyed by the backticks in the output when you run SHOW CREATE TABLES in MySQL? I do. There are certainly places where I like the backticks -- for example in the output of mysqldump -- but when I run SHOW CREATE TABLES I usually don't want the backticks, and I end up stripping them out.

Enter sql_quote_show_create. This session variable allows you to turn the backticks on and off in your session.

I'm sure this session variable has been around for years, but I just recently discovered it and I like it.

Here's a quick example to show it in action:

``` mysql> show create table sakila.film_text\G 1. row

 …

Hi!

I'm speaking at MySQL Connect next Saturday, Sep. 29. My Session is a hands-on lab (HOL) on MySQL Cluster.

If you are interested in familiarize a bit with MySQL Cluster this is definitely a session for you.

I will start by briefly introducing MySQL Cluster and its architecture. Then I will guide you through the needed steps to install a local MySQL Cluster, connect to it (using the command line), monitor its logs, and safe shutdown it.

We will hence have a chance to see which are the most common commands using in MySQL Cluster administration (e.g. Cluster backup) as well as the most common operations (e.g. online datanode …

The North Texas MySQL Users Group will be meeting on October 8th in the Irving office. At the last meeting, the several members wanted to learn more on MySQL replication and that is how we came up with a subject for the meeting.

This is NOT the Oracle office in Irving. One day we need to have a state wide meeting and it just be in the vicinity of this famous place!

We will start at five PM sharp, will have refreshments, and we will cover the basics of MySQL replication plus the new features that will come with MySQL 5.6.

All are welcome!

When:
Monday October 8th at 5PM
(doors lock at 5 sharp and we will have to send
someone out to get you if you are late)

Location:
Dallas – Irving Connection
6031 Connection Drive
Suite 900
Irving, TX …

i have this error :

Could not connect: Lost connection to MySQL server at ‘reading initial communication packet’, system error: 0

what should i do?
thanks