Hello,

I have one MySQL BDD (5.0.22) on my server. I want to backup database
and restore them on my local PC with the WAMP solution (MySQL 5.0.21).
I test with phpMyAdmin, MySQL Administrator and MySQL Migration Tool
and I have every time the same error.


This, is an extract of my schema :

-- phpMyAdmin SQL Dump
-- version 2.8.0.3-Debian-1
-- http://www.phpmyadmin.net
--
-- Serveur: localhost
-- Généré le : Mardi 06 Février 2007 à 00:18
-- Version du serveur: 5.0.22
-- Version de PHP: 5.1.2
--

-- --------------------------------------------------------

--
-- Structure de la table `ibf_conf_settings`
--

CREATE TABLE `ibf_conf_settings` (
`conf_id` int(10) NOT NULL auto_increment,
`conf_title` varchar(255) NOT NULL default '',
`conf_description` text,
`conf_group` smallint(3) NOT NULL default '0',
`conf_type` varchar(255) NOT NULL default '',
`conf_key` varchar(255) NOT NULL default '',
`conf_value` text,
`conf_default` text,
`conf_extra` text,
`conf_evalphp` text,
`conf_protected` tinyint(1) NOT NULL default '0',
`conf_position` smallint(3) NOT NULL default '0',
`conf_start_group` varchar(255) NOT NULL default '',
`conf_end_group` tinyint(1) NOT NULL default '0',
`conf_help_key` varchar(255) NOT NULL default '0',
`conf_add_cache` tinyint(1) NOT NULL default '1',
PRIMARY KEY (`conf_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=295 ;

-- --------------------------------------------------------

--
-- Structure de la table `ibf_ipbwiki_conf`
--

CREATE TABLE `ibf_ipbwiki_conf` (
`conf_id` char(10) NOT NULL,
`conf_value` text,
PRIMARY KEY (`conf_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;





And when I import it, I have this message :
#1005 - Can't create table '.\mediaportal
\ibf_ipbwiki_conf.frm' (errno: 121)

I have this problem on many table. Anybody could help me ?

Thank in advance.
Arno

On 5 Feb 2007 15:20:55 -0800, Arno wrote:
> And when I import it, I have this message :
> #1005 - Can't create table '.\mediaportal
> \ibf_ipbwiki_conf.frm' (errno: 121)
>
> I have this problem on many table. Anybody could help me ?
>

Try dropping the whole database on the restore system and recreating
it. Usually this error seems to appear when the filesystem storage has
been left in an inconsistant state. This might happen if (for example)
someone tries to clear a table by deleting a file or other incorrect
kinds of maintenance. The error mostly relates to attempting to create
something (A table, a contraint, whatever) that one part of the database
thinks doesn't exist, and another part of the database thinks is a
duplicate.

--
Random Wisdom: Let a pizza fresh from the oven stand for several minutes
before cutting; it will reduce the amount of sauce running
out, and help prevent mouth burns.