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
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
© Hivelocity Ventures Corporation. All Rights Reserved.
