mysql database

  1. K

    How can we restore MySQL database via Command Prompt?

    First open Command Prompt in your Windows server. Now use below command to navigate to MySQL bin folder. cd "C:\Program Files\MySQL\MySQL Server 5.6\bin" or cd "C:\Program Files\MySQL\MySQL Server 5.7\bin" After that you have to execute below command to restore your database. mysql -u...
  2. K

    Steps to change phpMyAdmin password

    You can check the below steps to change password of phpMyAdmin. Frist login to phpMyAdmin with these steps. Now click on “Change Password”, you will get a screen where you have to enter new password. And click on “Go” button.
  3. K

    Steps to start/stop MySQL service in WHM

    First login to your WHM. Here navigate to Service Configuration >> Service Manager Under the Service Configuration section, select Service Manager. Here you will find list of services, you have to uncheck the box which is under MySQL to stop MySQL service. Now click on Save button. If you want...
  4. K

    Steps to clone MySQL database via PhpMyAdmin

    You can clone your database in PhpMyAdmin and for that you have to create separate copy of your database. First login to phpMyAdmin. Here you will find list of databases, click on particular database to clone it. In the top bar you will find option “Operations”, click on it. You will find a...
  5. K

    Ways to make connection to MySQL database from phpMyAdmin

    You can follow below steps to make connection to MySQL database from phpMyAdmin. If you have login details then you can open phpMyAdmin URL (http://VPS_IP_address:8080). Now enter your username and password, and click on Go button. Here you have to enter you server IP address instead of...
  6. K

    Steps to restore mysql database in cpanel

    You can follow below steps to restore mysql database: Login to cpanel. Here click on “Backup” option under “Files” section. You have to scroll your page and then you will find “Restore MySQL database backup”. Choose your backup file and upload it. It will take some time and your mysql backup...
  7. K

    How to repair MySQL database in WHM?

    Steps to repair MySQL database from WHM server: Login to WHM. You will find “Repair a MySQL database” option under “SQL Services”. Now select the particular database which you want to repair and then click on “Repair Database” button.
  8. K

    Steps to take backup database from shell

    You can use below command to take backup of your database. # mysqldump database_name > backup.sql After that you can restore your database with below command: # mysql database_name
  9. K

    Steps to take backup database from shell

    You can use below command to take backup of your database. # mysqldump database_name > backup.sql After that you can restore your database with below command: # mysql database_name
  10. K

    Changing Database Port of WordPress Website

    WordPress uses MySQL as its database by default. When you start using WordPress, the database port will be set to something by default by the hosting provider. In most cases, you don’t have to worry about finding it out or changing it. But in other instances, changing database port of your...
  11. K

    Steps to kill MySQL connections on server

    If you are making too many database connections then you will get error “too many database connections”, to resolve this error you can manually terminate database connections. Most quick and easy ways to terminate or kill MySQL connections is to restart MySQL services. You can use below command...
  12. K

    Steps to restore MySQL grants

    Script restoregrants which is available in /usr/local/cpanel/bin/restoregrants location helps to restore database users from data which is available in /var/cpanel/databases/grants_* files. You can use below command: /usr/local/cpanel/bin/restoregrants [--cpuser=cpuser] [--db=mysql|pg]...
  13. K

    Steps to convert database tables from InnoDB to MyISAM

    If you want to convert your database tables to MyISAM then you can follow below steps.But for that it is must to have root access of your database. You have to first dumped your SQL file via mysqldump and for that we have to replace "ENGINE=INNODB" with "ENGINE=MyISAM". You can check below...
  14. K

    Resolve Error “Restarting MySQL due to my.cnf modifications."

    Mysqluserstore script helps to update users.db and users.db.cache file. You can check location of these files : /var/cpanel/databases/users.db /var/cpanel/databases/users.db.cache After that you will get below error: [mysqluserstore] Restarting MySQL due to my.cnf modifications. You have to...
  15. K

    Steps to enable error log in MySQL database

    If you want to enable mysql error log then explicitly you have to enable option /etc/my.cnf file and after that you have to restart mysql service. You have to follow below steps: Login to server via SSH as root. Here check your /etc/my.cnf file and add below line in [mysqld] section...
  16. K

    Steps to turn off Event scheduler in Mysql database

    If you are using MySQL 8 version then you must know that Event Scheduler is enabled by default. You have to modify etc/my.cnf file, you have to add below line under [mysqld] section. event_scheduler=off After that you have to restart mysql service to reflect the changes.
  17. K

    How to increase max_allowed_packet in mysqldump?

    You can increase the max_allowed_packet in my.cnf file. You have to edit my.cnf file and add below line in my.cnf file. First you have to find [mysqldump] section in /etc/my.cnf file and then add below code : [mysqldump] max_allowed_packet=268435456 You can add value according to your choice.
  18. K

    Steps to set default storage engine for database

    Storage engines are software components which help DBMS to create, read, update and delete. We can also change storage engine for database. By default mysql 5.5 and later storage engine is InnoDB. We can change the default storage engines in my.cnf file. In this file we have to update...
  19. K

    mysql error “out of resources”

    You are getting this error while opening a file which means mysql file open permission has been exceeded. Open files limit can be managed by open_files_limit variable, we can run below query in phpmyadmin: SHOW VARIABLES LIKE 'open%' You will check the limit of open_files_limit variable with...
  20. K

    What are MySQL triggers? And steps to use them

    MySQL triggers is an object which is attached with particular table and execute when that event occur. These triggers only work when any of these Mysql statements run like INSERT, UPDATE, DELETE etc. NOTE: You can only use triggers if you have MySQL SUPERUSER privileges. So you have your own...
Top