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.
newbie26 0 Light Poster
smantscheff 265 Veteran Poster
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
newbie26 0 Light Poster
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..
smantscheff 265 Veteran Poster
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.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.