Web Wiz - Green Windows Web Hosting - Celebrating 25 Years!
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - to MySql
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

to MySql
 Post Reply Post Reply
Author
  Topic Search Topic Search  Topic Options Topic Options
wang View Drop Down
Newbie
Newbie
Avatar

Joined: 05 June 2005
Status: Offline
Points: 4 		Post Options Post Options   Thanks (0) Thanks(0)   Quote wang Quote  Post ReplyReply Direct Link To This Post Topic: to MySql
    Posted: 09 June 2005 at 11:57pm
does anyone have txt file to create this tables in MySql?
 
 
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: 10 June 2005 at 3:43am
The present version will not work with mySQL as mySQL doesn't fully support ADO and the SQL used for mySQL is different to that used in Access or SQL Server
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
wang View Drop Down
Newbie
Newbie
Avatar

Joined: 05 June 2005
Status: Offline
Points: 4 		Post Options Post Options   Thanks (0) Thanks(0)   Quote wang Quote  Post ReplyReply Direct Link To This Post Posted: 13 June 2005 at 4:54am
following is the sql for MySql:
 
because read is reserved word, i have to change read to reads in table tblpermission and tblforum.
 
the forum is works with mysql, but some sql string need to be changed inside the programe. i am not good at sql, if anyone done, please give a grant instruction.
 
-----------------------------------------------------------
SET FOREIGN_KEY_CHECKS=0;
use test;
CREATE TABLE tblconfiguration (
  website_name varchar(50) NOT NULL default '',
  forum_name varchar(50) default NULL,
  forum_path varchar(70) default NULL,
  website_path varchar(70) default NULL,
  forum_email_address varchar(50) default NULL,
  email_notify tinyint(4) default NULL,
  mail_component varchar(10) default NULL,
  mail_server varchar(60) default NULL,
  IE_editor tinyint(4) default NULL,
  L_code tinyint(4) default NULL,
  Topics_per_page int(11) default NULL,
  Title_image varchar(70) default NULL,
  Text_link tinyint(4) default NULL,
  Emoticons tinyint(4) default NULL,
  Avatar tinyint(4) default NULL,
  Email_activate tinyint(4) default NULL,
  Email_post tinyint(4) default NULL,
  Hot_views int(11) default NULL,
  Hot_replies int(11) default NULL,
  Private_msg tinyint(4) default NULL,
  No_of_priavte_msg int(11) default NULL,
  Threads_per_page int(11) default NULL,
  Spam_seconds int(11) default NULL,
  Spam_minutes int(11) default NULL,
  Vote_choices int(11) default NULL,
  Email_sys tinyint(4) default NULL,
  Upload_img_path varchar(50) default NULL,
  Upload_img_types varchar(50) default NULL,
  Upload_img_size int(11) default NULL,
  Upload_files_path varchar(50) default NULL,
  Upload_files_type varchar(50) default NULL,
  Upload_files_size int(11) default NULL,
  Upload_avatar tinyint(4) default NULL,
  Upload_avatar_path varchar(50) default NULL,
  Upload_avatar_types varchar(50) default NULL,
  Upload_avatar_size int(11) default NULL,
  Upload_component varchar(10) default NULL,
  Active_users tinyint(4) default NULL,
  Forums_closed tinyint(4) default NULL,
  Show_edit tinyint(4) default NULL,
  Process_time tinyint(4) default NULL,
  Flash tinyint(4) default NULL,
  Show_mod tinyint(4) default NULL,
  Reg_closed tinyint(4) default NULL,
  PRIMARY KEY  (website_name)
)ENGINE=InnoDB DEFAULT CHARSET=latin1;
insert  into tblconfiguration values
 ('My Website', 'Web Wiz Forums', 'http://www.myweb.coo/forum', 'http://www.webwizforums.com',
 'forum@myweb.coo', 1, 'CDONTS', '', 1, 1, 12, 'forum_images/web_wiz_forums.gif', 1, 1, 1, 0, 1, 40, 10, 1, 25, 10, 15, 9, 6, 1, 'uploads', 'jpg;jpeg;gif;png', 35,
 'uploads', 'zip;rar', 500, 1, 'uploads', 'jpg;jpeg;gif;png', 15, 'AspUpload', 1, 0, 1, 1, 0, 0, 0);

CREATE TABLE tblauthor (
  Author_ID int(11) NOT NULL default '0',
  Group_ID int(11) default NULL,
  Username varchar(30) default NULL,
  Real_name varchar(40) default NULL,
  User_code varchar(50) default NULL,
  Password varchar(50) default NULL,
  Salt varchar(30) default NULL,
  Author_email varchar(75) default NULL,
  Show_email tinyint(4) default NULL,
  Homepage varchar(50) default NULL,
  Location varchar(60) default NULL,
  MSN varchar(75) default NULL,
  Yahoo varchar(75) default NULL,
  ICQ varchar(20) default NULL,
  AIM varchar(75) default NULL,
  Occupation varchar(60) default NULL,
  Interests varchar(160) default NULL,
  DOB datetime default NULL,
  Signature longtext,
  Attach_signature tinyint(4) default NULL,
  No_of_posts int(11) default NULL,
  Join_date datetime default NULL,
  Active tinyint(4) default NULL,
  Avatar varchar(100) default NULL,
  Avatar_title varchar(70) default NULL,
  Last_visit datetime default NULL,
  Time_offset char(1) default NULL,
  Time_offset_hours int(11) default NULL,
  Date_format varchar(10) default NULL,
  Rich_editor tinyint(4) default NULL,
  Reply_notify tinyint(4) default NULL,
  PM_notify tinyint(4) default NULL,
  PRIMARY KEY  (Author_ID),
  KEY fi0 (Group_ID),
  CONSTRAINT tblauthor_ibfk_1 FOREIGN KEY (Group_ID) REFERENCES tblgroup (Group_ID)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
 

insert  into tblauthor values
(1, 1, 'administrator', null, 'administrator2FC73499BAC5A41', 'A85B3E67CFA695D711570FB9822C0CF82871903B', '72964E7', null, 0, null, null, null, null, null,
 null, null, null, null, null, 0, 0, '2003-10-01 19:55:43', 1, null, null, '2003-02-08 15:06:43', '+', 0, 'dd/mm/yy', 1, 0, 0),
(2, 2, 'Guests', null, 'Guest48CEE9Z2849AE95A6', '6734DDD7A6A6C9F4D34945B0C9CF9677F3221EC9', 'E4AC',
 null, 0, null, null, null, null, null, null, null, null, null, null, 0, 0, '2003-10-01 15:24:22', 1, null, null, '2003-01-25 15:24:22', '+', 0, 'dd/mm/yy', 1, 0, 0);
 
CREATE TABLE tblbanlist (
  Ban_ID int(11) NOT NULL default '0',
  IP varchar(30) default NULL,
  Email varchar(60) default NULL,
  PRIMARY KEY  (Ban_ID)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
CREATE TABLE tblbuddylist (
  Address_ID int(11) NOT NULL default '0',
  Author_ID int(11) default NULL,
  Buddy_ID int(11) default NULL,
  Description varchar(35) default NULL,
  Block tinyint(4) default NULL,
  PRIMARY KEY  (Address_ID),
  KEY fi0 (Buddy_ID),
  CONSTRAINT tblbuddylist_ibfk_1 FOREIGN KEY (Buddy_ID) REFERENCES tblauthor (Author_ID)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE tblcategory (
  Cat_ID int(11) NOT NULL default '0',
  Cat_name varchar(51) default NULL,
  Cat_order int(11) default NULL,
  PRIMARY KEY  (Cat_ID)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE tbldatetimeformat (
  Date_format varchar(10) NOT NULL default '',
  Year_format varchar(6) default NULL,
  Seporator varchar(15) default NULL,
  Month1 varchar(15) default NULL,
  Month2 varchar(15) default NULL,
  Month3 varchar(15) default NULL,
  Month4 varchar(15) default NULL,
  Month5 varchar(15) default NULL,
  Month6 varchar(15) default NULL,
  Month7 varchar(15) default NULL,
  Month8 varchar(15) default NULL,
  Month9 varchar(15) default NULL,
  Month10 varchar(15) default NULL,
  Month11 varchar(15) default NULL,
  Month12 varchar(15) default NULL,
  Time_format int(11) default NULL,
  am varchar(6) default NULL,
  pm varchar(6) default NULL,
  PRIMARY KEY  (Date_format)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

insert  into tbldatetimeformat values
('dd/mm/yy', 'long', '?', 'January', 'February', 'March', 'April', 'May', 'June', 'July', 'August', 'September', 'October', 'November', 'December', 12, 'am', 'pm');

CREATE TABLE tblemailnotify (
  Watch_ID int(11) NOT NULL default '0',
  Author_ID int(11) default NULL,
  Forum_ID int(11) default NULL,
  Topic_ID int(11) default NULL,
  PRIMARY KEY  (Watch_ID),
  KEY fi0 (Autho
Back to Top
DoltHeadRapper View Drop Down
Newbie
Newbie


Joined: 20 April 2004
Status: Offline
Points: 4 		Post Options Post Options   Thanks (0) Thanks(0)   Quote DoltHeadRapper Quote  Post ReplyReply Direct Link To This Post Posted: 13 June 2005 at 9:43am
Originally posted by -boRg- -boRg- wrote:

The present version will not work with mySQL as mySQL doesn't fully support ADO and the SQL used for mySQL is different to that used in Access or SQL Server


Do you ever plan to make a version that will run on MySQL right out of the box?
Back to Top
dj air View Drop Down
Senior Member
Senior Member
Avatar

Joined: 05 April 2002
Location: United Kingdom
Status: Offline
Points: 3627 		Post Options Post Options   Thanks (0) Thanks(0)   Quote dj air Quote  Post ReplyReply Direct Link To This Post Posted: 13 June 2005 at 11:05am
please read the thread within the suggestions forum.

it was discussed ages ago and he said no,

then recently with MySQL developments it maybe possible, but if there is ever lickly to be it will be a long time yet, as he want s to finish V8, and he has other commitments.

so you are talking months maybe a year year and a half.. no reall time frame if any.
Back to Top
JJLatWebWiz View Drop Down
Groupie
Groupie
Avatar

Joined: 02 March 2005
Location: United States
Status: Offline
Points: 136 		Post Options Post Options   Thanks (0) Thanks(0)   Quote JJLatWebWiz Quote  Post ReplyReply Direct Link To This Post Posted: 28 July 2005 at 5:26pm
I spent some time converting WWF 7.01 to run on MySQL.  It's not a simple process.  WWF makes extensive use of recordset pages, which of course MySQL does not support.  Simulating the functionality for MySQL is fairly easy, but it has to be applied to almost every file, which means once you're done, all future patches and upgrades will require the same work.  I did it though because I needed better performance than Access and didn't want to pay the premium for a host with MS SQL.
 
Good luck.
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.