You have been subscribed to a public bug: I noticed that the my.cnd points the tmpdir to /tmp, which IMHO might be fatal.
>From the MySQL site: If the MySQL server is acting as a replication slave, you should not set --tmpdir to point to a directory on a memory-based file system or to a directory that is cleared when the server host restarts. A replication slave needs some of its temporary files to survive a machine restart so that it can replicate temporary tables or LOAD DATA INFILE operations. If files in the temporary file directory are lost when the server restarts, replication fails. http://dev.mysql.com/doc/refman/5.0/en/temporary-files.html >From the FHS: /tmp/ Temporary files (see also /var/tmp). Often not preserved between system reboots. http://en.wikipedia.org/wiki/Filesystem_Hierarchy_Standard It might even be, that Ubuntu clears /tmp. Anyhow, /tmp can be considered lost upon system restart - any file that should survive a system restart belong to /var/tmp /var/tmp/ Temporary files to be preserved between reboots. so please consider tmpdir=/var/tmp I dunno if apparmor needs to be adjusted, but I guess I will soon find out... regards Philipp ** Affects: mysql-dfsg-5.0 (Ubuntu) Importance: Undecided Status: New -- MySQL must not use /tmp https://bugs.launchpad.net/bugs/375371 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.0 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
