[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[cobalt-developers] MySQL problem.



Hey there.

This problem has me completely stumped.  I've just installed MySQL on our
new XTR, which we've migrated over from our old one.

Installing MySQL on the old machine was painless, no problems at all.

However, there seems to be a problem somewhere, as I can't create new
tables.  It appears to have something to do with quota's, but I can't see
any set for the mysql user.

See the following :

Thanks, Ryan.

--

root@quack[/var/lig/mysql]# mysql -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 9 to server version: 3.23.37

Type 'help;' or '\h' for help. Type '\c' to clear the buffer

mysql> CREATE DATABASE festywp;
ERROR 1006: Can't create database 'festywp'. (errno: 122)
mysql> quit
Bye
root@quack[/var/lib/mysql]# perror 122
Error code 122:  Disk quota exceeded
root@quack[/var/lib/mysql]# quota mysql
Disk quotas for user mysql (uid 111):
     Filesystem  blocks   quota   limit   grace   files   quota   limit
grace
       /dev/md4     184*      1       0    none      37       0       0
root@quack[/var/lib/mysql]# df
Filesystem           1k-blocks      Used Available Use% Mounted on
/dev/md1                991896    747064    244832  75% /
/dev/md3                495944     16084    479860   3% /var
/dev/md4              80258700   5984132  74274568   7% /home


--=--

:: Ryan Verner :: xfesty/irc.whackpack.com ::
:: ICQ :: 76626240 ::
:: <festy@xxxxxxxxxxxxx> ::
:: <xfesty@xxxxxxxxxxxxx> ::