itSpice
Subscribe:       RSS    Twitter    EMail
 




Enter your email address:

Delivered by FeedBurner












MySQL

ARMS – Ajax Based Online Multiserver GUI For MySQL

ARMS is a TRUE web-based solution
The product harnesses the full power of MySQL in a web-based interface. At this moment in time, its closest rival, PHPMyAdmin while being a solid open-source solution that offers significant reliability and functionality does not even come close when compared side-by-side to Advanced Resource Management System (ARMS). When user experience, [...]


Missing Or Deleted FRM File May Cause Table Corruption in MySQL

By Naveen Kadian
MySQL Server database stores data dictionary information in the .frm files that it stores in database directories. On the other hand, InnoDB storage engine keeps information in individual data dictionary in tablespace files. When you move the .frm file or the server gets crashed in halfway of any data dictionary procedure, locations of [...]


Import Excel Data Into Mysql Using Phpmyadmin

Author: David Panfili
So you have a bunch of data in Excel that you want to create a database from. But how do you import the Excel data in MySQL? With phpMyAdmin, the process is painless and easy. This tutorial will explain this process step by step. The various options for database setup and character sets [...]


Using Php to Populate a Drop Down List Box From a Mysql Database Table

Author: John Dixon
Quite often when you are developing web sites or applications it is necessary to create a drop down list box that contains entries from a database table. You can, of course, hard code the items in the drop down list box, but this isn’t really very elegant, and can create problems if the [...]


Mysql Command Line Utility

Author: Mike Walton

MySQL is a very powerful open source database which means that it is free to use. One of the many tools that come with MySQL is their MySQL Command Line that will allow you to do pretty much everything from create a database to add and edit entries in the database. This article [...]


MySQL Monitoring Commands and Tips

The MySQL database is rapidly becoming the default choice for big enterprises and pioneering Web 2.0 companies. MySQL system store the all of the critical data and easy to maintenance in every cases. While the adoption rate of MySQL continues to grow in momentum, it poses some unique challenges for traditional DBAs in monitoring [...]


MySQL Vs Postgre SQL – A Comparison

By Puripong Koomsin
Postgre SQL vs MySQL is a loaded question indeed. Both are great applications and often the choice of which to use is purely a matter of personal preference. However they can be compared side by side to try to help users decide which might be the right choice for them.

Features: Here probably PostgreSQL [...]


How to rectify the Table Corruption in MySQL Database using Request Tracker

Table Corruption in MySQL Database by jpstellar
A Request Tracker (RT) enables you to keep a record of all the operations performed in MySQL database. RT creates a session by using a MySQL database, a PERL (Practical Extraction and Report Language) based main engine and front-end web and mail interfaces. However, if RT is unable to [...]


One MySQL Performance Tip You Must See

Author: John Murray
Is your dedicated or virtual dedicated server really living up to it’s true potential. This one MySQL change could help you squeeze more out of your server.
I run about twenty websites, formerly spread over two shared hosting accounts. Last month my hosts, both independently shut me down for over utilizing CPU. [...]


SSH tunneling in your application

by sftpsubmit
Introduction
This article is dedicated to the task of securing MySQL client-server connection using functionality provided by the Secure Shell (SSH) protocol. To be exact, the SSH tunneling concept is utilized. We will review the steps needed to build secure MySQL client applications and implement a sample one ourselves.
MySQL [...]



More Posts »