Restore InnoDB data - MySQL Database

Lazy70

Hi to everyone,

Ihave a hard problem to resolve.

In my Mysql database there is sometihng that doesn't work.
With MySQLFront I have all my InnoDB tables with this comment:
"Can't open file: 'certificatetyp e.InnnoDB'. (errno: 1)"

and in my loog files I read:

031215 15:33:53 InnoDB error:
Cannot find table test/certificatetype from the internal data
dictionary
of InnoDB though the .frm file for the table exists. Maybe you
have deleted and recreated InnoDB data files but have forgotten
to delete the corresponding .frm files of InnoDB tables, or you
have moved .frm files to another database?
Look from section 15.1 of http://www.innodb.com/ibman.html
how you can resolve the problem.

I have read the 15.1 section and I try to delete .frm files, but I can
not be able to see all the tables :(

Any body have some tip?

Thank you
Ktrl+S

Jul 19 '05 #1

Subscribe Reply

12094

Heikki Tuuri

Please look at my reply from http://lists.mysql.com/list.php?list=win32#b

"Lazy70" <s.**********@k atamail.com> kirjoitti viestissä
news:d0******** *************** ***@posting.goo gle.com...

Hi to everyone,

Ihave a hard problem to resolve.

In my Mysql database there is sometihng that doesn't work.
With MySQLFront I have all my InnoDB tables with this comment:
"Can't open file: 'certificatetyp e.InnnoDB'. (errno: 1)"

and in my loog files I read:

031215 15:33:53 InnoDB error:
Cannot find table test/certificatetype from the internal data
dictionary
of InnoDB though the .frm file for the table exists. Maybe you
have deleted and recreated InnoDB data files but have forgotten
to delete the corresponding .frm files of InnoDB tables, or you
have moved .frm files to another database?
Look from section 15.1 of http://www.innodb.com/ibman.html
how you can resolve the problem.

I have read the 15.1 section and I try to delete .frm files, but I can
not be able to see all the tables :(

Any body have some tip?

Thank you
Ktrl+S

Jul 19 '05 #2

Heikki Tuuri

Please look at my reply from http://lists.mysql.com/list.php?list=win32#b

"Lazy70" <s.**********@k atamail.com> kirjoitti viestissä
news:d0******** *************** ***@posting.goo gle.com...

Hi to everyone,

Ihave a hard problem to resolve.

In my Mysql database there is sometihng that doesn't work.
With MySQLFront I have all my InnoDB tables with this comment:
"Can't open file: 'certificatetyp e.InnnoDB'. (errno: 1)"

and in my loog files I read:

031215 15:33:53 InnoDB error:
Cannot find table test/certificatetype from the internal data
dictionary
of InnoDB though the .frm file for the table exists. Maybe you
have deleted and recreated InnoDB data files but have forgotten
to delete the corresponding .frm files of InnoDB tables, or you
have moved .frm files to another database?
Look from section 15.1 of http://www.innodb.com/ibman.html
how you can resolve the problem.

I have read the 15.1 section and I try to delete .frm files, but I can
not be able to see all the tables :(

Any body have some tip?

Thank you
Ktrl+S

Jul 19 '05 #3

Similar topics

2164

InnoDB data file is growing

by: Asif Iqbal | last post by:

My ibdata1 file is growing. Do I need to worry about that ? I am guessing it will automatically delete old data to fit the size, correct ? Also how do I limit the growth size. I tried to put max:2000M , but since my Innodb is crashing and can't restart mysql I removed the whole my.cnf file all together to fix the crash. So now I am not sure how I can prevent the growth of InnoDB. I looked through the InnoDB website but I don't see it...

MySQL Database

710

Restore InnoDB data

by: Lazy70 | last post by:

MySQL Database

1200

Replication and InnoDB

by: Kurt Tragant | last post by:

Hi List, I'd like to setup the following: Server A <-- Server B <-- Server C Data A some of Data A some of Data A Data B Data B Server A should be the master for server B. Server B should get not all but some of the data of server A. Additionally there should be

MySQL Database

2293

Innodb multiple tablespace & unique name

by: Andy | last post by:

I'm using Mysql Max-4.1.4-gamma for Linux. I have a question related to a problem with my database server. If on my db server I have 2 different database, say DB1 & DB2, I create two INNODB tables with the same name (foo), one for each database, how they are stored in the innodb data dictionary ? DB1.foo & DB2.foo or simply foo ? Thank you in advance Andrea

MySQL Database

11422

InnoDB backup and restore

by: Reuben Pearse | last post by:

Hi all, I've just converted the tables in a big database (approx 27 million records) from MyISAM to InnoDB. When I was using MyISAM I backed up the database by stopping MySQL and then copying the MYI, MYD, frm files in the database directory, and restored the database in the same way. Is there a similar way to backup and restore InnoDB tables, or do I have to use the InnoDB Hot Backup tool?

MySQL Database

3813

backup/restore nTs data

by: Hardy | last post by:

hi gurus, now I have to backup and restore a 8 T size db2 database. from two s85 to two 670. the partitions,tablespaces of the db should be redesigned then I plan to use redirected restore. but my concern is, such big size db, I'm afraid something unexpected will destory all the effort. Who have related experience? Can you give some advice? Thanks in advance:)

DB2 Database

1770

Restore added data in Data Grid in a Page When the page is reloaded

by: krian | last post by:

Hi, I need a help from anybody. My problem is here I wrote two WebApplication in ASP.net Using C#. The name of the applications are (Journal.aspx and Payment.aspx). These Two pages have DataGrids in each page and links to the other page(Journal.aspx contain Payment.aspx link and Payment.aspx contain Journal.aspx link) Suppose we added (updated) data in the DataGrid which is in "Journal.aspx" page and clicked the link which in the page....

ASP.NET

1034

compare mdf for success restore of data and file storage

by: Ram | last post by:

Gurus, I have a scenario where in if i restore a database file(mdf) onto say some AppManager,i want to make sure its restored properly comparing with the mdf that it came from(i take this as base).i hope iam making sense here. Can i do this programmaticaly. Any ideas are really appreciated. Thanks

ASP.NET

1534

Database Restore / MySQL 4.1 -- InnoDB

by: aangeliceus | last post by:

Hello. I have got a MySQL 4.1 that we use wit vBulletin.... We had a crash last week and I've been able to restore the data up to September 2005 as it stands. Now, I'm under the impression I could rebuild the data from the logs but I cannot seem to figure out how to do that based on the tools and instructions posted.

MySQL Database

4324

Restore database from v7.2 to v8.2

by: chow.justy | last post by:

Dear all, I'm a new beginner of DB2. I face 2 question during restore the data. I have 2 DB2 servers on my company. Server A is running on V7.2 and Server B is running on v8.2 (Enterprise Server). I backup a database from Server A and restore it on Server B. Question 1) "SQL2542N database name is not match on the source file" error

DB2 Database

9589

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

9994

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

9863

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

8870

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

6673

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

5298

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

5447

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

3561

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2815

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General