Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 30 of 1389 Next 30 Older Entries

Displaying posts with tag: Oracle (reset)

HowTo Video: Using MySQL ASP.NET MVC Project Wizard
Employee +0 Vote Up -0Vote Down
MySQL for Visual Studio 1.2.x recently became a GA version. One of the main features included in this version was the new MySQL ASP.NET MVC Wizard. This wizard allows the creation of a new ASP.NET MVC application using a MySQL existing database and a data entity model with Entity Framework 5 or 6 version. In this video you will see this feature in action and will show you how to generate a complete MVC application that includes authentication, registration and browsable pages for each table in your MySQL database without any code needed.
Replicating from MySQL to Amazon Redshift
+0 Vote Up -0Vote Down
Continuent is delighted to announce an exciting Continuent Tungsten feature addition for MySQL users: replication in real-time from MySQL into Amazon RedShift.   In this webinar we'll survey Continuent Tungsten capabilities for data warehouse loading, then zero in on practical details of setting up replication from MySQL into RedShift.  We'll cover: Introduction to real-time movement from
Refreshing imported MySQL data with MySQL for Excel
Employee +1 Vote Up -0Vote Down

Welcome to another blogpost from the MySQL for Excel Team. This time we're going to talk about a new feature included since MySQL for Excel 1.3.0, now we maintain the link between imported Excel tables and its data source. Now, with this new feature we'll show you how easy is to work with the latest available information at all times.

We would like to remind you, our latest GA or maintenance version can be installed using the MySQL Installer or optionally you can download directly any GA or non-GA version from the MySQL Developer



  [Read more...]
How To: Using SimpleMembserhipProvider with MySql Connector/Net.
Employee +1 Vote Up -0Vote Down
How to configure SimpleMembership with MySql is explained in this post, as well as how to use OAuth with external providers to access an application providing external credentials.
HowTo: Using the MySQL debugger inside the Visual Studio IDE
Employee +0 Vote Up -0Vote Down
One of the most used tools that we, developers look up for when finding bugs is: a good debugging tool. MySQL for Visual Studio offers a really good integration with all of the debugging tools that Visual Studio already delivers for the .NET framework code. A good interactive set of tools are available for debugging any application code. These same tools are ready to be used from a routine with MySQL code.
In this post we will be showing how to use the debugger of MySQL for Visual Studio plugin in a very simple routine, but it will be more than enough to show all the tools that exists within this MySQL Debugging tool.
MySQL for Visual Studio 1.2.3 GA has been released
Employee +0 Vote Up -0Vote Down

MySQL for Visual Studio is a product that includes all of the Visual Studio integration functionality to create and manage MySQL databases when developing .NET applications. The 1.2.3 version is a General Availability release of this product which is feature complete and is suitable for production environments.

Collation options for new MySQL schemas and tables created in MySQL for Excel
Employee +0 Vote Up -0Vote Down

In this blog post we are going to talk about one of the features included since MySQL for Excel 1.3.0, MySQL for Excel has always let you create new schemas and tables in a MySQL database, in versions lower than 1.3.0 these were created with the default character set and collation defined in the MySQL server. Starting with version 1.3.0 we introduced several features regarding collations:

  • New drop-downs were added that let you to override the default collation for new MySQL schemas and tables.
  • Default collations for each schema can be shownin the schemas list below the schema names.
  • The SQL queries for schemas creation can be previewed or displayed (depending on its global setting).

Remember you can install the latest

  [Read more...]
How To Use the MySQL Windows Forms Wizard
Employee +1 Vote Up -0Vote Down

MySQL for Visual Studio 1.2 introduces several new features:

  • Web Configuration support for MySQL Personalization Provider.
  • Web Configuration support for MySQL SiteMap Provider.
  • Web Configuration support for MySQL Simple Membership Provider.
  • MySQL ASP.NET MVC Project Wizard.
  • MySQL Windows Forms Project Wizard.

In this post we are going to see the last one, The MySQL Windows Forms Project Wizard, in action.

MySQL Connector/Python on GitHub
Employee +1 Vote Up -0Vote Down

Last week we released Connector/Python v2.0 (alpha); today we publish the source on GitHub. Yes, we are using Git internally and are now able to push it out on each release. Previous versions are still available through LaunchPad.

Here is the full process to get Connector/Python installed in a virtual environment. You’ll need Git installed of course.

shell> git clone https://github.com/oracle/mysql-connector-python.git cpy
shell> virtualenv ENVCPY
shell> source ENVCPY/bin/activate
(ENVCPY)shell> cd cpy
(ENVCPY)shell> python setup.py install
(ENVCPY)shell> python
>>> import
  [Read more...]
Resetting advanced options to defaults in MySQL for Excel
Employee +1 Vote Up -0Vote Down

Welcome to another blog post from the MySQL for Excel Team. Today we're going to talk about a new feature included since 1.3.0, remember you can always install the latest GA or maintenance version using the MySQL Installer also you can download directly any GA or non-GA version from the MySQL Developer Zone.

In this post we will learn how to reset several advanced options to their default values.



Remember that your feedback is very important for us, please drop us a message with your comments, suggestions for this or other



  [Read more...]
HowTo: Using MySQL for Visual Studio in you first ASP.NET MVC Application with EF 6
Employee +0 Vote Up -0Vote Down
Last week it was released the RC version of MySQL for Visual Studio 1.2.2. In this blog post we'll be showing one of the new features in this release. And we will be doing a short demo about some of the first steps when starting to use MySQL with .NET applications.
MySQL Connector/Python v2.0.0 alpha
Employee +2 Vote Up -0Vote Down

A new major version of Connector/Python is available: v2.0.0 alpha has been been released and is available for download! As with any alpha-software, it’s probably not good to throw it in production just yet.

Our manual has the full change log but here’s an overview of most important changes for this relase.

Some incompatibilities

The world evolves, at least the software does, and Python is not different. I’m not as bold as the guys at Django who dropped support of Python v2.6 with the Django v1.7 release. I’m leaving it in because I’m nice.

  [Read more...]
Showing all available MySQL data types when creating a new table with MySQL for Excel
Employee +1 Vote Up -0Vote Down

In this blog post we are going to talk about one of the features included since MySQL for Excel 1.3.0, a new advanced option was added to the Export Data dialog to show all available MySQL data types on its Data Type combo-box to override its default behavior that shows only the most commonly used data types.

Remember you can install the latest GA or maintenance version using the MySQL Installer or optionally you can download directly any GA or non-GA version from the MySQL Developer Zone.

MySQL Connector/NET 6.9.2 RC has been released
Employee +1 Vote Up -0Vote Down

Dear MySQL users,

MySQL Connector/Net 6.9.2 a new version of the all-managed .NET driver for MySQL has been released. This is a RC release for 6.9.x and is not recommended for production environments.

It is appropriate for use with MySQL server versions 5.5-5.7.

It is now available in source and binary form fromhttp://dev.mysql.com/downloads/connector/net/#downloadsandmirrorsites

(note that not all mirror sites may be up to date at this point-if you can't find this version on some mirror, please try again later or choose another download site.)

Enjoy and thanks for the support!

On behalf of the MySQL Connector/NET and the MySQL/ORACLE RE Team.

MySQL for Visual Studio 1.2.2 RC has been released
Employee +2 Vote Up -0Vote Down
Dear MySQL users,
MySQL for Visual Studio is a product including all of the Visual Studio integration. The 1.2.2 version is a release candidate release of this product which is feature complete but still can contain minor bugs and is not suitable for production environments.
This version is appropriate for use with MySQL server versions 5.5-5.6.
Making Real-Time Analytics a Reality — TDWI -The Data Warehousing Institute
+0 Vote Up -0Vote Down

My article on how to make the real-time processing of information from traditional transactional stores into Hadoop a reality has been published over at TDWI:

Making Real-Time Analytics a Reality — TDWI -The Data Warehousing Institute.


Adding summary fields when importing MySQL data with MySQL for Excel
Employee +0 Vote Up -0Vote Down

Welcome to another blog post from the MySQL for Excel Team. Today we're going to talk about a new feature included since 1.3.0, remember you can always install the latest GA or maintenance version using the MySQL Installer also you can download directly any GA or non-GA version from the MySQL Developer Zone.

In this post we will learn how to add summary fields to our data imports to excel easily.



Remember that your feedback is very important for us, please drop us a message with your comments, suggestions for this or other features and



  [Read more...]
HowTo: Integrating MySQL for Visual Studio with Connector/Net
Employee +0 Vote Up -0Vote Down

One of the most frequent questions in our forums is about how to get the graphical integration when using Visual Studio with MySQL databases.

When developing applications with MySQL databases there are two basics products: a .net driver for MySQL, which is MySQL Connector/Net, and a tool to integrate all of the Visual Studio database oriented tools such as the Server Explorer window. These tools are designed to make a lot easier the creation and edition of MySQL databases when using an IDE like Visual Studio.

MySQL for Visual Studio 1.2.1 beta has been released
Employee +0 Vote Up -0Vote Down
MySQL for Visual Studio is a product including all of the Visual Studio integration previously available as part of Connector/Net. The 1.2.1 version is a beta release of this product which is feature complete but still can contain minor bugs and is not suitable for production environments.
MySQL for Excel 1.3.1 RC has been released
Employee +0 Vote Up -0Vote Down

The MySQL Windows Experience Team is proud to announce the release of MySQL for Excel version 1.3.1.  This is a RC release for 1.3.x.

As this is a Release Candidate version the MySQL for Excel product can be downloaded only by using the product standalone installer at this link: http://dev.mysql.com/downloads/windows/excel/

Your feedback on this release candidate version is very well appreciated, you can raise bugs on the MySQL bugs page or give us your comments on the MySQL for Excel forum.

Streaming backups onto the Cloud Storage
Employee +0 Vote Up -0Vote Down


MySQL Enterprise Backup(MEB) has been widely used as the most efficient tool to take backups of huge databases. The storage of backups can be done on-premises – viz, local hard disk, external hard disk drives, network mounted disk. MEB can also stream backups to tape by supporting different Media Management Software like Symantec NetBackup, EMC2 and Oracle Secure Backup. Streaming of backups can also be done using 'ssh' to another machine.

As data keeps growing, instead of expanding the storage, database users are choosing to rely on the growing trend which is the Cloud Storage.

A few facts about Cloud Storage:

1. Offers off-premises storage with AAA(Anytime, Anywhere Access)
2. Sharing of data to make a collaborative effort.
3. Highly fault tolerant, durable and scalable and secure.
4. Cost-effective









  [Read more...]
Optimistic updates for Edit Data operations in MySQL for Excel
Employee +0 Vote Up -0Vote Down

In this blog post regarding MySQL for Excel features included since version 1.2.0, we are going to talk about a new option that is used along with Edit MySQLData operations; very useful when editing data in a multi-user environment. If you are not familiar with editing MySQL data it is very advisable that you visit our thorough blog post about that topic: How To - Guide to editing MySQL data within Excel.

Remember you can install the latest GA or maintenance version using the MySQL Installer or optionally you can download directly any GA or non-GA version from the MySQL Developer Zone.  

SQL queries preview before sent to server in MySQL for Excel
Employee +3 Vote Up -0Vote Down

In this blog post we are going to cover a pretty useful piece of functionality introduced since MySQL for Excel 1.2.0.

There could be times when users may want to see exactly what SQL queries are being generated either before they are sent to the server, so corrections can be made if the query does not look as intended, or after they are sent to the server to obtain additional information or for debugging purposes.

Starting with MySQL for Excel 1.2.0, new global options were added to modify the behavior of the moment when SQL queries that affect a MySQL database are shown to the users. The Global Options dialog can be accessed from the Options button located in the Schema Selection panel or the DB Objects Selection one as shown below.

Remember you can install the latest GA or

  [Read more...]
Replicating Oracle Webinar Question Follow-up
+0 Vote Up -0Vote Down

We had really great webinar on Replicating to/from Oracle earliest this month, and you can view the recording of that Webinar here.

A good sign of how great a Webinar was is the questions that come afterwards, and we didn’t get through them all. so here are all the questions and answers for the entire webinar.

Q: What is the overhead of Replicator on source database with asynchronous CDC?

A: With asynchronous operation there is no substantial CPU overhead (as with synchronous), but the amount of generated redo logs becomes bigger requiring more disk space and better log management to ensure that the space is used effectively.

Q: Do you support migration from Solaris/Oracle to Linux/Oracle?

A: The replication is

  [Read more...]
MySQL Connector/Python v1.2.2 GA supporting MySQL Fabric
Employee +2 Vote Up -0Vote Down

A few weeks ago MySQL Fabric got GA and shipped together with MySQL Utilities 1.4. Today, 2 weeks late, a tooth less and having fixed my website(s), I can blog about MySQL Connector/Python v1.2 going GA.

My previous post about the release candidate already summed up the important changes, and nothing changed since then except few bug fixes. Here are again the important new features/bugs fixed for Connector/Python v1.2:

  • Added support for MySQL Fabric.
  • Support for MySQL’s Authentication Plugins: mysql_clear_password and sha256_password are now supported over an SSL connection.
  • Failing over connections (note: not
  [Read more...]
MySQL for Excel 1.3.0 Beta has been released
Employee +2 Vote Up -0Vote Down

The MySQL Windows Experience Team is proud to announce the release of MySQL for Excel version 1.3.0.  This is a beta release for 1.3.x.

As this is a beta version the MySQL for Excel product can be downloaded only by using the product standalone installer at this link: http://dev.mysql.com/downloads/windows/excel/

Your feedback on this beta version is very well appreciated, you can raise bugs on the MySQL bugs page or give us your comments on the MySQL for Excel forum.

theCube @ Hadoop Summit 2014 - Robert Hodges (Continuent) with John Furrier and Jeff Kelly on on real-time data loading from Oracle and MySQL into Hadoop.
+0 Vote Up -0Vote Down
The Hadoop Summit, a leading Apache Hadoop industry conference, has grown significantly over the years, and throughout the day, theCUBE, led by hosts John Furrier and Jeff Kelly, featured the best of thought leaders, use cases, data scientists, data analysts, and developers at the event. Watch yesterday's interview with Robert Hodges (CEO, Continuent) on real-time data loading from Oracle and
Excel tables creation upon importing MySQL data in MySQL for Excel
Employee +0 Vote Up -0Vote Down

In this blog post we are going to talk about one of the features included since MySQL for Excel 1.2.0, we introduced some advanced options for the Import MySQL Data operation regarding Excel tables. You can install the latest GA or maintenance version using the MySQL Installer or optionally you can download directly any GA or non-GA version from the MySQL Developer Zone.

MySQL Connector/NET 6.9.1 beta has been release
Employee +0 Vote Up -0Vote Down
Dear MySQL users,
MySQL Connector/Net 6.9.1 a new version of the all-managed .NET driver for MySQL has been released. This is a beta release for 6.9.x and is not recommended for production environments.
It is appropriate for use with MySQL server versions 5.5-5.7.
It is now available in source and binary form from http://dev.mysql.com/downloads/connector/net/#downloadsandmirrorsites (note that not all mirror sites may be up to date at this point-if you can't find this version on some mirror, please try again later or choose another download site.)
Enjoy and thanks for the support!
On behalf of the MySQL Connector/NET and the MySQL/ORACLE RE Team. 
Building MySQL with boost on windows
Employee +0 Vote Up -0Vote Down

As you've probably heard already MySQL needs boost to build.

However, in the good ol' MySQL tradition, the above link does give you only the instructions on how to build it on linux. And completely ignores the fact that there're other OSes too that people develop on.

To fill in that gap, I've compiled a small step by step guide on how to do it on windows. Note that I always, as a principle, build out-of-source.

The typical setup I have is :

bzr clone lp:~mysql/mysql-server/5.7 mysql-trunk
cd mysql-trunk
mkdir bld
cd bld
cmake -DWITH_DEBUG=1 -DMYSQL_PROJECT_NAME=mysql-trunk ..
devenv /build debug mysql-trunk.sln

This has been tested to work on a 32 bit compile using VS2013 on a Windows7 64







  [Read more...]
Showing entries 1 to 30 of 1389 Next 30 Older Entries

Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.