how to increase my mysql databse server partitioned in /var/lib/mysql
using putty??
my server is linux open suse.
can i have a step by step procedure??thnks.

If your partition runs out of space you have to increase it. This has nothing to do with mysql.
You can move the mysql data to a larger partition in 4 steps:
1) stop the mysql daemon
2) move the data directory (default /var/lib/mysql, look in my.cnf) to another directory on a larger partition
3) change the datadir entry in my.cnf
4) restart mysqld

If your partition runs out of space you have to increase it. This has nothing to do with mysql.
You can move the mysql data to a larger partition in 4 steps:
1) stop the mysql daemon
2) move the data directory (default /var/lib/mysql, look in my.cnf) to another directory on a larger partition
3) change the datadir entry in my.cnf
4) restart mysqld

hey smantscheff!
thanks for the reply.
can you guide me all through the steps??
sorry im new here. :-)

im using putty. thanks..

No I can't. If you don't understand the 4 steps you should first learn about the linux OS, how daemons/services work, how you modify partitions etc.