Previous Thread
Next Thread
Print Thread
Hop To
#140026 02/18/2004 1:07 AM
Joined: Jan 2004
Posts: 56
P
journeyman
journeyman
P Offline
Joined: Jan 2004
Posts: 56
I was reading in the MySql reference manual about these table types and the manual had suggested moving towards MyISAM Tables since ISAM Tables would soon no longer be supported in MySQL. I am wondering if this will become an issue as MySQL 4.x becomes more common. My question is will Threads be moving towards a MYISAM solution in the near future? I have already experience some frustration when trying to integrate threads with other software products that are using MYISAM tables for user data (Threads is using ISAM as far as I can tell this Table type has not changed)

If the Table type were changed to MyIsam what sort of issues would this raise?

Thanks If I am way out on this subject Please feel free to let me know <img src="https://www.ubbcentral.com/boards/images/graemlins/smile.gif" alt="" />

#140027 02/18/2004 1:11 AM
Joined: Jun 2006
Posts: 742
enthusiast
enthusiast
Joined: Jun 2006
Posts: 742
Any threads I've ever installed or worked on has been MyISAM by default.

I did encounter a forum which was not MyISAM and they had corruption problems and didn't like the command to repair the tables. I changed them to MyISAM.


Joshua Pettit
Web Developer
www.ThreadsDev.net | www.JoshuaPettit.com
#140028 02/18/2004 1:14 AM
Joined: Jan 2004
Posts: 56
P
journeyman
journeyman
P Offline
Joined: Jan 2004
Posts: 56
So do all the tables normally get created as MyISAM? I have been using threads since about 1999 and have moved between a couple different Hosts. I am not sure what there default table creation Schema was in MySQL.

#140029 02/18/2004 1:16 AM
Joined: Jun 2006
Posts: 742
enthusiast
enthusiast
Joined: Jun 2006
Posts: 742
Yeah as far as my experience goes, any new install is MyISAM.

I'm not real familar with the differences between them though. But maybe yours never got changed? <img src="https://www.ubbcentral.com/boards/images/graemlins/confused.gif" alt="" />


Joshua Pettit
Web Developer
www.ThreadsDev.net | www.JoshuaPettit.com
#140030 02/18/2004 2:16 AM
Joined: Jan 2004
Posts: 56
P
journeyman
journeyman
P Offline
Joined: Jan 2004
Posts: 56
ok I changed those table types using phpmyadmin and it seems to have worked just find without any errors. I am hoping that some of the structure of the tables has not been corrupted since I have been using these tables in there current state for over a year without any apparent errors. I think I may install a test copy of Threads on my test site and check for any differences between table structure.

Thanks once again Josh for the insight Hopefully this will alleviate the problems with integration I was having.


Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
spam issues
by ECNet - 03/19/2024 11:45 PM
Looking for a forum
by azr - 03/15/2024 11:26 PM
Editing Links in Post
by Outdoorking - 03/15/2024 9:31 AM
Question on barkrowler and the like
by Mors - 02/29/2024 6:51 PM
Member Permissions Help
by domspeak - 02/27/2024 6:31 PM
Who's Online Now
0 members (), 744 guests, and 147 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20230217)