Debian Admin

I find bash as one of the most fluid languages. Problem is when ever I come accross people that say they know bash but do not use it because they prefere perl or php. They say they use perl or php because of easy database access and how you can split strings. Today I will explain how to split a string in bash, from a stream even, so you don’t have to load whole files. I will use /etc/passwd as an example so you can follow along.
Read the rest of this entry »

Problem: using SWISH++ it is possible to search and sort PDF-files automatically
Solution: tools like pdftotext, find, scripts on Bash or Perl are required to perform quick and fast search within PDF and indexing PDF documents.

Read the rest of this entry »

By default, MySQL Server will be installed with root superuser without any password. You can connect to MySQL server as root without requiring password or by keying in blank password. However, if you have set the password for root and forget or unable to recall the password, then you will need to reset the root password for MySQL.

Read the rest of this entry »

If you want to export your mysql databases into a csv file here is simple tip for you.

Read the rest of this entry »

MySQL is a widely used and fast SQL database server. It is a client/server implementation that consists of a server daemon (mysqld) and many different client programs/libraries.

Read the rest of this entry »

AutoMySQLBackup is a script to take daily, weekly and monthly backups of your MySQL databases using mysqldump. Features – Backup mutiple databases – Single backup file or to a seperate file for each DB – Compress backup files – Backup remote servers – E-mail logs – More

Read the rest of this entry »