>Description:
I think that when I installed mysql, I ran out of room on the /var file system
>How-To-Repeat:
bash-2.05$ /usr/sbin/mysqld --datadir=/home/mysql
InnoDB: Error: data file ./ibdata1 is of different size
InnoDB: than specified in the .cnf file!
InnoDB: Could not open data files
020630 1:55:08 Can't init databases
bash-2.05$ ls /home/mysql
angel.err ibdata1 mysql mysql.sock test
bash-2.05$ ls /home/mysql_safe --datadir=/home/mysql
ls: unrecognized option `--datadir=/home/mysql'
Try `ls --help' for more information.
bash-2.05$ /usr/bin/mysql_safe --datadir=/home/mysql
bash: /usr/bin/mysql_safe: No such file or directory
bash-2.05$ /usr/bin/mysqld_safe --datadir=/home/mysql
Starting mysqld daemon with databases from /home/mysql
020630 01:56:20 mysqld ended
bash-2.05$
>Fix:
The installation RPM should test that the filesystems have enough free space
before beginning. Is there a switch
to the RPM to force placement of the database on a different file system?
>Submitter-Id: [EMAIL PROTECTED]
>Originator: MySQL server
>Organization:
>MySQL support: none
>Synopsis: mysqld won't start after installation
>Severity: non-critical
>Priority: low
>Category: mysql
>Class: change-request
>Release: mysql-4.0.1-alpha (Official MySQL RPM)
>Environment:
Linux angel 2.4.7-10 #1 Thu Sep 6 17:21:28 EDT 2001 i586 unknown
bash-2.05$ df -hl
Filesystem Size Used Avail Use% Mounted on
/dev/hda4 2.8G 1.6G 1.0G 60% /
/dev/hda1 11M 2.7M 8.1M 25% /boot
none 19M 0 18M 0% /dev/shm
/dev/hda3 95M 70M 20M 78% /var
/dev/hdb1 18G 13G 5.4G 70% /home
/dev/cdrom 595M 596M 0 100% /mnt/cdrom
bash-2.05$ rpm -q redhat-release
redhat-release-7.2-1
System: Linux angel 2.4.7-10 #1 Thu Sep 6 17:21:28 EDT 2001 i586 unknown
Architecture: i586
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs
gcc version 2.96 20000731 (Red Hat Linux 7.1 2.96-98)
Compilation info: CC='gcc' CFLAGS='-O6 -fno-omit-frame-pointer -mpentium' CXX='gcc'
CXXFLAGS='-O6 -fno-omit-frame-pointer -felide-constructors
-fno-exceptions -fno-rtti -mpentium' LDFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 13 Dec 16 2001 /lib/libc.so.6 -> libc-2.2.4.so
-rwxr-xr-x 1 root root 5716491 Sep 4 2001 /lib/libc-2.2.4.so
-rw-r--r-- 1 root root 27304836 Sep 4 2001 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Sep 4 2001 /usr/lib/libc.so
Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static
--with-client-ldflags=-all-static --without-berkeley-db --with-innodb
--enable-assembler --with-mysqld-user=mysql
--with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/
--with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin
--sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql
--infodir=/usr/info --includedir=/usr/include --mandir=/usr/man --with-embedded-server
--enable-thread-safe-client '--with-comment=Official MySQL RPM'
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
