TODAY'S  MOST  POPULAR  HEADLINES

PNG Image

MySQL


How To Back Up MySQL Databases Without Interrupting MySQL

05/14/2007  IIIIII
Relevance: 8.25
This article describes how you can back up MySQL databases without interrupting the MySQL service. Normally, when you want to create a MySQL backup, you either have to stop MySQL or issue a read lock on your MySQL tables in order to get a correct backup; if you do not do it this way, you can end up with an inconsistent backup. To get consistent backups without interrupting MySQL, I use a little trick: I replicate my MySQL database to a second MySQL server, and on the second MySQL server I use a cron job that creates regular backups of the replicated database.
Search further arrow


MySQL 5.1 goes GA, Monty not happy

12/02/2008  IIIIII
Relevance: 8.07
MySQL 5.1 is now out, but not everyone is happy about this oft-delayed open source database release. I've been hearing about MySQL 5.1 since at least 2006 and over the last two years there have been a few dates I've been told when it would be released."One would have thought that MySQL AB (now the MySQL department at Sun) should have learned something from our too early release of MySQL 5.0 but unfortunately this is not the case," Widenius stated.
Search further arrow


A graphical way to MySQL mastery

11/22/2008  I
Relevance: 7.95
MySQL GUI Tools is a suite of graphical desktop applications for working with and administering MySQL servers. The suite consists of three tools: MySQL Query Browser, MySQL Administrator, and MySQL Migration Assistant (available only on Windows). We'll look at the first two to see how well they let us manage MySQL without using the command line. You can install MySQL GUI Tools via the package management systems on Ubuntu, Debian, or Fedora Linux. On Ubuntu and Debian the package name is mysql-admin; on Fedora, it's mysql-gui-tools. Pre-built binaries and the source code are all available on the project's site.
Search further arrow


MySQL Enterprise simplifying database admin

10/19/2006  IIIIII
Relevance: 7.77
MySQL AB have announced MySQL, a new version of their commercial automated databasing subscription service. with new automated proactive technology to help corporate users monitor and tune their production MySQL database systems, it intends to make administering a MySQL database as easy and affordable as it is to develop MySQL databases.
Search further arrow


Tunneling MySQL connections through SSH

01/03/2007  II
Relevance: 7.07
This is a description of how to set up a secure tunnel between your MySQL Server and a locally running MySQL Administrator using Putty. By creating a secure tunnel to your MySQL server using Putty, you can grant localhost access to powerful applications like MySQL Administrator while at the same time, make your server appear as if it isn't even there. In effect, make your MySQL server disappear from the outside world.
Search further arrow


Sun Microsystems To Acquire MySQL AB

05/28/2008  I
Relevance: 7.07
If you were hoping to get in on the expected initial public offering (IPO) of MySQL AB, nice try but you're now out of luck. Sun Microsystems has today announced that they will be acquiring MySQL AB, the company behind the open-source MySQL database software...
Search further arrow


Visual MySQL Database Design in MySQL Workbench

06/13/2008  I
Relevance: 7.04
MySQL Workbench is a visual database design tool recently released by MySQL AB. The tool is specifically for designing MySQL database. MySQL Workbench has many functions and features; this article by Djoni Darmawikarta shows some of them by way of an example. We'll build a physical data model for an order system where an order can be a sale order or a purchase order, and then, forward-engineer our model into an MySQL database.
Search further arrow


Solid: Boosting MySQL for Mission-Critical Users

02/13/2007  II
Relevance: 7.03
MySQL is poised to attract keen attention from F1000s running mission-critical apps. A meaner, faster version of MySQL, dubbed solidDB for MySQL, is now in general availability (GA). Co-built by MySQL AB and Solid Information Technology, it cuts response times, boosts scalability, and processed 2x more transactions than Oracle InnoDB, say benchmarks.
Search further arrow


Use MySQL GUI tools remotely and securely

02/01/2007  IIIII
Relevance: 6.88
MySQL is a database that is synonymous with ease-of-use, and most database-driven Web applications use it as their database of choice. Because of this, MySQL is used on many Web servers. While the MySQL command line tool is useful, unless you know all the ins and outs of SQL syntax, it can be time-consuming to get things done. It is for this reason that tools like phpMyAdmin have become so popular.
Search further arrow


MySQL Backup And Recovery With mysql-zrm On Debian Sarge

09/28/2006  IIIII
Relevance: 6.87
This guide describes how to back up and recover your MySQL databases with mysql-zrm on a Debian Sarge system. mysql-zrm is short for Zmanda Recovery Manager for MySQL, it is a new tool that lets you create full logical or raw backups of your databases (regardless of your storage engine and MySQL configuration), generate reports about the backups, verify the integrity of the backups, and recover your databases. It can also send email notifcations about the backup status, and you can implement multiple backup policies (based on your applications and based on time (e.g. daily, weekly, etc.)).
Search further arrow



Showing 10 articles of total 22541 in database (Flag English).