By: mendesdomnic

July 30, 2009 3:05 pm

23,891 views

Check MySQL Database Size Using SQL Query

Don't have access to the command prompt? Here's how you can find the database size in MySQL. Become a power MySQL user without access to the power of command line. Execute the following SQL Queries as per your need: Get Size of all database tables SELECT TABLE_SCHEMA AS 'Database', TABLE_NAME AS 'Table', CONCAT(ROUND(((DATA_LENGTH + INDEX_LENGTH […]

Read More



By: noneal

July 9, 2009 1:14 pm

3,119 views

Moving a MySQL Database to a new VM or Physical SUSE Linux Enterprise Server

Scenario: We moved from VMware ESX to Citrix XenServer 5.5....We had to get our GroupLink everything HelpDesk to a new VM.....Instead of a V2V process we quickly spun up a new SLES10 Server (15 seconds) and copied the MySQL Database over to the new server: SSH to Exsiting MySQL Server .. and type: […]

Read More



By: mendesdomnic

April 29, 2009 3:23 am

1,488 views

MySQL Tips

Search fields containing string of given length Let's say you have a products table with following structure: Table Name: Product Field Type id int(11) product_code varchar(100) brand_id int(11) price decimal(10,4) tax_type_id int(11) quantity int(11) weight decimal(10,3) cube decimal(10,3) has_options tinyint(4) is_active tinyint(4) is_featured tinyint(4) is_deleted tinyint(4) created_at datetime updated_at datetime Now you […]

Read More



By: DamianMyerscough

June 19, 2008 5:33 pm

4,215 views

MySQL Replication

MySQL Replication In this article we will look at how to configure MySQL replication. I will assume you have already installed the MySQL package from the SUSE Linux Enterprise DVD/CD. The topics that we will cover in this article are creating a database that will be replicated by a slave server, configuring a master server, […]

Read More



By: lxzndr

December 28, 2007 10:59 am

1,625 views

Web Access For Any MySQL Table

Use MySQL, SLES 10, Apache, PHP to quickly create web pages for display, entry, and editing of any MySQL database without needing to know the DB field names or layout. After migrating a MS Access database some of our users use into MySQL and creating a web form for display, entry, and editing of the […]

Read More