By: Jason Phippen

November 15, 2019 3:11 pm


Virtualization Management with SUSE Manager

SUSE® Manager 4 is a best-in-class open source infrastructure management solution that lowers costs, enhances availability and reduces complexity for life-cycle management of Linux systems in large, complex and dynamic IT landscapes. You can use SUSE Manager to configure, deploy and administer thousands of Linux systems running on hypervisors, as containers, on bare metal systems, […]

Read More

By: mendesdomnic

July 30, 2009 3:05 pm


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


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


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


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


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