Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - MySQL tables upgrade from 7.91 to 8.05a
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

MySQL tables upgrade from 7.91 to 8.05a
 Post Reply Post Reply
Author
  Topic Search Topic Search  Topic Options Topic Options
RAVALON View Drop Down
Groupie
Groupie
Avatar

Joined: 31 December 2003
Location: Italy
Status: Offline
Points: 132 		Post Options Post Options   Thanks (0) Thanks(0)   Quote RAVALON Quote  Post ReplyReply Direct Link To This Post Topic: MySQL tables upgrade from 7.91 to 8.05a
    Posted: 22 March 2007 at 6:41pm

Hello to all

i'm here for somes simple question
 
I want to upgrade my personal mysql version of wwforum to official 8.05a mysql version
 
I know that mysql official version come only with 8.0 version, but in past i made a personal porting on MySQL
 
I taked Access DB of 7.91 versione and i made a functionally conversion on MySQL tables with no one alteration of tables and field type (exception for  data type) .....the forum run perfectly
 
What i have to ask is
 
*) I can see 8.05a version have some tables added respect old version and others tables are deleted....i can see the same thing for somes fields in somes tables that exist again
 
If i add new tables in 8.05a version to my MySQL DB it could run (i cannot lost data)?
May be a problem that i have not data in this new tables ?
For examples, i can see new tables for POLL....if i add this to my DB , the old polls works fine ?
 
I will use this way to update my database to offical versione....tell me please if i wrong...
 
I hope you understand my inperfect englishSleepy
 
 
 
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 23 March 2007 at 7:20am
Probably the simplest way is to download the SQL Server 7 to 8 upgrade tool, and then adapt it to upgrade your current mySQL database.

If you can not adapt it, it should give you a good idea of what changes need to be made to the database.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
RAVALON View Drop Down
Groupie
Groupie
Avatar

Joined: 31 December 2003
Location: Italy
Status: Offline
Points: 132 		Post Options Post Options   Thanks (0) Thanks(0)   Quote RAVALON Quote  Post ReplyReply Direct Link To This Post Posted: 23 March 2007 at 1:27pm
i think is not a big problem, if i upgraded one time from access to mysql myself....
 
what i need to know is what appen if in some tables i have no data..for example in POLL tables....the old poll will run again or may i have problems ?
 
I will try in local how it run....
i'll add new tables and delete the not needed tables i hope don't find many problems, so i'll be in line with official version and  after i'll buy a forum license and stop to problems
 
Thanks to your answer
Back to Top
RAVALON View Drop Down
Groupie
Groupie
Avatar

Joined: 31 December 2003
Location: Italy
Status: Offline
Points: 132 		Post Options Post Options   Thanks (0) Thanks(0)   Quote RAVALON Quote  Post ReplyReply Direct Link To This Post Posted: 27 March 2007 at 1:44pm
hello again
 
i started the conversion of my personal version of MySQL wwforum to Official version 8.05a...my personal version respect structural DB field as was in 7.91 version.
 
I have some question for complete conversion...
 
I see the major structural change in database are in tblTopic table....some filed was added, as "Start_thread_id" , "Last_Thread_id" and "Icon", and some others was changed, as filed date which became "Event_Date"
 
In previus version this field does not exist, so after added to my DB, i made an ASP script which insert in this fileds the correct data
 
No problem for "Start_thread_id" , "Last_Thread_id" , but i have problem to understand "Icon" and "Event_Date", which are new and i don't know which type of data need
 
Have "Event_date" contain  the old "Start_date" or "Last_visit" data (or similar)?
 
What i have to insert in "Icon" field ? Which type of value ?
 
Exist some script which do this automatically ?
 
Why i i cannot access to room ? I have an icon with STOP image...and i don't understand how change it
 
...and the last commercial question...
 
Buing license can i delete the Google ADV ?
 
Thank you for your answer


Edited by RAVALON - 27 March 2007 at 1:45pm
Back to Top
RAVALON View Drop Down
Groupie
Groupie
Avatar

Joined: 31 December 2003
Location: Italy
Status: Offline
Points: 132 		Post Options Post Options   Thanks (0) Thanks(0)   Quote RAVALON Quote  Post ReplyReply Direct Link To This Post Posted: 28 March 2007 at 3:19pm
Borg please help meDisapprove
 
and....another question
 
In boolean field, if i put value 1 for TRUE and not -1 is the same or forum don't work ?


Edited by RAVALON - 28 March 2007 at 3:21pm
Back to Top
RAVALON View Drop Down
Groupie
Groupie
Avatar

Joined: 31 December 2003
Location: Italy
Status: Offline
Points: 132 		Post Options Post Options   Thanks (0) Thanks(0)   Quote RAVALON Quote  Post ReplyReply Direct Link To This Post Posted: 28 March 2007 at 8:27pm
Ok boys....
 
i made some script in ASP to upgrade field where i had problem and now it run !!
 
If someone have difficult to migrate his forum from a personal version could ask me if want
 
Now i ask only if you could confirm i can delete Google adv buying license....
 
thanks to allWink
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.