SUSE Blog

Tag: MySQL


By: mendesdomnic

July 30, 2009 3:05 pm

23,970 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

Tags: ,

Categories: SUSE Linux Enterprise Server, Technical Solutions


By: noneal

July 9, 2009 1:14 pm

3,156 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

Tags: ,

Categories: SUSE Linux Enterprise Server, Technical Solutions, Virtualization


By: mendesdomnic

April 29, 2009 3:23 am

1,518 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

Tags: , ,

Categories: SUSE Linux Enterprise Server, Technical Solutions


By: DamianMyerscough

June 19, 2008 5:33 pm

4,315 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

Tags:

Categories: SUSE Linux Enterprise Server, Technical Solutions


By: lxzndr

December 28, 2007 10:59 am

1,664 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

Tags: ,

Categories: SUSE Linux Enterprise Server, Technical Solutions

    Section Title

    Search

    Social Media

    Recent Posts Title

    Recent Blog Posts

    Recent Posts

    Popular Posts Title

    Popular Blog Posts

    Popular Posts

    Categories

    Archives

    About Links

    SUSE History
    SUSE Management Team
    SUSE Logos & Imagery