One of Perl’s strength is it’s repository of modules, thousands of modules. No need to re-invent the wheel, just think of what you wanna do and search for it (http://cpan.perl.org).
The CPAN modules are available through the CPAN shell. In this post, we will talk briefly about how to install the CPAN shell and show an [...]
Category Archives: MySQL
Perl – How to install Perl module using CPAN shell
Comments (1)
MySQL – Passwordless login within bash script
As like the previous post about passwordless login within Bash script, this post is about how to connect to MySQL database server using Bash script without MySQL client prompting for login.
Here it is :
MySQL – Common commands of database user account management
SQL database are used to store various kind of data in order for future retrieval. But data stored in SQL database is not only for future retrieval, it is also stored in such a way for faster (repeated) retrieval, structured manner in data organization, interchangeable between applications and most importantly, it provides a mean to [...]
mysql server – how to reduce disk space by moving mysql-bin.00000
One fine day, the server disk usage report that, the one of the partitions is almost full. After some searching, the database directory at /var/db/mysql/ (FreeBSD) or /var/lib/mysql/ (Linux) is occupying most disk space. Listing the directory only to found out that mysql-bin.0000* are the ones that is occupying the disk space. What are these [...]
