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";

}

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

File Upload in CakePHP

Posted on October 30, 2011 by admin

In this post I will describe how to upload images in CakePHP. It will automatically upload and move the uploaded file to the wanted location. It will automatically rename the file if there is another file with same name exist. A lot of other features are also available.

Download Upload Component file and copy it to the location app/Controller/Component/UploadComponent.php
Initialize

var $components = array('Upload');

1

var $components = array('Upload');

Your add action would looks like:

public function add() {
	if ($this->request->is('post')) {
		if (!empty($this->request->data) && is_uploaded_file($this->request->data['Gallery']['image']['tmp_name'])) {
			
			$this->Upload->upload($this->data['Gallery']['image']);
			if ($this->Upload->uploaded) {
				$this->Upload->file_new_name_body   = 'image_resized';
				$this->Upload->image_resize         = true;
				$this->Upload->image_x              = 400;
				$this->Upload->image_ratio_y        = true;
				$this->Upload->process(Configure::read('UploadPath'));
				if ($this->Upload->processed) {
					$this->Upload->clean();
					$this->request->data['Gallery']['image'] = basename($this->Upload->file_dst_name);
				} else {
					$errors = $this->Upload->error;
					$this->Session->setFlash(__($errors));
					exit();
				}
			}
		}
		$this->Gallery->create();
		if ($this->Gallery->save($this->request->data)) {
			$this->Session->setFlash(__('The gallery has been saved'));
			$this->redirect(array('controller' => 'galleries' ,'action' => 'index'));
		} else {
			$this->Session->setFlash(__('The gallery could not be saved. Please, try again.'));
		}
	}
}

public function add() {

if ($this->request->is('post')) {

if (!empty($this->request->data) && is_uploaded_file($this->request->data['Gallery']['image']['tmp_name'])) {

$this->Upload->upload($this->data['Gallery']['image']);

if ($this->Upload->uploaded) {

$this->Upload->file_new_name_body = 'image_resized';

$this->Upload->image_resize = true;

$this->Upload->image_x = 400;

$this->Upload->image_ratio_y = true;

$this->Upload->process(Configure::read('UploadPath'));

if ($this->Upload->processed) {

$this->Upload->clean();

$this->request->data['Gallery']['image'] = basename($this->Upload->file_dst_name);

} else {

$errors = $this->Upload->error;

$this->Session->setFlash(__($errors));

exit();

}

$this->Gallery->create();

if ($this->Gallery->save($this->request->data)) {

$this->Session->setFlash(__('The gallery has been saved'));

$this->redirect(array('controller' => 'galleries' ,'action' => 'index'));

} else {

$this->Session->setFlash(__('The gallery could not be saved. Please, try again.'));

}

We have setup our controller. Now its time to setup view file add.ctp. The file file should look like following:

<div class="galleries form">
< ?php echo $this->Form->create('Gallery', array('enctype' => 'multipart/form-data'));?>
	<fieldset>
		<legend>< ?php echo __('Add Gallery'); ?></legend>
	< ?php
		echo $this->Form->input('caption');
		echo $this->Form->input('desc');
		echo $this->Form->file('image');
	?>
	</fieldset>
< ?php echo $this->Form->end(__('Submit'));?>
</div>
<div class="actions">
	<h3>< ?php echo __('Actions'); ?></h3>
	<ul>

		<li>< ?php echo $this->Html->link(__('List Galleries'), array('action' => 'index'));?></li>
	</ul>
</div>

< ?php echo $this->Form->create('Gallery', array('enctype' => 'multipart/form-data'));?>

< ?php

echo $this->Form->input('caption');

echo $this->Form->input('desc');

echo $this->Form->file('image');

</fieldset>

< ?php echo $this->Form->end(__('Submit'));?>

</div>

<ul>

<li>< ?php echo $this->Html->link(__('List Galleries'), array('action' => 'index'));?></li>

</ul>

</div>

All done.

UploadComponent class file is well document so you can always find all configuration setting for the uploaded images.

Rashid Azar's Blog

Don't document the program; program the document.

Category Archives: PHP

Backup MySQL Databases

File Upload in CakePHP