Posts under Open Source

Free FTP Client for Mac OS X / Win XP / Vista

advertisement

Looking for Free FTP client for Mac OS X? Here’s a free FTP Client that support Mac OS X as well as windows (xp and vista). I’ve been webmaster for more than 10 years, tried tons of free FTP client software. From all the FTP client i used, i would say Filezilla FTP client give me the most features i need. I’d recommend the Filezilla Free FTP client.

Filezilla is a free FTP client (actually it’s a Free and open source software).
Below is some of the best feature that this free FTP client support:-

Continue reading Free FTP Client for Mac OS X / Win XP / Vista »

Turn on MySQL query cache to speed up query performance?

advertisement

Many times developers looking for ways to speed up query, in mysql we can enable query cache to speed up query performance. Whenever query cache is enable, it will cache the query in memory and boost query performance.

As we know, speed is always the most important element in developing a website especially for those high traffic database driven website. You can try to turn on query cache to speed up query.

To speed up query, enable the MySQL query cache, before that you need to set few variables in mysql configuration file (usually is my.cnf or my.ini)

Continue reading Turn on MySQL query cache to speed up query performance? »

How to backup MySQL Database in command line with compression

advertisement

For those who looking for way to backup mysql database,
you can use mysqldump to backup mysql database.

Below is the script example to backup mysql database in command line:-

$ mysqldump -h localhost -u username -p database_name > backup_db.sql

If your mysql database is very big, you might want to compress your sql file.
Just use the mysql backup command below and pipe the output to gzip,
then you will get the output as gzip file.

Continue reading How to backup MySQL Database in command line with compression »