473,321 Members | 1,916 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,321 software developers and data experts.

cannot restore 3.23.58 db to MySQL 4.0.22-debug

Hello All,

The other day my server running MySQL 3.23.58 got hacked into and we
are migrating to another one. I backed up my databases using two
methods a) Mysqldump and b) copy the DATA folder on my server.

Now, I am trying to restore these databases on my local machine
(running MySQL 4.0.22-debug and Apache 2.0 on IIS 6.0). I have tried
importing the SQL files (mysqldump) and copying the .frm, .myd and .myi
files into the existing DATA folder on my local machine.

In both cases, the database is created and I can see the table
structure. But when I click on most of the tables, I get the following
error:

#1016 - Can't open file: '<table_name>.InnoDB'. (errno: 1)

Can anyone pls throw some light on this issue? Any suggestion will be
greatly appreciated.

- V

Nov 29 '05 #1
1 1968
ma*****@yahoo.com wrote:
I have tried
importing the SQL files (mysqldump) and copying the .frm, .myd and .myi
files into the existing DATA folder on my local machine.
I don't understand -- you did both? One or the other should be the
solution, but not both. Or did you mean that you tried one method of
restoratin, found it didn't work, and then tried the other with the same
result?
In both cases, the database is created and I can see the table
structure. But when I click on most of the tables, I get the following
error:

#1016 - Can't open file: '<table_name>.InnoDB'. (errno: 1) Can anyone pls throw some light on this issue? Any suggestion will be
greatly appreciated.


Similar issues discussed MySQL forums seem to state that this is caused
by mixing MyISAM table files (.frm, .myd, .myi) and InnoDB tables. You
have .frm files for which there is no entry in the InnoDB tablespace file.

I'm guessing that when you restored your mysqldump files, it created the
database using InnoDB tables. Then you put your .frm files in place,
which makes InnoDB think that you want to store the tables in one file
per table, instead of the default configuration of all tables in one
file. Thus it became confused.

You can probably remove the .FRM, .MYD, and .MYI files (from the data
directory, not your originals!) and then restart MySQL. The data is
probably all in <datadirectory>/ibdata1 at this time.

See also
http://dev.mysql.com/doc/refman/5.0/...-datadict.html

Regards,
Bill K.
Nov 29 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: James | last post by:
HI, I'm looking for a script that will allow users/admins to have a one click backup solution for a MYSQL Database.. 'BACK DATABASE' button, click and its done... The a restore option, that...
0
by: Maciej Wiznerowicz | last post by:
Dear Sirs, I can not start MySQL server. More specifically, MySQL was running fine all the time since installation. It stopped working after I used FmPro Migrator to convert some File Maker...
3
by: Mark Adams | last post by:
I am a relative newbie to MySQL. I had a Postfix+Courier+MySQL mail server running for several months. It took me a week or so to get it up and running in September. Now, I did a clean upgrade to...
2
by: Saqib Ali | last post by:
I installed mySQL and have it running.... but I think I made a mistake somewhere along the line...... I believe I did follow the instructions that were provided with the distribution at:...
5
by: MLH | last post by:
I'm supposed to set a password for the MySQL root user. The output of mysql_install_db instructed me to run the following commands... /usr/bin/mysqladmin -u root -h appserver password mynwewpasswd...
1
by: Mike | last post by:
Need some help please. Trying to restore a 7.2 DB from one machine to a newer machine running 8.2. Upon restoring I get: SQL2519N The database was restored, but the restored database was not...
0
by: newman | last post by:
Dear all, I have mysql 4.1.11 on my current server, i need my database restore another server.. (another server mysql version is 4.1.11 same.) And now... I just created new my database to new...
1
by: edfialk | last post by:
Hi all, I'm desperately trying to get a simple mysql connection working in php 4.3.9 and I think I have a doozy for you guys. First of all, I didn't set up ANY of this system, I'm just working...
4
by: Bootstrap Bill | last post by:
I'm looking for a PHP program to backup and restore a mysql database. I'm using Godaddy to host a forum. Their mysql control panel will only restore a database of two megabytes or less. My...
1
by: Nekator | last post by:
Hi everyone. I´ve backuped my MySQL Databases to transport them from Windows to UNIX Server. Backup worked fine, but the restore won´t. It typically get´s the following errors: 090428...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.