If you have blogs or websites, you databases is one the most important thing. Your data will be store on your database, for this case it is MySQL. MySQL is a free database management system (DBMS) and bundled with Linux as LAMP (Linux, Apache, MySQL and PHP). Because it is so important, then you have to regularly backup your data, as disaster recovery steps.Actually to backup MySQL data is not hard. There are many tools provide for free to backup with on single click. But sometimes you … Read more...
[HowTo] Install FTP Server With User Management In Ubuntu
June 5, 2010 • 37 Comments
Linux especially Ubuntu have many FTP server applications. And PureFTPd is one of the most stable and good FTP server application. We can configure PureFTPd to use virtual user stored on MySQL database rather than using system user.This is much more performance and allows to have thousands of ftp users on a single machine. In addition to that I will show the use of quota and upload/download bandwidth limits with this setup. Passwords will be stored encrypted as MD5 strings in the … Read more...
Backup All Your MySQL Database With One Script
June 3, 2010 • 4 Comments
MySQL is a relational database management system (RDMS), and one of the most powerful DBMS. Most of the websites including this blog using MySQL technology behind it. Since it free and it always bundled with the PHP and Linux, often it is called LAMP (Linux, Apache, MySQL, and PHP). If you know a little about programming in PHP, MySQL skill is a must to you to learn.Okay i am not explaining what it MySQL, or what is SQL syntax. Now i just want to share with you a script to backup all the … Read more...
[HowTo] Extract Database Information From Information_schema Table in Mysql
May 28, 2010 • 2 Comments
INFORMATION_SCHEMA provides access to database metadata. Metadata is data about the data, such as the name of a database or table, the data type of a column, or access privileges. Other terms that sometimes are used for this information are data dictionary and system catalog. INFORMATION_SCHEMA is the information database, the place that stores information about all the other databases that the MySQL server maintains. Inside INFORMATION_SCHEMA there are several read-only tables. They are … Read more...
[HowTo] Replace String In Mysql With One Query
April 29, 2010 • 3 Comments
Yesterday i was helping my friend's blog. She want to change her domain and move her hosting server for some reasons. She is using wordpress as her blog engine and of course using mysql as database server. To move wordpress blog to another domain you need to change some configuration on the database file. Especially if the data have the absolute path in url (ex: http://www.willbechange.com/bla/bla/post.html).After examine her database file i found that many of data in wp-options using … Read more...
[HowTo] Install Apache, PHP, MySQL, and PHPMyAdmin on Ubuntu
April 13, 2010 • 31 Comments
After a while i haven't write on my blog. Now i'm ready to start writing again. Probably you notice that i changed my theme. Yes i was busy redesign my theme from the start. Anyway i will tell you the story on the next article.Now i want to show you how to install Ubuntu Karmic Koala 9.10 as a perfect server with Apache, PHP, MySql and Phpmyadmin. Since Ubuntu have a great repositories and the magic application called apt-get then it shouldn't be hard to make Ubuntu as a perfect … Read more...
