Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 271
  • Last Modified:

MySQL cannot create tables / DBs as root!!!

I run mysql on my RedHat system and I have this problem.
when I log onto mysql and try to create a table in one of my DBs:

-bash-2.05b# mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 62 to server version: 3.23.58

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> use test
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed

mysql> CREATE TABLE `eggster` (
`id` int(11) NOT NULL auto_increment,
`number` int(11) NOT NULL default '0',
`type` varchar(60) NOT NULL default '',
`addr` varchar(130) NOT NULL default '',
`city` varchar(130) NOT NULL default '',
`state` varchar(130) NOT NULL default '',
`zip` int(20) NOT NULL default '0',
`phone` bigint(20) default NULL,
`fax` bigint(20) default NULL,
`pphone` bigint(20) default NULL,
`fphone` bigint(20) default NULL,
`manager` varchar(130) default NULL,
`pmanager` varchar(75) default NULL,
`sb` enum('N','Y') NOT NULL default 'N',
`rest` enum('N','Y') NOT NULL default 'N',
`pharm` enum('N','Y') NOT NULL default 'N',
`liq` enum('N','Y') NOT NULL default 'N',
`fuel` enum('N','Y') NOT NULL default 'N',
`atm` enum('N','Y') NOT NULL default 'N',
`bank` enum('N','Y') NOT NULL default 'N',
`hisp` enum('N','Y') NOT NULL default 'N',
`photo` enum('N','Y') NOT NULL default 'N',
`postal` enum('N','Y') NOT NULL default 'N',
`ups` enum('N','Y') NOT NULL default 'N',
`inter` enum('N','Y') NOT NULL default 'N',
`natur` enum('N','Y') NOT NULL default 'N',
`rug` enum('N','Y') NOT NULL default 'N',
`design` enum('N','Y') NOT NULL default 'N',
`dining` enum('N','Y') NOT NULL default 'N',
`vid` enum('N','Y') NOT NULL default 'N',
`wu` enum('N','Y') NOT NULL default 'N',
`cu` enum('N','Y') NOT NULL default 'N',
`parcel` enum('N','Y') NOT NULL default 'N',
`express` enum('N','Y') NOT NULL default 'N',
`hours` text,
`phours` text,
`latitude` decimal(26,20) default NULL,
`longitude` decimal(26,20) default NULL,
`map_direction` enum('N','E','S','W') default 'N',
`map_size` decimal(2,1) default NULL,
PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=39

Error occured at:2006-06-12 21:33:30
Line no.:43
Error Code: 3 - Error writing file './test/eggster.frm' (Errcode: 28)

what is the problem?

0
eggster34
Asked:
eggster34
1 Solution
 
todd_farmerCommented:
Does the account under which the MySQL server is running have the appropriate file permissions to the ./test/ directory?
0
 
eggster34Author Commented:
yes. I found out what the problem is:

-bash-2.05b# df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/md4             1012M  374M  587M  39% /
/dev/md1               99M   26M   69M  27% /boot
/dev/md0               26G  2.1G   23G   9% /home
none                  501M     0  501M   0% /dev/shm
/dev/md5              494M  8.5M  460M   2% /tmp
/dev/md2               51G  2.4G   46G   5% /usr
/dev/md6              494M  487M     0 100% /var
/dev/sdc1             147G   42G   99G  30% /root/snapshot

my /var is %100 full and my mysql DB is in /var.
how can I empty or grow the /var mount? or perhaps move it to one of the larger drives?

-bash-2.05b# fdisk -l

Disk /dev/sda: 163.9 GB, 163928604672 bytes
255 heads, 63 sectors/track, 19929 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

   Device Boot    Start       End    Blocks   Id  System
/dev/sda1             1         4     32098+  de  Dell Utility
/dev/sda2             5      3410  27358695   fd  Linux raid autodetect
/dev/sda3   *      3411      3423    104422+  fd  Linux raid autodetect
/dev/sda4          3424     19929 132584445    f  Win95 Ext'd (LBA)
/dev/sda5          3424     10059  53303638+  fd  Linux raid autodetect
/dev/sda6         10060     10320   2096451   fd  Linux raid autodetect
/dev/sda7         10321     10451   1052226   fd  Linux raid autodetect
/dev/sda8         10452     10516    522081   fd  Linux raid autodetect
/dev/sda9         10517     10581    522081   fd  Linux raid autodetect

Disk /dev/sdb: 163.9 GB, 163928604672 bytes
255 heads, 63 sectors/track, 19929 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

   Device Boot    Start       End    Blocks   Id  System
/dev/sdb1   *         1         4     32098+   b  Win95 FAT32
/dev/sdb2             5      3410  27358695   fd  Linux raid autodetect
/dev/sdb3          3411      3423    104422+  fd  Linux raid autodetect
/dev/sdb4          3424     19929 132584445    f  Win95 Ext'd (LBA)
/dev/sdb5          3424     10059  53303638+  fd  Linux raid autodetect
/dev/sdb6         10060     10320   2096451   fd  Linux raid autodetect
/dev/sdb7         10321     10451   1052226   fd  Linux raid autodetect
/dev/sdb8         10452     10516    522081   fd  Linux raid autodetect
/dev/sdb9         10517     10581    522081   fd  Linux raid autodetect

Disk /dev/sdc: 160.0 GB, 160041885696 bytes
255 heads, 63 sectors/track, 19457 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

   Device Boot    Start       End    Blocks   Id  System
/dev/sdc1             1     19457 156288321   83  Linux

Disk /dev/md0: 28.0 GB, 28015198208 bytes
2 heads, 4 sectors/track, 6839648 cylinders
Units = cylinders of 8 * 512 = 4096 bytes

Disk /dev/md0 doesn't contain a valid partition table

Disk /dev/md1: 106 MB, 106823680 bytes
2 heads, 4 sectors/track, 26080 cylinders
Units = cylinders of 8 * 512 = 4096 bytes

Disk /dev/md1 doesn't contain a valid partition table

Disk /dev/md2: 54.5 GB, 54582837248 bytes
2 heads, 4 sectors/track, 13325888 cylinders
Units = cylinders of 8 * 512 = 4096 bytes

Disk /dev/md2 doesn't contain a valid partition table

Disk /dev/md3: 2146 MB, 2146697216 bytes
2 heads, 4 sectors/track, 524096 cylinders
Units = cylinders of 8 * 512 = 4096 bytes

Disk /dev/md3 doesn't contain a valid partition table

Disk /dev/md4: 1077 MB, 1077411840 bytes
2 heads, 4 sectors/track, 263040 cylinders
Units = cylinders of 8 * 512 = 4096 bytes

Disk /dev/md4 doesn't contain a valid partition table

Disk /dev/md5: 534 MB, 534511616 bytes
2 heads, 4 sectors/track, 130496 cylinders
Units = cylinders of 8 * 512 = 4096 bytes

Disk /dev/md5 doesn't contain a valid partition table

Disk /dev/md6: 534 MB, 534511616 bytes
2 heads, 4 sectors/track, 130496 cylinders
Units = cylinders of 8 * 512 = 4096 bytes

Disk /dev/md6 doesn't contain a valid partition table
-bash-2.05b#

I don't want to move it to sdc1 but any other drive would be ok.

0
 
NetminderCommented:
Closed, 500 points refunded.
Netminder
Site Admin
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now