NYCPHP Meetup

[nycphp-talk] ism tables.

Jon Baer jonbaer at jonbaer.com
Mon Jan 8 00:37:58 EST 2007


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




More information about the talk mailing list