MySQL Workbench is a graphical design tool for MySQL databases. It is used for database server administration, database design, creation, security management and server as well as database maintenance. Install MySQL Workbench on Ubuntu: sk@sk:~$ sudo apt-get install mysql-workbench Add Database Server connection Now open MySQL Workbench from Menu or Dash. The main page of […]
Subversion is a free and open-source version control system (VCS). It manages files and directories, and the changes made to them over time. This allows you to recover older versions of your data or examine the history of how your data changed. Subversion can operate across networks, which allows it to be used by people […]
Pligg is an open-source CMS social publishing software that encourages visitors to register on your website so that they can submit content and connect with other users. It is used to setup your own social publishing community in just minutes. In this article, I use CentOS 6.4 to setup this website. My hostname and IP […]
StatusNet is open-source software used to setup micro-blogging site similar to Twitter. In this article, I use CentOS 6.4 to setup this website. My hostname and IP Address are server.unixmen.com and 192.168.1.200/24, respectively. Change these values as per your setup. Prerequisites Install the following prerequisites to install and configure StatusNet: [root@server ~]# yum install mysql […]
Piwik is an open-source and free alternative to Google Analytics tool. It tracks and displays reports about the location of user visits, Where they came from (i.e website, directly, or something else), the visitors browser, screen size, operating system details, what the visitors did on your website, the time of visits and more. In this […]
This article describes you how to upgrade MySQL to MariaDB in ten simple steps. We have already shown you How to Migrate from MySQL to MariaDB on FreeBSD. I assume that you already have installed MySQL latest version and it’s up and running now.
MySQL replication allows you to have multiple copies of data on many systems and data is automatically copied from one database (Master) to another database (Slave). If one server goes down, the clients still can access the data from another (Slave) server database. In this article, let us see how to configure MySQL Master-Slave replication. […]
Snowlinux 4, code name ‘Frosty’ has been released. It is based upon Ubuntu 13.04 ‘Raring Ringtail’. It has MATE 1.6 (default desktop environment) and Cinnamon 1.8. While MATE 1.6 was mostly improved technically, Cinnamon 1.8 was improved with an unified control center and an own screensaver. Snowlinux 4 “Frosty” uses the latest technologies and has […]