 | View Full Version : mysql database space racker :) 04-22-2001, 07:58 PM how do i give a database space???? i hear by default mysql hasa limit of 200 bytes how do i make it lets say 20mb thank you Žacker Gilby 04-22-2001, 08:14 PM A mysql database has an unlimited amount of space allotted to it (well, as much hard drive space you have). If you want to limit a database to a different amount, I think you need to do something with symbolic links for the database to another place and assign a quota for that. I am not sure eactly how you would go about that. racker :) 04-22-2001, 08:24 PM instructions anyone ???? Žacker vizi 04-22-2001, 11:35 PM I haven't tested this, but you could try this... 1. Create directory owned by xyz 2. setup a quota for xyz 3. move the database files to the xyz folder 4. make symlinks over to the db files in the xyz folder In theory, this would work. One problem though is how mysql will handle itself if it tries to write to the system and be blocked by the quota system. Does it crash or keep going? |