MySQL Archives - SUSE Communities

November 15, 2019 3:11 pm

2,177 views

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, […]

Categories: SUSE Manager

By: mendesdomnic

July 30, 2009 3:05 pm

24,176 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 […]

Tags: MySQL, Web Development

Categories: SUSE Linux Enterprise Server, Technical Solutions

By: noneal

July 9, 2009 1:14 pm

3,240 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: […]

Tags: MySQL, Virtual machines

Categories: SUSE Linux Enterprise Server, Technical Solutions, Virtualization

By: mendesdomnic

April 29, 2009 3:23 am

1,583 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 […]

Categories: SUSE Linux Enterprise Server, Technical Solutions

By: DamianMyerscough

June 19, 2008 5:33 pm

4,544 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, […]

Tags: MySQL

Categories: SUSE Linux Enterprise Server, Technical Solutions

By: lxzndr

December 28, 2007 10:59 am

1,747 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 […]

Tags: Apache, MySQL

Categories: SUSE Linux Enterprise Server, Technical Solutions