Tag Archives: mysql

How to Backup and Restore MySQL Database’s Using MySQL Workbench

Written by SK on . Posted in CentOS, Fedora, Frequently Asked Questions, Hosting, linux command, Linux Mint, Linux tutorials, Linux webhosting, opensource, programming, Software, Suse, Ubuntu

MySQL(128x128)

MySQL Workbench is a graphical design tool for MySQL databases. It is used for database server administration, database design, creation, security management and server as well as database maintenance. Install MySQL Workbench on Ubuntu: sk@sk:~$ sudo apt-get install mysql-workbench Add … Continue reading

10 Easy Steps to Upgrade from MySQL to MariaDB on CentOS 6.4

Written by SK on . Posted in CentOS, Fedora, Frequently Asked Questions, Hosting, Linux distributions, Linux tutorials, Linux webhosting, Software, Suse, Ubuntu

ice_logo-5dcea9e47b780ff52f75c3c3304d54827f56211e

This article describes you how to upgrade MySQL to MariaDB in ten simple steps. We have already shown you How to Migrate from MySQL to MariaDB on FreeBSD. I assume that you already have installed MySQL latest version and it’s … Continue reading

Setup Master-Slave Replication in MySQL Server

Written by SK on . Posted in CentOS, Fedora, Frequently Asked Questions, Hosting, linux command, Linux distributions, Linux tutorials, Linux webhosting, Security, Software, Suse, Ubuntu

images

MySQL replication allows you to have multiple copies of data on many systems and data is automatically copied from one database (Master) to another database (Slave). If one server goes down, the clients still can access the data from another … Continue reading

Migrate from MySQL to MariaDB in FreeBSD

Written by Mel Kham on . Posted in Hosting, opensource, Software, Unix Tutorials

freebsd_300x300

The usage of MySQL for development is free. As you are not giving away that product (MySQL), no GPL restrictions apply. If you want to distribute MySQL in some form, the licenses apply. See: MySQL commercial license MariaDB is a community-developed fork of the MySQL relational … Continue reading

Install Easy Hosting Control Panel (EHCP) in Ubuntu 12.10 Server / Debian 6

Written by SK on . Posted in Hosting, Linux distributions, Linux Mint, Linux tutorials, Linux webhosting, opensource, Software, Ubuntu

ehcp_logo2

EHCP is an open-source and powerful hosting control panel that lets you to host any websites, create email accounts, create additional (sub) domains and create FTP accounts and many more. It is only the first hosting control panel that provide the … Continue reading

Easy Steps to Setup LAMP in Slackware 14.0

Written by Mel Kham on . Posted in Hosting, Linux distributions, Linux tutorials

93_Lamp

LAMP is a combination of free, open source software. The acronym LAMP refers to the first letters of Linux (operating system), Apache HTTP Server, MySQL (database software), and PHP, Perl or Python, principal components to build a viable general purpose web server.[1]

ArchLinux Decided to Move to MariaDB

Written by Mel Kham on . Posted in Linux distributions

MariaDB-seal

What’s  MariaDB : is an community-developed fork of the MySQL relational database management system, the impetus being the community maintenance of its free status under the GNU GPL, as opposed to any uncertainty of MySQL license status under its current ownership by Oracle. The contributors are required … Continue reading

Hosting on Linux is the best choice

Written by M. Zinoune on . Posted in News

Linux Web Hosting allows a company to build its web sites by using the Linux Operating System. Unix hosting and Linux hosting are generally the most cost-effective web hosting options. Unix/Linux are open source products and virtually free, and Unix … Continue reading

How to Backup and Restore MySQL Database on Fedora16, Centos and Redhat

Written by Mel Kham on . Posted in CentOS, Fedora, Linux tutorials

The mysqldump client is a backup program originally written by Igor Romanenko. It can be used to dump a database or a collection of databases for backup or transfer to another SQL server (not necessarily a MySQL server). The dump … Continue reading

multiple MySQL instance on Fedora/CentOS/Redhat/Scientific Linux

Written by Mel Kham on . Posted in Linux tutorials

Question:  How  to make  a  second  mysql server  running  on the same machine with another port and other directory ?