Hi. Using mySQL v4.1.9 on Fedora Core 2, I'm suffering a shutdown everyday around 04:30. These are the contents of 'mysqld.log': ---- /usr/sbin/mysqld: ready for connections. Version: '4.1.9-standard-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution 070201 4:29:40 [Note] /usr/sbin/mysqld: Normal shutdown 070201 4:29:43 [ERROR] /usr/sbin/mysqld: Forcing close of thread 25822 user: 'root' 070201 4:29:43 [ERROR] /usr/sbin/mysqld: Forcing close of thread 25808 user: 'root' 070201 04:30:39 mysqld started InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Error in opening ./ibdata1 070201 4:30:42 InnoDB: Operating system error number 11 in a file operation. InnoDB: Error number 11 means 'Resource temporarily unavailable'. InnoDB: Some operating system error numbers are described at InnoDB: http://dev.mysql.com/doc/mysql/en/Operating_System_error_codes.html 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! 070201 4:30:42 [ERROR] Can't init databases 070201 4:30:42 [ERROR] Aborting 070201 4:30:42 [Note] /usr/sbin/mysqld: Shutdown complete 070201 04:30:42 mysqld ended 070201 04:35:21 mysqld ended ----------------------------
At 04:30, my server makes the daily backup, by executing this command: ------ /usr/bin/mysqldump -h localhost -u root -pXXXXX --all-databases > /home/backup/mysql_databases.sql --------------- Can this command damage the mySQL server? Can I improve this command? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
