Save 15% on Instant Deploy Bare-Metal Servers in 26 Global Markets with Coupon Code: EdgeSave
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
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
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
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
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,
After upgrading or with a newly installed version of Plesk, you may find yourself unable to set passwords for new database users. If you are experiencing this or are not able to do any kind of activity with the database users, check the MySQL error log. If the log shows:
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
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
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
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
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
