Tag: Mysql

Installation, MySql

How to Install MySql on CentOS server

How to install MySql on CentOS server Please check whether MySql packages are available under yum. yum list mysql* If yes, then install mysql using below command. yum install mysql* Now install the Mysql database on the server using below command. mysql_install_db It will create mysql database on mysql server.  Now, we have to reset …

MySql, Uncategorized

How to check if InnoDB engine is enabled in MySQL

How to check if InnoDB engine is enabled in MySQL If you want to check , if InnoDB is enabled on the server , you can check this via two methods : [email protected][#] mysqladmin variables | grep have_innodb If the above command show the output as below : | have_innodb | YES then it means InnoDB …

MySql, Uncategorized

How to take Database Backup using phpMyAdmin

How to take Database Backup using phpMyAdmin. First you need phpMyAdmin which is a MySQL Database Administration Tool. 1 – Open phpMyAdmin 2 – Click on Export 3 – Under Export – Select the database you want to backup 4 – Select SQL 5 – Select Structure, Add DROP TABLE, Add IF NO EXISTS, Add …

MySql, Uncategorized

Mysql Commands

Mysql Commands: How to check mysql connection or login to your Database using shell ========================= [email protected][#] mysql -u username -p ========================= it will ask for password then provide the correct password.   Create Database on the Mysql Server ========================= mysql> create database [databasename]; ========================= ex : mysql>create database Dresses;   List all databases on the …