On Tue, 4 May 2004 09:46:27 -0400 "Tucker, Gabriel" <[EMAIL PROTECTED]> wrote:
> Hello All: > > I am having a problem with both V4.0.16 and 4.0.18. Let me explain: > > I have a database with two InnoDB tables in v4.0.16. I backup up > this database every night using the following command: > > mysqldump --allow-keywords --host=$HOST --flush-logs > --disable-keys --opt --port=$1 > --socket=/bb/bin/mysql/sockets/mysql.sock.$1 --master-data > --all-databases -u mysql -p > > /bb/bin/mysql/backups/archive_$1.sql > > I went to restore it the other day and I got this error: > > ERROR 1005 at line 20: Can't create table > './fxprmet/cur_reject_tk_sum.frm' (errno: 150) Try looking over the output of SHOW INNODB STATUS; there might be some helpful messages in there. Josh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
