Re: mysql command to rename database

hi Joffrey, You can manually rename the directory that contains the file for the database you want to rename. Make sure to do this while mysqld is off. So if we wanted to rename database "foo": % cd /usr/local/mysql/data % ls -l drwx-- 2staff512 Sep 28 19:58 mysql/ drwx--

Table corruption results after using "mysqldump --opt"

hi all, I have MySQL 3.23.58 running on Solaris 9 x86, and it's been working fantastically. I recently added this to a crontab: /usr/local/mysql/bin/mysqldump --all-databases --opt -u jklett > /storage/backup/mysql-all-databases.sql 2>&1 And the backup file gets created with the right amou