MySQL Commands for Installing Drupal on Linux

MySQL Command for Linux to Restore DB / Create DB

Connect DB

mysql --user=root --password=welcome

Create DB

create database <Dbname>

show Databases;

Restore DB

mysql -u root -p infatest < infatest.sql

Copy Command with Folder

cp -R Source and Destination

Folder and file permission

Chmod 777 folder or file name

Restart Apache Service

/etc/init.d/apache2 restart

Download files from Command

wget https://ftp.drupal.org/files/projects/drupal-8.1.3.tar.gz

install Apache on Linux

sudo apt-get install apache2 apache2-doc apache2-utils

Install PHP

sudo apt-get install libapache2-mod-php5 php5 php-pear php5-xcache

sudo apt-get install  php5-mysqlnd-ms

sudo service apache2 reload

How to Install MySQL on Ubuntu and CentOS

https://www.digitalocean.com/community/tutorials/a-basic-mysql-tutorial

sudo apt-get install mysql-server
mysql -u root -p

CREATE DATABASE database name;

Restore DB 
mysql.exe -u root -p dbname < C:\folder\Dbname.sql

Set Packet Limit (Windows Server Only)
SET GLOBAL max_allowed_packet=1073741824;

• Tweet
• Share
• Share
• Share
• Share