Browse Category: Mysql

Mysql

bash script backup mysql database

Bash script backup MySql database

As we all know, databases is one of the most important thing you need to backup before you want to upgrade, move to new server or before you want to do a task but do not really sure about the impact. I have written a article about the command line to MySql database - How to Backup and Restore. In this article, I will show you a little bash script backup MySql database at regular intervals and deleting backups which older than 15 days from current.

This Bash script backup MySql will contain your database information so please make sure you set the right permissions, more over please don’t place the backup folder in public_html folder othervise other people will be able to see the content of your database. Continue Reading

phpmyadmin login screen

phpMyAdmin installation on Ubuntu 14.04

phpMyAdmin is a free and open source tool written in PHP intended to handle the administration of MySQL with the use of a web browser. It can perform various tasks such as creating, modifying or deleting databases, tables, fields or rows; executing SQL statements or managing users and permissions. This tutorial will show you the way to install phpMyAdmin on Ubuntu 14.04

Prerequisites

Before you get start, you need to have a LAMP(Linux, Apache, MySQL and PHP) installation on your Ubuntu 14.04 server. You can follow this tutorial Install LAMP in Ubuntu server to more detail what you need to have first. Continue Reading

Setup PHP web server

Setup PHP Web Server

You are ready for PHP coding, but don’t know how to start. What you need is a web server. This tutorial will show you two ways of Setup PHP Web Server. The first way is a very easy and convenient to install and configure an AMP (Apache, MySQL, PHP) package, this tutorial will show you how to install XAMPP. The second one is to install and configure each component of AMP separately. Continue Reading

Backup restore mysql database

MySql database – How to Backup and Restore

Backup Restore MySql database, there are may way to do that. It depends on where you store database: in Windows, in Centos, in Ubuntu and the way you manage it e.g: by PhpMyadmin, other  Mysql Database Administrator tool. If you using some Mysql Database Administrator tool, I think it is quite simple and you knew it, so in this post I only guide you the way to Backup Restore Mysql database by command line. Continue Reading