Portal Forums Calendar Active Threads
Previous Thread
Next Thread
Print Thread
Hop To
Has anyone got a 6.4.3 threads MySQL DDL ?
#183933 05/07/2007 10:07 AM
Joined: May 2007
Posts: 2
S
stumbo
Offline
stranger
stumbo
stranger
S Offline
Joined: May 2007
Posts: 2
I need to migrate all our UBB sites from OSX to RedHat AS4 this next week. Yes - tight deadlines smile

The OSX filesystem is not case sensitive, and RedHat is. The result is that the table names have the wrong case but have always worked on OSX. These table names are also wrong in the MySQL dumf file being loaded onto RedHat as part of the migration.

Since the code is looking for the correct case tables, it fails.

If someone has a *correct* version 6.4.3 DDL they can let me have I can manaual correct all our table (+?) names.

cheers dan
Re: Has anyone got a 6.4.3 threads MySQL DDL ?
stumbo #183940 05/07/2007 11:41 AM
Joined: Dec 2003
Posts: 1,796
Texas
AllenAyres Offline
Pooh-Bah
AllenAyres
Pooh-Bah
Offline
Joined: Dec 2003
Posts: 1,796
Texas
You might contact support directly, that would be faster/preferred.

- Allen
- ThreadsDev | PraiseCafe
Re: Has anyone got a 6.4.3 threads MySQL DDL ?
AllenAyres #183951 05/07/2007 6:51 PM
Joined: Jun 2006
Posts: 16,299
Likes: 116
Portland, OR; USA
Gizmo Offline
UBB.threads Developer
Gizmo
UBB.threads Developer
Offline
Joined: Jun 2006
Posts: 16,299
Likes: 116
Portland, OR; USA
perhaps writeup a custom query and save it elsewhere and include the nessessary altertable commands for each table and then run it on the various databases

I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: Has anyone got a 6.4.3 threads MySQL DDL ?
Gizmo #183967 05/08/2007 4:11 AM
Joined: May 2007
Posts: 2
S
stumbo
Offline
stranger
stumbo
stranger
S Offline
Joined: May 2007
Posts: 2
Originally Posted by Gizmo
perhaps writeup a custom query and save it elsewhere and include the nessessary altertable commands for each table and then run it on the various databases

Thats my intention - I just need to DDL to be certain of the correct table name case.

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
spam issues
by ECNet - 03/19/2024 11:45 PM
Who's Online Now
0 members (), 1,009 guests, and 174 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
Forum Rules · Mark All Read Contact Us · Forum Help · UBBCentral
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20230217)