Group items tagged

Using the MySQL Client You can create MySQL users and databases quickly and easily by running mysql from the shell. The syntax is shown below and the dollar sign is the command prompt: $ mysql -u adminusername -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 5340 to server version: 3.23.54 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> CREATE DATABASE databasename; Query OK, 1 row affected (0.00 sec) mysql> GRANT ALL PRIVILEGES ON databasename.* TO "wordpressusername"@"hostname" -> IDENTIFIED BY "password"; Query OK, 0 rows affected (0.00 sec) mysql> FLUSH PRIVILEGES; Query OK, 0 rows affected (0.01 sec) mysql> EXIT Bye $

Step 2: Create the Database and a User

Using the MySQL Client

$ mysql -u adminusername -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 5340 to server version: 3.23.54 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> CREATE DATABASE databasename; Query OK, 1 row affected (0.00 sec) mysql> GRANT ALL PRIVILEGES ON databasename.* TO "wordpressusername"@"hostname" -> IDENTIFIED BY "password"; Query OK, 0 rows affected (0.00 sec) mysql> FLUSH PRIVILEGES; Query OK, 0 rows affected (0.01 sec) mysql> EXIT Bye $

#!/bin/bash # Nightly backup system for home directories and MySQL # databases for websites managed by CPanel. # Author: Kieran O'Shea # Author's Website: www.kieranoshea.com # Support: kieran@kieranoshea.com # License: GPLv2 # USAGE: Place this file inside the directory you want to # put backups in, set it as a CRON job to run and collect # backups from the site(s) you define below at a preset # time each day, or run it manually everytime you want to # take a backup. You can place an unlimited number of sites # and databases to be backed up in the variables below so # long as you follow the convention. It doesn't even matter # if your different domains are hosted in different locations # so long as they are all managed by CPanel. # Prerequisites: # - Linux box with bash shell # - wget installed # Define all the sites you wish to backup in the array below # Domain name and tld only, eg. kieranoshea.com domain=( domain1.com domain2.com ) # Define all the usernames for the above sites in the array # below - keep order consistant! user=( user1 user2 ) # Define all the passwords for the above usernames in the # array below - keep order consistant! If you log on as # reseller or root you can enter the same password in # every array position, but none the less they must be filled. pass=( pass1 pass2 ) # Number of databases in each domain above - keep order # consistant. If you don't wish to backup any databases # for a particular domain, or don't have any for it, place # a 0 in it's position in the array. no_of_db=( 3 1 ) # Database names, exactly as they are in CPanel, in the order # that the domains appear. You may like to log into CPanel # manually and check your database names before filling this # variable in. Number of db names here must match the above # variables also! Eg. all dbs in domain 1 followed by all # dbs in domain 2 etc. You DO NOT need to enter any database # names below for a domain if you have placed a zero for it # in the array above databases=( domain1_datebase1 domain1_datebase2 domain1_datebase3 domain2_datebase1 ) # Thats all folks, save the file, CHMOD it to be executable # by the user who will run it, and you are all set. # Do not edit anything below this point! echo echo "-----------------------------------------------------------------" echo "Kieran's nightly backup system started" echo "-----------------------------------------------------------------" echo "" echo "-----------------------------------------------------------------" echo "Creating a directory in your backup path for tonights backup..." echo "-----------------------------------------------------------------" FOLDER="$(date +%d-%m-%Y)" mkdir $FOLDER cd $FOLDER echo "-------" echo "Done!" echo "-------" echo "" echo "-----------------------------------------------------------------" echo "Creating a directory for every domain to be backed up into..." echo "-----------------------------------------------------------------" count=${#domain } i=0 while [ "$i" -lt "$count" ] do mkdir ${domain[$i]} let "i = $i + 1" done echo "-------" echo "Done!" echo "-------" echo "" echo "-----------------------------------------------------------------" echo "Backing up MySQL databases..." echo "-----------------------------------------------------------------" overall_db_count=0 count=${#domain } i=0 while [ "$i" -lt "$count" ] do cd ${domain[$i]} mkdir databases cd databases start_point=$overall_db_count # start point for iterating over the array of db names let "end_point = $overall_db_count + ${no_of_db[$i]}" # end point to stop iterating (always the overall count!) n=$start_point while [ "$n" -lt "$end_point" ] do wget http://${user[$i]}:${pass[$i]}@www.${domain[$i]}:2082/getsqlbackup/${databases[$n]}.gz let "n = $n + 1" done let "overall_db_count = $overall_db_count + ${no_of_db[$i]}" # increase the overall count to keep a tally cd .. cd .. let "i = $i + 1" done echo "-------" echo "Done!" echo "-------" echo "" echo "-----------------------------------------------------------------" echo "Backing up home directories; this make take some time..." echo "-----------------------------------------------------------------" count=${#domain } i=0 while [ "$i" -lt "$count" ] do cd ${domain[$i]} wget http://${user[$i]}:${pass[$i]}@www.${domain[$i]}:2082/getbackup/backup-${domain[$i]}-$FOLDER.tar.gz cd .. let "i = $i + 1" done echo "-------" echo "Done!" echo "-------" echo "" echo "-----------------------------------------------------------------" echo "All backup tasks completed. Goodnight!" echo "-----------------------------------------------------------------"