In this tutorial we will explain couple of ways how to export one or all MySQL databases from one server and import to another server. We will also explain how to export MySQL database in a file for backup. To export database we will using mysqldump command. In this example we will export one database […]
Tag: MySQL
Create MySQL database from command line
This tutorial explains how you can create MySQL user and database using command line. First, we will update the system and install MySQL database. We will update system and install MySQL database. For CentOS/RHEL OS:
|
1 |
yum update -y && yum install mysql mysql-server -y && service mysqld start && chkconfig mysqld on && mysql_secure_installation |
How to create MySQL database on cPanel
You can easily create a database in cPanel using MySQL Database Wizard option. Check out our step by step video tutorial.
Install Apache, MySQL and PHP on CentOS | LAMP
This tutorial explains how you can install and configure LAMP and phpMyAdmin on CentOS 5.11 and CentOS 6.7, 32 and 64 Bit OS versions. First of all we will update system:
|
1 |
yum update -y |
Install EPEL repository for your Linux version. If you are running an CentOS 5 version:
|
1 |
wget https://dl.fedoraproject.org/pub/epel/epel-release-latest-5.noarch.rpm && rpm -Uvh epel-release-latest-5.noarch.rpm |
