Hi , I have a problem with the mysql database restore. When I take a backup of a database and try to restore it on a particular server(Production) , I get the following error message.
ERROR 1005 at line 12: Can't create table './CloneTracking/HitPickFileMaster.frm' (errno: 150) But the same works on the development server running on the same machine. The backup is also from one of the databases in the development server. This is the output of the mysqladmin -version for the two servers mysqladmin Ver 8.23 Distrib 3.23.52, for sun-solaris2.9 on sparc Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.52-log Protocol version 10 Connection genomics via TCP/IP TCP port 3307 Uptime: 12 hours 47 min 21 sec Sindhu K. Pillai Database Administrator / Developer Fungal Genomics Concordia University --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php