How to repair mysql with Plesk (Onyx) Repair Utility

With Plesk repair utility you can easily check and repair the Mysql Databases servers , it verifies the integrity of MySQL databases and database users. Use the following commands accordingly. Login to your Plesk Onyx server with root user In order to Check the availability of MySQL database servers and

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

How to Create a MySQL Backup from Command Line

Creating a MySQL Backup using the Command Line Looking to create a MySQL backup file? Thanks to one of MySQL’s built-in command line utilities, making backups of your MySQL database is easy. By using the mysqldump command line utility available with your MySQL installation (located in the bin directory), this

How to enable mysql port on your linux dedicated server?

Please refer the following steps: 1. Login to your server as root. 2. Edit csf configuration file using the following command: vi /etc/csf/csf.conf 3. Search the 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” 4. Add the port no 3306 for mysql in this line. #

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 the following steps: a)     Login to your MySQL server using Secure Shell (SSH). b)     Enter the following command at root prompt: mysqlcheck -r [database name] Where, mysqlcheck

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