> If you do 'df -k .' anywhere under your homedir > or 'df -k ~' from anywhere then it'll be showing you > available space for you personally. Ah, thanks, that works great. > It was 50MB blocks w/ 50MB min assigned on the old server > while the space included was 200MB; I don't think it was > ever at 40MB. It was I think 25MB when overall included > space was 100MB. The change to 100MB db block size is > commenserate with the bump to 500MB included overall. OK, I guess I mis-remembered the minimum MySQL size on the old shell. Thanks for confirming the 100MB on new shell. Earlier today I moved /var/mail/rem from the old machine to a file inside my homedir on new machine, and I'm now at 43% (using 219008, available 292992), so I have plenty of elbow room, so I'd like to request a minimal (100MB) database at this time. > Generally each user can request one database at no charge, > and by convention we use the username as the database > name, so it'd be 'rem' in your case. OK. > Multiple apps can share one database as long as they use > disjoint table names. The concept of an app in this context is fuzzy, since each appliation is a whole bunch of different scripts that share one or more tables within the database. I think the main thing is to make sure the various scripts that share a any particular table are written in a consistent way with respect to the columns (fields) within that table. The more interesting problem is synchronizing updates to a table when more than one remote user is using the same application at the same time. Generally MySQL handles that nicely, forcing each update to wait until the previous update has finished. Other than bugs in the scripts, the only interesting problem is a logical update that requires more than one table update to occur with that table locked against all other processes trying to update it simultaneously. This is normally handled by "transactions", where a process requests START TRANSACTION, then does several updates, the either requests COMMIT or ROLLBACK. The free PHP/MySQL providers I've been pracicing on don't support "transactions". They have that **disabled** in their PHP implementation. Does MySQL here have "transactions" enabled or disabled? In case you don't know what I'm talking about: > You just ask when you'd like it setup. Any time now, minimum-size (100MB) MySQL database. After I get it, when I want to connect to it (from PHP most likely, eventually also from CMUCL if I can figure out how), I need to know what host name or IP number and port number, also what user and password, to use in the connection command. $host = "...what..."; $port = "...what..."; $user = "...what..."; $password = "...what..."; $dbLink = mysql_connect($host . ":" . $port, $user, $password); $database = "rem"; $res = @mysql_select_db($database);