In this post, we are going to explain on how to take mysqldump of individual table for all the databases. As a bonus, we will add feature to store the dumps to s3(with Versioning) and encrypt the backup. Prerequisites: s3cmd command on linux machine. Mysql Root Password S3 Bucket name… Continue Reading Script to take tablewise mysqldump and store in s3

Its painful to restore a database from phpmyadmin on Xampp server because of  memory_limit, post_max_size, max_execution_time incase if the database size is huge. The best way is to restore the database from mysql command line. Since, I am using windows machine, will explain how to restore on windows machine. Get… Continue Reading Restore Database on Xampp from command line

In this post, we are going post to explain installing nginx, PHP-fpm, mariadb on Centos 7. As a bouns, gonna add information on how to install wordpress on the host. Installation: Mariadb Installation: Let’s start with adding mariadb repository. Create a MariaDB.repo on /etc/yum.repos.d directory with the below content. vi /etc/yum.repos.d/MariaDB.repo #… Continue Reading Install Nginx, PHP-fpm, Mariadb on Centos 7

Prerequisites: Ubuntu Server SSH Access to Server Installation: Install the required packages using apt-get utility. apt-get install apache2 php5 php5-dev php5-gd php5-mysql subversion,nano imagemagick,ghostscript antiword xpdf libav-tools postfix libimage-exiftool-perl cron wget   Move to the documentroot and download resourcespace application. cd /var/www/html sudo svn co http://svn.resourcespace.org/svn/rs/trunk cd resourcespace   Create… Continue Reading ResourceSpace installation on Ubuntu

In this post, we are trying to cover up how to install on plain ubuntu server. We are going to use Apache 2.4.7 with PHP FPM 5.5.9 for the moodle application to run on ubuntu host. Install the dependent packages. apt-get install apache2 mysql-server php5 libapache2-mod-fastcgi php5-fpm Install other dependencies for… Continue Reading Moodle installation on Ubuntu

This post explains how to convert ppk key to pem on Mac. Let’s install putty using brew. brew install putty Execute the following command to convert ppk to pem. puttygen key.ppk -O private-openssh -o key.pem where, key.ppk is your ppk file key.pem is new name of your key file. Change… Continue Reading Convert ppk key to pem on Mac

Scrumblr is a simple web-based simulation of a physical agile kanban board(or say a white board) that supports real-time collaboration with other teammates. It is built using node.js, websockets (using socket.io), CSS3, and jquery. The installation of Scrumblr is quite simple and straight forward. Hope this post helps. Steps: 1)… Continue Reading Install Scrumblr in Ubuntu 14.04

Moodle is a free and open-source software learning management system written in PHP. In this post, we will be sharing you step by step installations guide to setup Moodle with MariaDB or MySQL on Apache Webserver with PHP FPM support. We have select PHP FPM support(mod_fastcgi & php-fpm) for Apache… Continue Reading Install Moodle with MariaDB in Ubuntu 14.04

In this article going to discuss login and logout using php .The first read previous article  https://blog.pheonixsolutions.com/basic-insert-delete-update-database-image-upload-using-php/. LOGIN.PHP $query=mysql_connect(“localhost”,”root”,””); mysql_select_db(“demo”,$query); session_start(); if(isset($_POST[‘send’])) { $name=$_POST[‘name’]; $password=$_POST[‘password’]; if($name!=”” && $password!=””) { $s=mysql_query(“select *from reg where name = ‘$name’ AND password = ‘$password'”); $a=mysql_fetch_array($s); $count=mysql_num_rows($s); if($count==0) { echo “user does not exist”; } else… Continue Reading Basic Login and logout using php

In this post, we are going to explain how to insert, delete, update tables on a database using php. DataBase And Table: CREATE DATABASE demo; CREATE TABLE reg ( id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY, name VARCHAR(30) NOT NULL, password VARCHAR(30) NOT NULL, address VARCHAR(30) NOT NULL, email VARCHAR(50), fathername… Continue Reading Basic insert, delete, update database & Image upload using php