CONTENTS: About this Tutorial MySQL Administration Working with Tables MySQL Commands vs. Postgres Commands About this Tutorial I’ll be adding to this tutorial in the coming weeks. If you have ideas of things you’d really like to see here, email…

CONTENTS: About this Tutorial MySQL Administration Working with Tables MySQL Commands vs. Postgres Commands About this Tutorial I’ll be adding to this tutorial in the coming weeks. If you have ideas of things you’d really like to see here, email…

How to backup multiple mysql databases ? A very powerful shell script to backup your mysql databases totally free.. enjoy #!/bin/bash NOW=`date +"%Y-%m"`; BACKUPDIR="location/of/your/backup/dir/$NOW"; ### Server Setup ### #* MySQL login user name *# MUSER="user"; #* MySQL login PASSWORD name…

How do I change MySQL root password under Linux, Debian, centos, fedora, suse, mandrake, linux-mint, Ubuntu, FreeBSD, OpenBSD and UNIX like operating system over ssh / telnet session? Setting up mysql password is one of the essential tasks. By default…

Don’t worry if you have forgotten / lost your mysql-server root (administrator) password. You can recover MySQL database server password with following five easy steps. Step # 1: Stop the MySQL server process. Step # 2: Start the MySQL (mysqld)…

By default, MySQL 5.x and above enables MySQL Binary Log. Keeping MySQL Binary Log will take up a lot of disk space for long run. Older MySQL Binary log can be removed in order to keep your hard disk space…

PostgreSQL database server installation and configuration in debian / ubuntu Introduction : PostgreSQL is a fully featured object-relational database management system. It supports a large part of the SQL standard and is designed to be extensible by users in many…