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 » Tue Jan 24, 2006 4:59 pm
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.
RobertGonzalez
Site Administrator
Posts: 14293 Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA
Post
by RobertGonzalez » Tue Jan 24, 2006 5:07 pm
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 » Tue Jan 24, 2006 6:13 pm
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 » Tue Jan 24, 2006 6:26 pm
Forget it guys I got it!!!!!!!!!!!!
Thank god!
I used source filename. got it all rebuilt
wooohoooo!