Backup and Restore MySQL Database Using mysqldump Command

Using mysqldump, you can backup a local database and restore it on a remote database at the same time, using a single command. In this article, let us review several practical examples on how to use mysqldump to backup and restore.

----------------------------------------------------------------------------------------------------------------------------------------

backup: # mysqldump -u root -p[root_password] [database_name] > dumpfilename.sql 

restore:# mysql -u root -p[root_password] [database_name] < dumpfilename.sql  

Access files from password proctected site

----------------------------------------------------------------------------------------------------------------------------------------
#wget --user=username --password=password http://example.com/files.tar.gz
----------------------------------------------------------------------------------------------------------------------------------------

Change username and password as your requirement from the above command .

How do I enable server-side includes on my site ?

How do I enable server-side includes on my site ?

• 1. #cd /to/your/site/folder

  2. #vi .htaccess

  3. and paste the below content in that 

     ------------------------------------------------------------------------------------------ 

     AddType text/html .shtml
     AddHandler server-parsed .shtml
     DirectoryIndex index.shtml index.html index.htm index.php
     Options +IncludesNoExec -ExecCGI 

     ------------------------------------------------------------------------------------------ 

  4.  thats it done .

Back up files in linux

The below is the script to backup files in linux :

• copy the below script and name example.sh

-----------------------------------------------------------------------------------------------------------------------------------------
#!/bin/bash
#START

TIME=`date +"%b-%d-%y_%H-%M-%S"`            
FILENAME="backup-$TIME.tar.gz"     
SRCDIR="/path/to/source/folder"         #please change to your source folder         
DESDIR="/path/to/destination/folder"   # please change to your destination folder        
tar -cpzf $DESDIR/$FILENAME $SRCDIR

find /path/to/destination/folder/ -iname '*.tar.gz' -ctime +45 -exec rm -f {} \;  #please change to your destination folder
#END
-----------------------------------------------------------------------------------------------------------------------------------------

•  And change the mode of file example.sh

-----------------------------------------------------------------------------------------------------------------------------------------
 #chmod +x example.sh
-----------------------------------------------------------------------------------------------------------------------------------------

• And move the examle.sh file  

-----------------------------------------------------------------------------------------------------------------------------------------

#mv example.sh /bin/

-----------------------------------------------------------------------------------------------------------------------------------------

• Now edit crontab

-----------------------------------------------------------------------------------------------------------------------------------------

 #sudo crontab -e

 45 22 * * * example.sh    #Edit as your requirement

-----------------------------------------------------------------------------------------------------------------------------------------

Creating user in Phpmyadmin using SQL

1) Login to phpmyadmin

2) open the perticular DB

3) click on SQL tab

4) Paste the below line there and change the username and dbname as yours and password as you require .

-------------------------------------------------------------------------------------------------------------------------------------
grant all privileges on dbname.* to username@localhost identified by 'passwd';
-------------------------------------------------------------------------------------------------------------------------------------

INSTALL MONGODB ON UBUNTU

Create a the /etc/apt/sources.list.d/10gen.list file and include the most appropriate version of the following lines for the 10gen repository

----------------------------------------------------------------------------------------------------------------------------------------
deb http://downloads-distro.mongodb.org/repo/ubuntu-upstart dist 10gen
-----------------------------------------------------------------------------------------------------------------------------------------

---------------------------------------------------------------------------------------------------------------------------------------
sudo apt-key adv –keyserver keyserver.ubuntu.com –recv 7F0CEB10
----------------------------------------------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------------------------------------------
sudo apt-get update
-----------------------------------------------------------------------------------------------------------------------------------------

-----------------------------------------------------------------------------------------------------------------------------------------
sudo apt-get install mongodb-10gen
-----------------------------------------------------------------------------------------------------------------------------------------

You are ready with mongodb , to check status service mongodb status.



 INSTALL GRAPHICAL TOOL

Download mViewer from

--------------------------------------------------------------------------------------------------------------------------------------   
https://github.com/Imaginea/mViewer
--------------------------------------------------------------------------------------------------------------------------------------

Now go to scripts folder and run start_mviewer.sh

Visit your localhost on 8080 port with no username and password if you have not set any(

---------------------------------------------------------------------------------------------------------------------------------------
http://127.0.0.1:8080
---------------------------------------------------------------------------------------------------------------------------------------

Now you are done with mongodb GUI interface.

ENABLE IP FORWORDING (RHEL ,CENT OS)

Open /etc/sysctl.conf file using a text editor, enter:

------------------------------------------------------------------------------------------------------------------------------------------
 # vi /etc/sysctl.conf
--------------------------------------------------------------------------------------------------

Set net.ipv4.ip_forward to 1, enter:

-------------------------------------------------------------------------------------------------- 

net.ipv4.ip_forward = 1

-------------------------------------------------------------------------------------------------- 

Save and close the file. Reload the changes by typing the following command: 

--------------------------------------------------------------------------------------------------
# sysctl -p

--------------------------------------------------------------------------------------------------                  

ACL (access control list)

1 ) To check if your ext4 filesystem has the proper default options, use tune2fs as below :
  ------------------------------------------------------------------------------------------------------------------------

   # tune2fs -l /dev/sdb1

 --------------------------------------------------------------------------------------

2 ) To enable ACLs on a filesystem, we must set the fs default and remount: 

 -------------------------------------------------------------------------------------------

 # tune2fs -o acl /dev/sdb1
 # mount -o remount,acl /data1

 -------------------------------------------------------------------------------------------

3) Use getfacl to view ACLs: 

------------------------------------------------------------- 

# touch /data1/foo.txt
# getfacl /data1/foo.txt
-------------------------------------------------------------

4) Use setfacl to set ACLs, with -m to modify and -x to remove a given ACL. 
          a) give user bob read+write+execute on a file:
----------------------------------------------------------------------------------------------------------------------------------------

#setfacl -m u:bob:rwx /data1/foo.txt

      b)give group peeps read+write on a file: 

#setfacl -m g:peeps:rw /data1/foo.txt

--------------------------------------------------------------------------------------------------------------------------------------

5)remove bob's ACL permissions:
-------------------------------------------------------------------------------------------------------------------------------------

#setfacl -x u:bob /data1/foo.txt

-----------------------------------------------------------------------------------------------

6)setfacl permission to directory

------------------------------------------------------------------------------------------------ 

#setfacl -m d:g:peeps:rw /data1/stuff/

---------------------------------------------------------------------------------------------- 

7) revoke write permission for everyone:

--------------------------------------------------------------------------------------------------- 

#setfacl -m m::rx /data1/foo.txt 

------------------------------------------------------------------------------------------------- 

8) When ACLs are present, an ls -l will show a plus sign to notify you:

-------------------------------------------------------------------------------------------------- 

 # ls -l /data1/foo.txt 
-rw-rwxr--+ 1 root root 0 Dec  3 14:54 /data1/foo.txt

 --------------------------------------------------------------------------------------------------------------------------------------

To remove only the tables in DB :

Go to terminal and excute the bellow command with your database username ,databasename , and password :

mysqldump -u username -p --no-data dbname | grep ^DROP > drop.sql 

mysql -u username -p dbname < drop.sql   

rm drop.txt

To find which version of linux OS installed

This is only for the Linux distribution
open the terminal and enter the bellow command

#cat /etc/*release

.htaccess Proctection

IP address restrictions to protect directories using .htaccess

copy the below 6 lines to .htaccess file 

<limit GET>
order deny,allow
deny from all
allow from 128.175
allow from 128.4
</limit>

   

Folder proctection using .htaccess this is only for linux users

 Create .htaccess if not present and add below 5 lines

AuthName "Restricted Area"
AuthType Basic
AuthUserFile /var/www/vhosts/sitename/httpdocs/.htpasswd
AuthGroupFile /dev/null
require valid-user

# htpasswd -c /var/www/vhosts/sitename/httpdocs/.htpasswd kirthan