This job can be done in many ways like dumping all databases and replacing myisam with innodb in all created tables. However this solution can take very long time.

The simplest way is to use maatkit package. I will show you how to convert your MySQL databases from MyISAM to InnoDB using maatkit:

Step1. Install maatkit package:

apt-get install maatkit

Step2. Now we need to find a list with all your databases. You can do that using the following command:

mysql -u root --password=your_password --skip-column-names -e "show databases;" > databases.list

Step3. Now convert all your MySQL databases from MyISAM to InnoDB

for databases in `cat databases.list`; do /usr/bin/mk-find $databases --engine MyISAM --exec "ALTER TABLE %D.%N ENGINE=INNODB" --print; done

This command will extract all database names from databases.list file and send that name to mk-find  which is executing ”ALTER TABLE” command on all of its tables to convert their storage engine from MyISAM to InnoDB.

Enjoy!

In this post I will show you how to manage your VE memory on OpenVZ VPS.

Here are some example commands that will help you to adjust the RAM for  OpenVZ:

256MB Guaranteed, 512MB Burstable
vzctl set 101 --vmguarpages 256M --save
vzctl set 101 --oomguarpages 256M --save
vzctl set 101 --privvmpages 256M:512M --save

512MB Guaranteed, 1024MB Burstable
vzctl set 101 --vmguarpages 512M --save
vzctl set 101 --oomguarpages 512M --save
vzctl set 101 --privvmpages 512M:1024M --save

1024MB Guaranteed, 2048MB Burstable
vzctl set 101 --vmguarpages 1024M --save
vzctl set 101 --oomguarpages 1024M --save
vzctl set 101 --privvmpages 1024M:2048M --save

NOTE: 101 is your VPS veid.

This article is about setting up Nginx + PHP-FastCGI on Debian 6.0.6 Squeeze

Step1. Install nginx and php5-cgi :

apt-get install nginx php5-cgi

Step2. Replace Nginx default virtualhosts config with the following content:

server {
listen [::]:80;
server_name debian-tutorials.com;
root /var/www/debian-tutorials.com;
index index.html index.htm index.php;
access_log /var/log/debian-tutorials.com.access.log;

location ~ \.php$ {
try_files $uri =404;
fastcgi_pass unix:/tmp/php.socket;
fastcgi_index index.php;
fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
include fastcgi_params;
}
}

NOTE: Replace debian-tutorials.com with your own domain.

Step3. Create a  Debian init script to control the php-cgi daemon.

Continue Reading…

If you want to set-up an mail server in Debian Linux using Postfix and SquirrelMail you need to follow the next guide:

Step1.  Install Postfix:

apt-get install postfix

This command will remove sendmail. Sendmail is installed by default on Debian.

Step2. Configure Postfix:

Open the file /etc/postfix/main.cf with your favorite editor and uncomment or add the followins:

inet_interfaces = all
mydestination = $myhostname, localhost.$mydomain, localhost, $mydomain
home_mailbox = Maildir/

Step3. Restart and test if Postfix is working:

/etc/init.d/postfix restart

Continue Reading…

Hello, In this tutorial I will show you how to install theese tools in Debian Squeeze.

Step1. Install Apache2 PHP5 Postgresql and phppgadmin

apt-get update && apt-get install apache2 libapache2-mod-php5 php5 postgresql-8.4 phppgadmin

This command will update the repositories and install all the dependencies.

The following extra packages will be installed:
apache2-mpm-prefork apache2-utils apache2.2-bin apache2.2-common file libapr1 libaprutil1 libaprutil1-dbd-sqlite3 libaprutil1-ldap
libcap2 libdb4.7 libexpat1 libmagic1 libonig2 libpcre3 libpq5 libqdbm14 libxml2 lsb-release mime-support openssl perl perl-modules
php5-cli php5-common php5-pgsql php5-suhosin postgresql-client-8.4 postgresql-client-common postgresql-common postgresql-doc
postgresql-doc-8.4 python python-minimal python-support python2.6 python2.6-minimal sgml-base ssl-cert ucf xml-core
Suggested packages:
www-browser apache2-doc apache2-suexec apache2-suexec-custom php-pear lsb ca-certificates perl-doc libterm-readline-gnu-perl
libterm-readline-perl-perl make postgresql slony1-bin oidentd ident-server python-doc python-tk python-profiler python2.6-doc
python2.6-profiler binutils binfmt-support sgml-base-doc openssl-blacklist debhelper
The following NEW packages will be installed:
apache2 apache2-mpm-prefork apache2-utils apache2.2-bin apache2.2-common file libapache2-mod-php5 libapr1 libaprutil1
libaprutil1-dbd-sqlite3 libaprutil1-ldap libcap2 libdb4.7 libexpat1 libmagic1 libonig2 libpcre3 libpq5 libqdbm14 libxml2
lsb-release mime-support openssl perl perl-modules php5 php5-cli php5-common php5-pgsql php5-suhosin phppgadmin postgresql-8.4
postgresql-client-8.4 postgresql-client-common postgresql-common postgresql-doc postgresql-doc-8.4 python python-minimal
python-support python2.6 python2.6-minimal sgml-base ssl-cert ucf xml-core
0 upgraded, 46 newly installed, 0 to remove and 0 not upgraded.

 

Step2. Configure  PostgresSQL.

Continue Reading…

Page 10 of 44« First...6789101112131415...3040...Last »