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
Bots
by Outdoorking - 04/13/2024 5:08 PM
Can you add html to language files?
by Baldeagle - 04/07/2024 2:41 PM
Do I need to rebuild my database?
by Baldeagle - 04/07/2024 2:58 AM
This is not a bug, but a suggestion
by Baldeagle - 04/05/2024 11:25 PM
Is UBB.threads still going?
by Aaron101 - 04/01/2022 8:18 AM
Who's Online Now
2 members (Napalm, 1 invisible), 867 guests, and 189 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)