Guru Of Geeks

MariaDB is a community-developed fork of the MySQL relational database management system intended to remain free under the GNU GPL. You can use the  link  to know more about MariaDB and  it's features. If you want to try MariaDB without losing MySQL, then here is the tutorial for running MariaDB alongside MySQL. Let's start with the steps to install Mariadb along with Mysql Download the latest version (mariadb-10.0.20-linux-i686.tar.gz - as of writing this article) from  here  and extract the files in /opt directory. Create a directory for storing the mariadb data [root@knackforge opt]# mkdir mariadb-data Create symlinks from mariadb-10.0.20-linux-i686 to mariadb [root@knackforge opt]# ln -s mariadb-10.0.20-linux-i686 mariadb [root@knackforge opt]# ls -al total 32 lrwxrwxrwx  1 root       root         26 Jun 24 10:06 mariadb -> mariadb-10.0.20-linux-i686 drwxr-xr-x 12 mariadb    mariadb    4096 Jun 24 10:05 mariadb-10.0.20-linux-i686 drwxr-xr-x  9 mariadb    mariadb    ...

1 – Downloading You can download Jetty from two sources: Eclipse or Codehaus. https://www.eclipse.org/jetty/download.html 2 - Simply uncompress the file to a directory. 3 – Running Jetty Open a terminal. Go to the Jetty installation directory. Enter the following command: $ java -jar start.jar Now open a browser and go to localhost to check if Jetty was installed sucessfully: http://localhost:8080/ ​Deploy Birt Report in Jetty Unzip the BIRT Reports runtime archive. Copy the WebViewerExample folder to the webapps folder of the Tomcat server. Rename the WebViewerExample folder to birt ​ Your BIRT Reports viewer application is accessible at http://localhost:8080/birt/ . ​ ​ ​ ​

Dump your database: mysqldump --compatible=postgresql --default-character-set=utf8 -r databasename.mysql -u root databasename Convert the dump to Postgres syntax using https://github.com/lanyrd/mysql-postgresql-converter : wget https://raw.github.com/lanyrd/mysql-postgresql-converter/master/db_converter.py chmod +rx db_converter.py python db_converter.py databasename.mysql databasename.psql Install postgres: apt-cache search postgres # find the most recent sudo apt-get install postgresql-x.x Create the database and insert the data: sudo -u postgres createdb databasename psql databasename -U postgres -h 127.0.0.1 < databasename.psql