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 中文
Previous 30 Newer Entries Showing entries 61 to 90 of 1389 Next 30 Older Entries

Displaying posts with tag: Oracle (reset)

How To - Guide to editing MySQL data within Excel
Employee +0 Vote Up -0Vote Down

In previous posts we have talked about importing data from MySQL to Excel, exporting data from Excel to a new or to a existing MySQL table (via the Export Data or Append Data operations) which are common tasks to be performed against MySQL tables. In this post we will talk about possibly the coolest feature in MySQL for Excel which is the Edit Data operation which allows the retrieval of a MySQL table's data to an Excel worksheet so the data can be edited, deleted or inserted in new rows and those changes saved back to the MySQL database in a friendly and intuitive way, and more importantly, without the need of writing SQL queries making it accessible to any kind of user.

You will learn in this guide how to do it and all the details about the Edit Data feature in MySQL for Excel.

9 Reasons For Attending The Percona Live MySQL Conference & Expo 2014
+0 Vote Up -0Vote Down
March 28, 2014 By Severalnines

 

Percona Live MySQL Conference & Expo - March 31st to April 4th

The Severalnines Team Will Be Onsite at Booth 418 - Come Say Hello!

 

 

If you’re still thinking about whether or not you should be attending the Percona Live MySQL Conference & Expo that starts on Monday 31st of March, here are 9 reasons (we are Severalnines after all) on why we’ll be there. May these help you positively in

  [Read more...]
Faster and Space efficient Restore with MySQL Enterprise Backup
Employee +1 Vote Up -0Vote Down

A typical backup cycle with MySQL Enterprise Backup had always involved 3 steps:

1. backup (to directory)

2. apply-log (prepare the backup)

3. copy-back (restore)

In case of directory, the 'apply-log' is done on the backup directory which does not involve any additional space.

But in case of image, the image has to be extracted, before doing 'apply-log'. This involves additional space for extraction of image and the steps involved are:

1. backup-to-image

2. Extract

3. apply-log

4. copy-back

How about, combining the 3 steps – extract, apply-log and copy-back, so that the image is extracted directly on the target directory (which is the datadir of a server instance) and then apply-log is performed on the extracted contents. This way, the need for additional space

  [Read more...]
MySQL for Excel 1.2.1 has been released
Employee +1 Vote Up -0Vote Down

The MySQL Windows Experience Team is proud to announce the release of MySQL for Excel version 1.2.1.

MySQL for Excel 1.2.1 is a maintenance release for 1.2.x containing a handful of bug fixes and the following minor features:

  • When MySQL Workbench is not installed, MySQL connections are now automatically created for discovered MySQL services. If MySQL Workbench is later installed, these connections are not migrated over to MySQL Workbench as MySQL Workbench also creates connections for discovered MySQL services.

You can download MySQL for Excel 1.2.1 from our official Downloads page at http://dev.mysql.com/downloads/windows/excel as a standalone MSI, and it will be available shortly in the MySQL Installer for Windows that can

  [Read more...]
I'm speaking about MySQL tools on BGOUG's spring conference
Employee +0 Vote Up -0Vote Down

I will be speaking about MySQL at the Bulgarian Oracle Users Group's Spring Conference.

In furthering my mission to increase the MySQL knowledge among my countrymen I will try to give the grand tour of all the modern MySQL administrative and development tools that the MySQL team provides.

This will be the 3d BGOUG conference I'm speaking to. And I expect no less than the stellar organization and the great audience that I had the privilege to interact with during the previous 2 conferences.

We had a lot of fun too ! Parties from the last 2 conferences are

  [Read more...]
How To - Guide to appending data from Excel to an existing MySQL table
Employee +0 Vote Up -0Vote Down

Today we're going to talk about one of the main features in MySQL for Excel. There may be times when you have a MySQL Database table that you want to add new rows to. In this blog post we're going to show you how you can do that from within Excel directly easily using the Append Excel Data to Table feature.

Always remember MySQL for Excel can be downloaded and installed directly for free, from our MySQL Installer downloads (http://www.mysql.com/downloads/installer/) page.

Your feedback is very important for us, please drop us a message and follow our social networks: Cheers!
We're hiring!
+1 Vote Up -0Vote Down
Continuent, a leading provider of database clustering and replication software has five (5) new positions open: Build/Test Engineer Senior Database Availability and Clustering Engineer Senior Database Replication Engineer Data Replication Sales Engineer Clustering and Replication Test Development Engineer If you want to get in on the ground floor of a growing company in a challenging field
MySQL NL Meetup March 18
+0 Vote Up -0Vote Down
The next MySQL User Group NL meetup is this Tuesday at the Oracle office in Utrecht.

For more info go to the Event page @ Meetup.com
HowTo: MySQL new toolbar inside the Visual Studio IDE
Employee +2 Vote Up -1Vote Down
MySQL for Visual Studio 1.1.4 was released including a new feature: MySQL Toolbar inside the Visual Studio environment. This post will cover the details on this new feature.
MySQL for Visual Studio 1.1.4 is available for download
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. Today we're releasing the 1.1.4 Maintenance Release of this product. It is a version suitable for production environments, compatible with Connector/Net 6.8.3 or further versions and supports MySQL server versions 5.0 to 5.6.
MySQL Enterprise Backup 3.10.0-What's New
Employee +0 Vote Up -0Vote Down

MySQL Enterprise Backup team is proud to announce the new release of MySQL Enterprise Backup (MEB) 3.10.0.

Security of backups and usability of backup tools form an important factor in taking successful backups. DBAs prefer to have tools that would help them in backup and restore without much overhead and also to help keep their backups protected. So in this release of MEB we have enhanced usability and added provision to take secured backups. In addition to this we have also provided enhancements to compressed backup.

Product New Features

MEB 3.10.0 is a major release with the following valuable features.

Feature

Benefit

  [Read more...]
MySQL Enterprise Backup 3.10.0 – What’s New
Employee_Team +0 Vote Up -0Vote Down

MySQL Enterprise Backup team is proud to announce the new release of MySQL Enterprise Backup (MEB) 3.10.0.

Security of backups and usability of backup tools form an important factor in taking successful backups. DBAs prefer to have tools that would help them in backup and restore without much overhead and also to help keep their backups protected. So in this release of MEB we have enhanced usability and added provision to take secured backups. In addition to this we have also provided enhancements to compressed backup.

Product New Features

MEB 3.10.0 is a major release with the following valuable features.

Feature

Benefit

Improved Compressed Backup

  [Read more...]
How To - Guide to exporting data from Excel to a new MySQL table
Employee +0 Vote Up -0Vote Down

There may be times when you need to create a new table in MySQL and feed it with data from another database, the Internet or from combined data sources. MS Excel is commonly used as the bridge between those data sources and a target MySQL database because of the simplicity it offers to organize the information to then just dump it into a new MySQL table. Although the last bit sounds trivial, it may actually be a cumbersome step, creating ODBC connections within Excel through Microsoft Query may not help since these are normally created to extract data from MySQL into Excel, not the opposite. What if you could do this in a few clicks from within Excel after making your data ready for export to a MySQL database?

With MySQL for Excel you can do this and this guide will teach you how easy it is.

MySQL for Excel Main Features Video
Employee +2 Vote Up -0Vote Down

We are proud to announce our first MySQL for Excel video is now available at the MySQL youtube channel.

Please give it an eye and get to know about the main features of MySQL for Excel (Import, Export, Append and Edit).

To view the video on youtube click over the image shown in below:


We always look forward to hear what new features you will like to see on future versions of MySQL for Excel so we encourage you to please visit our forum and let us know. Also, follow us at:

  • Facebook -

  [Read more...]
Connector/NET 6.8.3 is available as official MySQL Nuget packages
Employee +2 Vote Up -0Vote Down

Dear MySQL users,

We are proud to announce that we have made the open source version of our Connector/NET 6.8.3 is available as official MySQL Nuget packages.

Currently we have 3 nuget packages which contain:

  • MySQL Connector/NET Core
  • MySQL Connector/NET for Entity Framework 6
  • MySQL Connector/NET Web providers

Oracle’s Mats Kindahl to weave MySQL Fabric into Percona Live session
+2 Vote Up -0Vote Down

Mats Kindahl of Oracle is lead developer of MySQL Fabric

MySQL Fabric is an integrated framework for managing farms of MySQL servers with support for both high-availability and sharding. Its development has been spearheaded by Mats Kindahl, senior principal software developer in MySQL at Oracle.

Mats is leading the MySQL Scaling and High-Availability effort covering the newly released MySQL Fabric and the MySQL Applier for Hadoop. He is also the architect and implementer of several features (mostly replication features), including the row-based replication available in 5.1 and the binary log group commit available in MySQL 5.6. Before starting MySQL he earned a doctoral degree in the area of automated

  [Read more...]
Add User Defined Types
+0 Vote Up -0Vote Down

Somebody asked me if there was a cheaper alternative to using the Embarcadero Data Architect (a data modeling tool). I said sure, you can use the MySQL Workbench. My friend laughed and said, it’s to model Oracle databases and they use different data types. I broke the news to him that he can create his own user defined types and use MySQL Workbench to model problems for the Oracle Database 11g.

For example, you can launch the MySQL Workbench, and click on the Model menu option, and in the menu window click on the User Defined Types choice, as shown in the following:

Choosing the User Defined Type option, launches the following

  [Read more...]
MySQL Connector/Python v1.1.6 GA
Employee +0 Vote Up -0Vote Down

This week we released MySQL (http://www.mysql.com" target="_blank) Connector/Python v1.1.6 has been released with a fix for the Django backend. If you  wonder (or not?) where Connector/Python v1.1.5, it got released a few weeks ago. Yes, PyPi has been updated! Don’t forget to use –allow-external using newest pip.

Some useful links:

  [Read more...]
Oracle’s Morgan Tocker opens up about MySQL development, MySQL 5.7
+4 Vote Up -0Vote Down

Today’s post features an interview with Morgan Tocker, MySQL community manager at Oracle. Morgan is an old friend of Percona, having worked here as director of MySQL training from 2009 to 2011. He’s also done stints at MySQL, Sun Microsystems and InPowered. You can follow his adventures at his blog, “Master MySQL.”  You can also connect with him face-to-face at the Percona Live MySQL Conference and Expo this April 1-4 in Santa Clara, Calif.  Use the promotional code “SeeMeSpeak” on the

  [Read more...]
Why Aren't All Data Immutable?
+0 Vote Up -0Vote Down
Over the last few years there has been an increasing interest in immutable data management. This is a big change from the traditional update-in-place approach many database systems use today, where new values delete old values, which are then lost. With immutable data you record everything, generally using methods that append data from successive transactions rather than replacing them.  In some DBMS types you can access the older values, while in others the system transparently uses the old values to solve useful problems like implementing eventual consistency.

Baron Schwartz recently pointed out that it can be hard to get decent transaction processing performance based on append-only methods like append-only B-trees.  This is not a very strong argument

  [Read more...]
Hot Off The Press: MySQL February Newsletter
Employee_Team +6 Vote Up -1Vote Down

The MySQL February Newsletter is available! Find out the latest news on MySQL products and MySQL Connect 2014, and read the technical tips written by MySQL experts at Oracle and in the community. Below are the highlights in this edition:

  • Start Preparing for MySQL Connect 2014 Call for Papers
  • New GA Release: MySQL for Visual Studio
  • Blog: State of the UNION
  • Blog: New MySQL Web Installer -- Have You Tried It Yet?
  • Blog: MySQL Workbench: Frequent Crashes on Mac OS X? This Might Be The Fix
  • Event: MySQL Seminars Are Coming to a City Near You

You can read it online or

  [Read more...]
HowTo Video: Exporting your database using MySQL for Visual Studio
Employee +2 Vote Up -0Vote Down
MySQL for Visual Studio 1.1.3 introduced a new feature: MySQL Data Export tool. This tool allows the users to create a dump of an existing MySQL database. This video shows a quick tutorial on how to use this tool for creating MySQL exporting script inside Visual Studio.
Mac Mini to the rescue
+0 Vote Up -0Vote Down

In teaching, I had a problem because my students have different base operating systems, like Windows 7, Windows 8, Linux, and Mac OS X. I needed a teaching and lecture platform that would let me teach it all (not to mention support their environments). That meant it had to virtualize any of the following with a portable device:

  • Windows 7 or 8 hosting natively an Oracle Database 11g XE, 11g, or 12c and MySQL Database 5.6
  • Windows 7 or 8 hosting a Fedora or Oracle Unbreakable Linux VM (3 or 4 GB) with Oracle Database 11g XE, 11g, or 12c and MySQL Database 5.6
  • Mac OS X hosting a Fedora or Oracle Unbreakable Linux VM (3 or 4 GB) with Oracle Database 11g XE,
  [Read more...]
Guide to create a tunneled SSH connection in MySQL for Excel
Employee +1 Vote Up -0Vote Down

This is the second part of two series of blog posts to setup a SSH connection on Windows from scratch. The first part can be found here.
This article describes in step by step fashion a guide on how to create and configure a SSH Tunnel with port forwarding to a remote MySQL server running FreeSSHd on Windows using Putty locally.

MySQL for Excel 1.2.0 has been released
Employee +1 Vote Up -1Vote Down

The MySQL Windows Experience Team is proud to announce the release of MySQL for Excel version 1.2.0, the  latest addition to the MySQL Installer for Windows.

MySQL for Excel is an application plug-in enabling data analysts to very easily access and manipulate MySQL data within Microsoft Excel. It enables you to directly work with a MySQL database from within Microsoft Excel so you can easily do tasks such as:

  • Importing MySQL Data into Excel
  • Exporting Excel data directly into MySQL to a new or existing table
  • Editing MySQL data directly within Excel

MySQL for Excel is installed using the MySQL Installer for Windows. You can download MySQL Installer from our official Downloads page at http://dev.mysql.com/downloads/installer/.

Replicate from Oracle to Oracle, Oracle to MySQL, and Oracle to Analytics
+0 Vote Up -0Vote Down
Oracle is the most powerful DBMS in the world. However, Oracle's expensive and complex replication makes it difficult to build highly available applications or move data in real-time to data warehouses and popular databases like MySQL. In this webinar-on-demand you will learn how Continuent Tungsten solves problems with Oracle replication at a fraction of the cost of other solutions and with less
Percona Live MySQL Conference and Expo 2014: Things I’m looking forward to
+2 Vote Up -0Vote Down

The Percona Live MySQL Conference and Expo 2014 is just two months away. I’m very excited about this year’s event which continues our tradition of open technical discussions and inviting all parties to the table.

We have a great amount of technical talks from Oracle – I’m especially excited about future-focused talks shedding some light about what to expect in MySQL 5.7 and beyond. This content is best covered by developers actually designing the system and writing the code. We also have great coverage of MySQL

  [Read more...]
MariaDB CONNECT Storage Engine as an ETL (or ELT) ?
+5 Vote Up -1Vote Down

The MariaDB CONNECT Storage Engine allows to access heterogeneous data sources. In my previous post I show you how to use the MariaDB CONNECT Storage Engine to access an Oracle database. This is quite easy through the CONNECT Storage Engine ODBC table type.

For most architectures where heterogeneous databases are involved an ETL (Extract-Transform-Load) is [...]

Guide to install and configure SSH in a MySQL server on Windows
Employee +3 Vote Up -0Vote Down

This article describes in step by step fashion a guide on how to install and configure a SSH server in a MySQL server running on Windows using FreeSSHd. 

MySQL is a Great Fit for Cloud-Based Deployments
Employee_Team +1 Vote Up -0Vote Down

MySQL's architecture and features make the database a great fit for cloud based deployments. If you are interested in using MySQL to deliver web-based applications and scale out, read the white paper MySQL, An Ideal Choice in the Cloud (http://www.mysql.com/why-mysql/white-papers/mysql-an-ideal-choice-for-the-cloud/).

As a first step to using the MySQL database, take the MySQL for Beginners course. In this 4-day course, you learn to use the MySQL Server and tools while developing a knowledge of relational databases. You can take this course through the following delivery methods:

  • Training-on-Demand: Start training within 24 hours of registering and train at your own pace.
  • Live-Virtual Event:
  [Read more...]
Previous 30 Newer Entries Showing entries 61 to 90 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.