Transfer DBs from mysql 4 to 5

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

vchris
Forum Contributor
Posts: 204
Joined: Tue Aug 30, 2005 7:53 pm
Location: Canada, Quebec

Post by vchris »

Error code is 1016 (HY000): Can't open file: 'contactlist.ibd' (errno:1)

I was reading on the net that this means the tables crashed and they say to do repair table which I did and it doesn't work.

worst case I guess I can do a system restore.
User avatar
RobertGonzalez
Site Administrator
Posts: 14293
Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA

Post by RobertGonzalez »

If you can restore, do that and then do a SQL dump of ALL (except the core mysql databases) of your databases. Uninstall 4 (or leave it there) and Install 5 and load the data using the dump file. Clean, safe, easy.
vchris
Forum Contributor
Posts: 204
Joined: Tue Aug 30, 2005 7:53 pm
Location: Canada, Quebec

Post by vchris »

I may have found an easier way. The database I need is online on a web server. I could just backup that DB instead.

How can I import a .sql db???
vchris
Forum Contributor
Posts: 204
Joined: Tue Aug 30, 2005 7:53 pm
Location: Canada, Quebec

Post by vchris »

Forget it guys I got it!!!!!!!!!!!!

Thank god!

I used source filename. got it all rebuilt :D

wooohoooo!
Post Reply