Backup MySQL Databases

Posted on December 30, 2012 by admin

If you are running a database driven website then your data sitting in MySQL database id most important for you. In most of shared hosting there is no provision for scheduled backup of databases. So I have written a script to take backup of all databases associated with the account.

< ?php
$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = 'password';
$backup_path = '/home/rashid/backup/';
$backup_file_suffix = "_`date '+%a-%m-%d-%Y'`.sql.gz";

$link = mysql_connect($dbhost, $dbuser, $dbpass);
$res = mysql_query("SHOW DATABASES");

while ($row = mysql_fetch_assoc($res)) {
	$filename = $backup_path . $row['Database'] . $backup_file_suffix;
	$command = 'mysqldump -u root -pmaison ' . $row['Database'] . ' | gzip > ' . $filename;    
	system($command);
	echo $row['Database'] . ": completed\n";
}
?>

< ?php

$dbhost = 'localhost';

$dbuser = 'root';

$dbpass = 'password';

$backup_path = '/home/rashid/backup/';

$backup_file_suffix = "_`date '+%a-%m-%d-%Y'`.sql.gz";

$link = mysql_connect($dbhost, $dbuser, $dbpass);

$res = mysql_query("SHOW DATABASES");

while ($row = mysql_fetch_assoc($res)) {

$filename = $backup_path . $row['Database'] . $backup_file_suffix;

$command = 'mysqldump -u root -pmaison ' . $row['Database'] . ' | gzip > ' . $filename;

system($command);

echo $row['Database'] . ": completed\n";

}

Install LAMP in UBUNTU 12.10

Posted on December 6, 2012 by admin

I installed Ubuntu 12.10 on my new laptop and now I have to setup LAMP on it. To setup LAMP I need to install Apache Web Server, PHP and MySQL.
For installation issue following commands:

$ sudo apt-get install apache2

1	$ sudo apt-get install apache2

Above command will download and install Apache Web Server. It will ask for permission to download the setup file. After completion of above command open the browser and browse following URL:

http://localhost/

1	http://localhost/

If it is opening properly, your web server is installed properly. Now we will install PHP:

$ sudo apt-get install php5 libapache2-mod-php5

1	$ sudo apt-get install php5 libapache2-mod-php5

Above command will download and install PHP and apache integration library. It will ask for permission to download the setup file.
To check the installation of php issue following command:

$ sudo gedit /var/www/test.php

1	$ sudo gedit /var/www/test.php

Write following code in this file and save it:

&lt;?php phpinfo(); ?&gt;

1	<?php phpinfo(); ?>

In the browser open following URL:

http://localhost/test.php

1	http://localhost/test.php

It will display PHP configuration details. We have installed PHP and integrated it with Apache Web Server.
If you are not getting required page the you need to restart Apache:

$ sudo service apache2 restart

1	$ sudo service apache2 restart

Our next task is to install MySQL server and PHP-MySQL connector. For this issue following command:

$ sudo apt-get install mysql-server libapache2-mod-auth-mysql php5-mysql

1	$ sudo apt-get install mysql-server libapache2-mod-auth-mysql php5-mysql

It will download and install MySQL Server. After installation it will ask to setup root password for database server.
Now we have installed Apache Web Server, PHP and MySQL. For database management you may need phpMyAdmin. To install phpMyAdmin issue following command:

$ sudo apt-get install phpmyadmin

1	$ sudo apt-get install phpmyadmin

After installation open following URL:

http://localhost/phpmyadmin

1	http://localhost/phpmyadmin

You will get the login screen of phpMyAdmin.

Congrats, You are done!!

CakePHP to Red Hat’s Openshift

Posted on April 29, 2012 by admin

There is only 6 easy steps to deploy your application to cloud.

Step 1 : Sign Up

Just visit to openshift and sign up a new account.

Step 2 : Install client tool

For installation instruction of client visit here

Step 3 : Create domain

$ rhc domain create -n <mydomain> -l <openshift login>

1

$ rhc domain create -n <mydomain> -l <openshift login>

Domain is the unique namespace for every account. Execute following command to create your domain

$ rhc domain create -n mydomain -l test@abc.com

1

$ rhc domain create -n mydomain -l test@abc.com

Step 4 : Create application

$ rhc app create -a -t

1

$ rhc app create -a -t

app name is the name of your application ant app type is the type of application you want to create. For a php application we execute following command:

$rhc app create -a mycake -t php-5.3

1

$rhc app create -a mycake -t php-5.3

Step 5 : Add MySQL to your application

$rhc app cartridge -a mycake -c mysql-5.1

1

$rhc app cartridge -a mycake -c mysql-5.1

Step 6 : Deploy your application to cloud
Once the application is created, it needs to deployed to cloud. After execution of step 4, a folder with the application name is created in current directory. Goto current directory and add cakephp to it.

$ cd mycake $ git remote add upstream -m master git://github.com/openshift/cakephp-example.git $ git pull -s recursive -X theirs upstream master $ git push

1
2
3
4
5
6
7

$ cd mycake

$ git remote add upstream -m master git://github.com/openshift/cakephp-example.git

$ git pull -s recursive -X theirs upstream master

$ git push

You can access your application from the URL :

http://mycake-mydomain.rhcloud.com

Rashid Azar's Blog

Don't document the program; program the document.

Tag Archives: php

Backup MySQL Databases

Install LAMP in UBUNTU 12.10