mysql

Developing web application with PHP-MySql-Apache in Ubuntu Linux

I have started using Ubuntu 8.04 in few days ago and found it Great. So, now I’ve moved my development environment from windows and working in Ubuntu. Here I am just explaining what steps I had to take for this jump. Also have a listing of some development related softwares/tools which I am using as replacement of windows applications.

Using MySQL as a filesystem

With MySQLfs you can store a filesystem inside a MySQL relational database. MySQLfs breaks up the byte content of files that you store in its filesystem into tuples in the database, which allows you to store large files in the filesystem without requiring the database to support extremely large BLOB fields. With MySQLfs you can throw a filesystem into a MySQL database and take advantage of whatever database backup, clustering, and replication setup you have to protect your MySQLfs filesystem.

Apache, MySQL & PHP on Ubuntu

Lately I've been performing lots of fresh system installs, a result of testing my Ubuntu respin. Restoring my personal data after such an install is simple enough, but having to reinstall my Apache, MySQL & PHP set-up requires a little more effort. So, for future reference I've decided to record the process. By following the instructions below I should be able to get my development server up and running within minutes.

How To Reset the MySQL Password : Ubuntu 7.10

I found myself toying with one of my test servers the other nite and realized that I didn’t know what the root password was for my MySQL database.  After a quick bit of Google searching I found a very easy solution.

mytop: a top clone for MySQL

Ever wondered “what the hell is that mysql server doing”? Search no longer, My top is the answer. Mytop is a clone of top, a utility every sysadmin knows about, but instead of monitoring the system, it follows MySQL threads. In a nutshell, it’s a nifty command line tool that will connect to a MySql server and periodically run the SHOW PROCESSLIST and SHOW STATUS commands. It will then provide nice summaries of the results, and let the user apply various filters.

How to install MySQL on Ubuntu/Debian

It may seem easy for some, but for others, installing MySQL on Ubuntu or Debian Linux is not an easy task. This article explains to you how to install the MySQL Server and Client packages on a Ubuntu/Debian system.

How To Install A Complete LEMP (Linux - EngineX (Nginx HTTP SERVER) - Mysql - PHP) Server (Not LAMP...) On Ubuntu/Debian

This HowTo will describe the setup of an efficient http server and mail server for small or medium configurations (as low as 96 mb). So this config is ideal for a small VPS. You can find a good choice of cheap and performant VPS (XEN) at x|encon, a german hosting company. they provide many scalable VPS solutions with pre-installed Debian and Ubuntu disc images.

Why LEMP instead of LAMP? NGINX is a great replacement for Apache with very low memory footprint and great stability.

Syndicate content