Actually after reading your original email all you need to do is a
bulk search/replace and change ...
ALTER TABLE phpbb_users TYPE = MYISAM
to
ALTER TABLE phpbb_users ENGINE = MYISAM
And you are good to go.
- Jon
On Jan 7, 2007, at 11:21 PM, Hans C. Kaspersetz wrote:
Let me be more specific, I am looking for the installer files for
Windows for either MySQL Server 3.23 or MySQL Sever 4.0.x.
Hans
Hans C. Kaspersetz wrote:
Already tried. You need to have two functioning database servers
to use it. It will not read the ism files directly.. If I had a
functioning (3.23 or 4.0) data base server that could read the ism
tables, I would just mysqldump the data out of them. And read the
dump file into 5.0.
If I am mistaken on this belief, please correct me. When I ran
the migration tool it kept asking for a source database server. I
am still seeking resolution to this problem.
If someone has a zip of 3.23 or 4.0 MySQL server, I would
appreciate getting access to that file?
Hans
Jon Baer wrote:
Try the Windows GUI toolset from MySQL and use the Migration
toolkit application. I think that tool was made for those
situations.
http://dev.mysql.com/downloads/gui-tools/5.0.html
- Jon
On Jan 6, 2007, at 11:17 PM, Hans C. Kaspersetz wrote:
I have to recover some data out of old ism mysql tables and I
don't have a version of MySQL which can access those tables. I
also can't seem to find out how to convert those old tables to
myi table format. Does anyone know a tool or have access to the
windows binary install of 3.23 or 4.0 MySQL?
The typical:
ALTER TABLE phpbb_users TYPE = MYISAM
*MySQL said: *Documentation <http://dev.mysql.com/doc/refman/4.1/
en/error-returns.html>
| #1030 - Got error 1 from storage engine
Gives me no results. Any suggestions would be appreciated.
Hans
|
_______________________________________________
New York PHP Community Talk Mailing List
http://lists.nyphp.org/mailman/listinfo/talk
NYPHPCon 2006 Presentations Online
http://www.nyphpcon.com
Show Your Participation in New York PHP
http://www.nyphp.org/show_participation.php
_______________________________________________
New York PHP Community Talk Mailing List
http://lists.nyphp.org/mailman/listinfo/talk
NYPHPCon 2006 Presentations Online
http://www.nyphpcon.com
Show Your Participation in New York PHP
http://www.nyphp.org/show_participation.php