Here is the quick snippet of how backup and restore MySQL database
using mysqldump:
backup:
# SSH to your machine then type the below given command;
# mysqldump -u root -p[root_password] [database_name] >
dumpfilename.sql restore:
#SSH to you machin...
1.Login to your Parallels Plesk Panel. 2.Click on the DOMAINS icon.
3.Click on the relevant domain name.
4.Click on the DATABASES icon. 5.Click on the relevant database
name. 6.Click on the WEBADMIN icon. 7.Click on the DATABASE name on
the left...
_1.Open phpMyAdmin._
2.Click Export in the Menu to get to where you can backup you MySql
database.
_3. Make sure that you have selected to export your entire database,
and not just one table._
There should be as many tables in the export list a...
If your host uses CPanel for your site management, you can use this
visual interface to create the database.
* Log into your CPanel (typically located at
http://www.example.com/cpanel for your domain).
* Look for the option to work with databases...
* _Login to phpMyAdmin [1]._
* _Click databases, and select the database that you will be
importing your data into._
* _You will then see either a list of tables already inside that
database or a screen that says no tables exist. This depends on y...
Install MYSQL SERVER 5.6 IN CENTOS 6.X AND RED HAT 6.X LINUX
In this tutorial we will learn how to install MySQL Server 5.6 in
CentOS 6.x and RHEL 6.x by using yum command.The package is
"Architecture Independent" hence applicable to 32 bit(i386) an...