Hi all When i try to run mysqld_safe cmd, it fails saying : Starting mysqld daemon with databases from /var/lib/mysql STOPPING server from pid file /var/run/mysqld/mysqld.pid 070105 20:23:40 mysqld ended
Also mysqld.pid does not exist at the given path! Any Idea what to do??? mysql_install_db is running fine as well. Contents of mysqld.log are : 070105 20:23:40 mysqld started InnoDB: Error: auto-extending data file ./ibdata1 is of a different size InnoDB: 0 pages (rounded down to MB) than specified in the .cnf file: InnoDB: initial 640 pages, max 0 (relevant if non-zero) pages! InnoDB: Could not open or create data files. InnoDB: If you tried to add new data files, and it failed here, InnoDB: you should now edit innodb_data_file_path in my.cnf back InnoDB: to what it was, and remove the new ibdata files InnoDB created InnoDB: in this failed attempt. InnoDB only wrote those files full of InnoDB: zeros, but did not yet use them in any way. But be careful: do not InnoDB: remove old data files which contain your precious data! 070105 20:23:40 [ERROR] Can't init databases 070105 20:23:40 [ERROR] Aborting 070105 20:23:40 [Note] /usr/libexec/mysqld: Shutdown complete 070105 20:23:40 mysqld ended When i tried to see the shell script running, i get the following msg: sh -x bin/mysqld_safe --user=root + KILL_MYSQLD=1 + trap '' 1 2 3 15 + umask 007 + defaults= + case "$1" in ++ pwd + MY_PWD=/usr + test -d /usr/data/mysql -a -f ./share/mysql/english/errmsg.sys -a -x ./bin/mysqld + test -f ./var/mysql/db.frm -a -f ./share/mysql/english/errmsg.sys -a -x ./libexec/mysqld + MY_BASEDIR_VERSION=/usr + DATADIR=/var/lib/mysql + ledir=/usr/libexec + user=mysql + niceness=0 + test -x /usr/libexec/mysqld-max + MYSQLD=mysqld + pid_file= + err_log= + test -x ./bin/my_print_defaults + print_defaults=./bin/my_print_defaults + args= + SET_USER=2 ++ ./bin/my_print_defaults --loose-verbose mysqld server + parse_arguments --datadir=/var/lib/mysql --socket=/var/lib/mysql/mysql.sock --old_passwords=1 + pick_args= + test --datadir=/var/lib/mysql = PICK-ARGS-FROM-ARGV + for arg in '"$@"' + case "$arg" in ++ echo --datadir=/var/lib/mysql ++ sed -e 's;--datadir=;;' + DATADIR=/var/lib/mysql + for arg in '"$@"' + case "$arg" in ++ echo --socket=/var/lib/mysql/mysql.sock ++ sed -e 's;--socket=;;' + mysql_unix_port=/var/lib/mysql/mysql.sock + for arg in '"$@"' + case "$arg" in + test -n '' + test 2 -eq 2 + SET_USER=0 ++ ./bin/my_print_defaults --loose-verbose mysqld_safe safe_mysqld + parse_arguments --err-log=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid + pick_args= + test --err-log=/var/log/mysqld.log = PICK-ARGS-FROM-ARGV + for arg in '"$@"' + case "$arg" in ++ echo --err-log=/var/log/mysqld.log ++ sed -e 's;--err-log=;;' + err_log=/var/log/mysqld.log + for arg in '"$@"' + case "$arg" in ++ echo --pid-file=/var/run/mysqld/mysqld.pid ++ sed -e 's;--pid-file=;;' + pid_file=/var/run/mysqld/mysqld.pid + parse_arguments PICK-ARGS-FROM-ARGV --user=root + pick_args= + test PICK-ARGS-FROM-ARGV = PICK-ARGS-FROM-ARGV + pick_args=1 + shift + for arg in '"$@"' + case "$arg" in ++ echo --user=root ++ sed -e 's;--[^=]*=;;' + user=root + SET_USER=1 + safe_mysql_unix_port=/var/lib/mysql/mysql.sock + test '!' -x /usr/libexec/mysqld + test -z /var/run/mysqld/mysqld.pid + case "$pid_file" in + test -z /var/log/mysqld.log + test -n /var/lib/mysql/mysql.sock + args='--socket=/var/lib/mysql/mysql.sock ' + test -n '' + test 0 -eq 0 + NOHUP_NICENESS=nohup + nohup nice ++ nice + normal_niceness=0 ++ nohup nice + nohup_niceness=0 + numeric_nice_values=1 + for val in '$normal_niceness' '$nohup_niceness' + case "$val" in + for val in '$normal_niceness' '$nohup_niceness' + case "$val" in + test 1 -eq 1 + nice_value_diff=0 + test 1 -eq 0 + USER_OPTION= + test -w / -o root = root + test root '!=' root -o 1 = 1 + USER_OPTION=--user=root + touch /var/log/mysqld.log + chown root /var/log/mysqld.log + test -n '' + test -n '' + test -f /var/run/mysqld/mysqld.pid + echo 'Starting mysqld daemon with databases from /var/lib/mysql' Starting mysqld daemon with databases from /var/lib/mysql ++ date '+%y%m%d %H:%M:%S mysqld started' + echo '070105 20:22:45 mysqld started' + true + rm -f /var/lib/mysql/mysql.sock /var/run/mysqld/mysqld.pid + test -z '--socket=/var/lib/mysql/mysql.sock ' + eval 'nohup /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=root --pid-file=/var/run/mysqld/mysqld.pid --skip-locking --socket=/var/lib/mysql/mysql.sock >> /var/log/mysqld.log 2>&1' ++ nohup /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=root --pid-file=/var/run/mysqld/mysqld.pid --skip-locking --socket=/var/lib/mysql/mysql.sock + test '!' -f /var/run/mysqld/mysqld.pid + echo 'STOPPING server from pid file /var/run/mysqld/mysqld.pid' STOPPING server from pid file /var/run/mysqld/mysqld.pid + break ++ date '+%y%m%d %H:%M:%S' + echo '070105 20:22:45 mysqld ended' + tee -a /var/log/mysqld.log 070105 20:22:45 mysqld ended + echo '' + tee -a /var/log/mysqld.log -- Bye for now, Nishant God Gave Me Nothing I Wanted, He Gave Me Everything I Needed !
