Tag: database

mysqldump exclude databases

mysqldump doesn’t offer an option to exclude a database from the dump, similar to –ignore-table for tablesBash to the rescue! This short shell script lets you exclude a list of databases #!/bin/bash DATABASES_TO_EXCLUDE=”EXCLUDEDB1 EXCLUDEDB2” EXCLUSION_LIST=”‘information_schema’,’mysql'” for DB in `echo “$ {DATABASES_TO_EXCLUDE}”` do EXCLUSION_LIST=”$ {EXCLUSION_LIST},’$ {DB}'” done …

MyDumper – CentOS HowTo

Mydumper – MySQL backup tool created by Domas Mituzas and later supported by several other devs. The main benefits are multi-threaded and fast backups with almost no locking (if not using non innodb tables), built-in compression, separate files for each table, making it easy to restore …

Static vs Dynamic (CMS) Websites

All too often I see sites being created and deployed with a WordPress or Drupal backend, only to be attacked later due to no upkeep by the server admin or person managing the website. Although, it is much easier nowadays to build and deploy a websites, …

How to install MediaWiki on Ubuntu 14.04

This document describes how to install and configure MediaWiki on Ubuntu 14.04.  MediaWiki is free server-based software which is licensed under the GNU General Public License (GPL). It’s designed to be run on a large server farm for a website that gets millions of hits per …

How to install Moodle on Ubuntu 14.04

This document describes how to install and configure Moodle on Ubuntu 14.04.  Moodle (acronym for Modular Object-Oriented Dynamic Learning Environment) (stylised in lower-case as moodle) is a free software e-learning platform, also known as a Learning Management System, or Virtual Learning Environment (VLE). As of June …

How to configure a remote MySQL connection

On low traffic websites rare times you will need to run you own MySQL dedicated vps or server, however on high traffic websites it’s a very common practice to split the database queries to a dedicated server or VPS that will run only MySQL server. This …

Install Pagekit CMS on an Ubuntu VPS

Today we will go through the process of installing Pagekit CMS on an VPS with and MariaDB. Pagekit is a modern CMS, written in PHP on top of Symfony components and modern open source libraries. Pagekit uses its own templating engine called Razr and Markdown formatting. …

How to Install WordPress on CentOS

How to Install WordPress on CentOS Contents 1.1: Overview 1.2: Preliminary Checks 1.3: Step-by-Step Guide to Install WordPress on CentOS 1.3.1: Step One-Downloading WordPress 1.3.2: Step Two-Creating the WordPress Database and User 1.3.3: Step Three-Setting up the Configuration of WordPress 1.3.4: Step Four-Copying the Files 1.3.5: …

Short URLs: should you implement your personal?

Sites like Twitter (and its one hundred forty character restrict) have helped gasoline an explosion in using URL shorteners to generate brief URLs. If you are usually not accustomed to what a URL shortener is it principally lets you take a particularly lengthy and troublesome to …

How to Install WordPress on Vesta CP

So here it is a step-by-step tutorial on how to install WordPress on VPS with Vesta CP, a great free control panel for every VPS that demands a free version of WHM/cPanel. I won’t talk much more detail about what Vesta CP is and what features …

How to clone MySQL database

Here is a method to create a replica of 1 database, with all its tables and their knowledge Dump your supply database into sql file # mysqldump -uroot -p manufacturing -r manufacturing.sql If you want solely schema (database with empty tables) # mysqldump -uroot -p manufacturing …

System middle configuration supervisor Upgrade to R3 model

R3 requirement and improve steps: ·         SP2 and R2 set up ·         Take the snapshot of Site Server if operating as VM or backup the server information. ·         Check the well being standing of website server and confirm the unresolved operational points ·         Install essential updates …