MySQL @ slashprog


In today session Chandrasheker  sir  started to teach mysql.

Today I learnt many thing in mysql .

already i have blogged about mysql queries and how to take backup using mysql queries

as mysql-for-beginners.

But today sir told about how to take backup without using queries

From shell ,

sathia@sathia-laptop:~$ mysqladmin -uroot -p(password) create sales_datails

we can create database using this command

First you should know where mysql datadir will be stored

mysql> SHOW VARIABLES LIKE ‘datadir’;
+—————+———————+
| Variable_name | Value          |
+—————+———————-+
| datadir       | /var/lib/mysql/   |
+—————+———————-+
1 row in set (0.00 sec)

or through shell :

sathia@sathia-laptop:~$ mysql -e “SHOW VARIABLES LIKE ‘datadir'” -uroot -p

We can connect mysql database of remote host by

mysql -h 10.xx.xx.xx(IP)  -uroot -p

Databases will be stored in /var/lib/mysql

sathia@sathia-laptop:/var/lib$ sudo ls mysql/
debian-5.1.flag  ib_logfile1         salesdetails    suresh
ibdata1         mysql             sathia
ib_logfile0     mysql_upgrade_info  sathia-laptop.pid

We can create tar file of database , using tar command .

Then we can give untar file when we need into same directory by following command

sathia@sathia-laptop:~$ sudo tar xzvf salesdetails.tar.gz -C /var/lib/mysql/

Advertisements

About sathia

Web developer at cloudmint
This entry was posted in programs. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s