nixCraft

Nilesh · #1 (**permalink**) 01-26-2008, 10:01 PM

Ok, it was me only who asked this question. Now I have found a solution to this.

Let the default MySQL datadir be /var/lib/mysql

Suppose you have a user foo on the system as well as on MySQL. Now how to limit space for foo ?

create a separate directory for databases in foo's home say /home/foo/dbs with ownership mysql:foo and permissions 3755.

Now move all foo's databases from /var/lib/mysql to /home/foo/dbs

Then create symbolic links to the database named folders.

Example there is one foo's db called db1 in /var/lib/mysql/db1

Code:

# mkdir /home/foo/dbs
# mv /var/lib/mysql/db1 /home/foo/dbs/
# chown mysql:foo /home/foo -Rf
# chmod 3755 -Rf /home/foo
# ln -s /var/lib/mysql/db1 /home/foo/dbs/db1 -v

NOTE- I AM NOT RESPONSIBLE FOR ANY DAMAGES OCCURRED & TO TEST THIS TRY RESTARTING mysqld.

if mysqld starts OK then its working else it isn't.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Setting Samba to Bind to an ADS Domain	kevv.mai	Getting started tutorials	0	04-20-2008 01:47 AM
ffmpeg php tutorial	anjanesh	Getting started tutorials	3	02-23-2007 12:26 PM
Help in setting up an email server and net gateway	ricc	Mail Servers	2	01-04-2007 09:33 AM
Configuring disk quotas on Fedora Linux	chimu	Linux software	2	12-26-2006 10:18 AM
Ubuntu Linux: How do I setup print quotas?	cityblogger	Linux software	1	07-06-2006 05:11 PM

nixCraft

Tutorial: Setting up MySQL quotas for users (MyISAM)

Tutorial: Setting up MySQL quotas for users (MyISAM)

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Similar Threads