How to Repair MySQL Databases with the Plesk (Onyx) Repair Utility

The Plesk repair utility allows users to easily check and repair their Mysql database servers by verifying the integrity of their databases and database users. In this guide we’ll cover the steps necessary to check and repair your databases using the repair utility.   Repairing MySQL Databases with Plesk To

How to install Mysql on Ubuntu 14.04 LTS server

Login to your Ubuntu server with root user with your favorite SSH client Let’s first update the operating system with all the latest packages with the command sudo apt-get update In order to install mysql use the command as below apt-get install mysql-server php5-mysql On the next screen , set

How to add MySQL Database in Plesk 12 on Windows server 2012

Login to Plesk control panel with your Plesk user Once logged in to Plesk, click on “Database” button under Custom Website box. On the next screen, click on “Add a new database” button.   On the next screen, under the General section add the database name to  the Database name

How to import/export mysql databases using phpmyadmin

Login to the cPanel of you website account Under database options open the phpMyAdmin application.   Select your new database from the list on the left hands sidebar. Once it opens select the Import tab from the navigation menu. In the File to Import section click the Choose File button

Create a MySQL Backup from Command Line – MySQL Import SQL File

When using MySQL, it’s important to keep backups of your databases to ensure you are able to restore them in the event of data loss. Downloading copies in the form of .sql files, can save you unnecessary stress and prevent future headaches. By using MySQL to import a SQL file,

How to Enable MySQL Port on Your Linux Dedicated Server

Please refer to the following steps: First, log in to your server as root.   Edit the csf configuration file using the following command:   vi /etc/csf/csf.conf   Search for the following line:   # Allow incoming TCP ports TCP_IN = “20,21,22,25,26,53,80,110,143,443,465,587,993,995, 2077,2078,2082,2083,2086,2087,2095,2096,28900,2896 0,28970,28860,49030,3333”   Add the port no 3306

How to Reset MySQL root Password

If you’ve forgotten or need to change your root user password in MySQL, you might be wondering what steps are necessary to reset your MySQL root password. Luckily, there are couple of ways to do this.   Using the mysqladmin Command to Change root Password If you’ve never set a

How to Dump the MySQL Database to an SQL file?

Execute the following command to dump a database: mysqldump database_name > Database_name.sql For example, you want to dump a database called “myblog”. mysqldump myblog > myblog.sql Now, after you have the database backedup already, simply import the contents to your destination database (i.e. another database). mysql new_database_name < Database_name.sql Here

How to Check and Repair a Corrupted MySQL Database Table Using SSH

In this tutorial we’ll cover how to use MySQLcheck to repair a corrupted database table. Repairing a Corrupted MySQL Database Table Please refer to the following steps: First, log in to your MySQL server using Secure Shell (SSH). Then, enter the following command at root prompt: mysqlcheck -r [database name]

How to check MySQL query caching status on your linux server?

Login to your server as root.   On mysql prompt fire the following command:   mysql> SHOW VARIABLES LIKE ‘%query_cache%’;   This will result the table as follows : +——————————+———–+ | Variable_name | Value | +——————————+———–+ | have_query_cache | YES | | query_cache_limit | 1048576 | | query_cache_min_res_unit | 4096