Debian Admin

Debian/Ubuntu Linux System Administration Tutorials,Howtos,Tips

  • RSS Subscribe

    subscribe to the Debian Admin RSS feed
  • Sponsors



  • Categories

  • Sponsors

  • Support DebianAdmin

    Amount $:
    Website(Optional):


  • Meta

  • Archives



Archive for the 'Database' Category


Check Your Mysql Server Performance with MySQLTuner

Posted by Admin on 9th November 2008

If you're new here, you may want to subscribe to my RSS feed. Thanks for visiting!

MySQLTuner is a script written in Perl that will assist you with your MySQL configuration and make recommendations for increased performance and stability. Within seconds, it will display statistics about your MySQL installation and the areas where it can be improved.
Read the rest of this entry »

Share/Save/Bookmark

Posted in Database | 4 Comments »

Quick PDF sorting and searching: SWISH++

Posted by gsri11 on 15th November 2007

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 »

Share/Save/Bookmark

Posted in Database, General | 4 Comments »

Recover MySQL Database root password

Posted by Admin on 7th April 2007

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 »

Share/Save/Bookmark

Posted in Database | 2 Comments »

Export Mysql Database into a CSV File

Posted by Admin on 6th February 2007

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

Read the rest of this entry »

Share/Save/Bookmark

Posted in Database | 4 Comments »

Top 84 MySQL Performance Tips

Posted by Admin on 18th November 2006

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 »

Share/Save/Bookmark

Posted in Database | No Comments »

Mysql Database backup using AutoMySQLBackup

Posted by Admin on 11th September 2006

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 »

Share/Save/Bookmark

Posted in Database | 3 Comments »