Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MySql
 How I converted my Access DB to mySQL - A guide
 New Topic  Reply to Topic
 Printer Friendly
Previous Page | Next Page
Author Previous Topic Topic Next Topic
Page: of 6

FourARSEDSheep
Starting Member

37 Posts

Posted - 14 February 2004 :  13:39:23  Show Profile  Send FourARSEDSheep an AOL message  Send FourARSEDSheep an ICQ Message  Send FourARSEDSheep a Yahoo! Message  Reply with Quote
okay i officially hate mysql.

while i was testing my new mysql forum i put it in a test folder, when it was working properly i changed it back to the other folder. this is when things started going wrong.
the main page loaded fine, with all the forums and stuff.. but i couldnt get in to the forums.. it was still trying to use the access database?
so i changed the folders back again and they worked fine again..
then i delete the "forums" folder on the root of my server.. but i could still access it?!

so i deleted everything. then i reuploaded snitz, resent all the data from the access database to the mysql database.

when i loaded it up everything looked fine.. except none of the settings were carried across.. colour schemes.. images.. etc..
it just looked like a default snitz forum with my original data on it..
then i made a post, which worked fine.. then i went back to the forum - where it says how many times the thread has been read it was blank? and every previous post on the forum said "Edited by - on" at the bottom

ive gone back to access. any help would be greatly appreciated because we are running out of space on our server and access takes up far too much space!<
Go to Top of Page

dibley
New Member

United Kingdom
91 Posts

Posted - 17 April 2004 :  12:05:30  Show Profile  Visit dibley's Homepage  Reply with Quote
quote:
Originally posted by FourARSEDSheep
ive gone back to access. any help would be greatly appreciated because we are running out of space on our server and access takes up far too much space!



So does an access db require more space than a mySQL db, for the same number of posts / members?<

.:dib:.

www.nightsouls.co.uk - Uk clubber & music forum.
www.animatronica.co.uk - Creators of themepark animatronics.
Go to Top of Page

AceC
New Member

Cyprus
68 Posts

Posted - 21 April 2004 :  09:51:17  Show Profile  Visit AceC's Homepage  Send AceC an ICQ Message  Reply with Quote
Got the following error having followed the steps at the start of this topic:

quote:
Error

SQL-query :

LOAD DATA LOCAL INFILE 'C:\\WINDOWS\\TEMP\\php465.tmp' INTO TABLE `forum_badwords` FIELDS TERMINATED BY ',' ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\r\n'

MySQL said:


The used command is not allowed with this MySQL version


I am using phpMyAdmin 2.5.0 and mySQL 4.0.16-nt
<

And the hit's just keep on comin'

Edited by - AceC on 21 April 2004 09:52:32
Go to Top of Page

Lazlow
Starting Member

3 Posts

Posted - 22 May 2004 :  08:12:03  Show Profile  Reply with Quote
Is it at all possible to use the converted database with other forums? Ie. Invision or phpBB? Or does this require another method? Thanks<
Go to Top of Page

OneWayMule
Dev. Team Member & Support Moderator

Austria
4969 Posts

Posted - 22 May 2004 :  11:25:55  Show Profile  Visit OneWayMule's Homepage  Send OneWayMule an ICQ Message  Reply with Quote
quote:
Originally posted by Lazlow

Is it at all possible to use the converted database with other forums? Ie. Invision or phpBB? Or does this require another method? Thanks


Yes, you will not be able to use Invision or phpBB with the Snitz table structure Snitz uses.
You will have to ask/search at their site if the provide a converter which organizes the Snitz data for use with other forums.<

My MODs:
Birthdays - Custom Policy - F.A.Q. Administration - Forum Rules - Guestbook
Links Manager - MyOwnGoogle - Profile Views - Search Log - WebSearch

Useful stuff:
Forum and MOD Installation - MOD Installation Guide - Snitz v3.4.05 Readme - Free ASP Hosts - Support Snitz
Go to Top of Page

ndguy
Starting Member

13 Posts

Posted - 01 July 2004 :  00:22:28  Show Profile  Reply with Quote
Chumawumba, Wannab, et..

I've gone to all the links you've posted for myfrontsql 2.5 and none is working. Could you post a link or email me a copy?

I appreciate your help. Jaber

<
Go to Top of Page

Davio
Development Team Member

Jamaica
12217 Posts

Posted - 01 July 2004 :  00:30:31  Show Profile  Reply with Quote
You can download MySQL-Front 2.5 at the following places:
http://mysqlfront.phpsoft.it/
http://www.bumpersoft.com/Programming/Databases_and_Networks/Review_982_index.htm<

Support Snitz Forums

Edited by - Davio on 01 July 2004 00:31:04
Go to Top of Page

ndguy
Starting Member

13 Posts

Posted - 01 July 2004 :  00:59:35  Show Profile  Reply with Quote
Okay, I just found one.

Always good to have a few on hand just in case.. :)

http://support.webhostautomation.com/?_a=knowledgebase&_j=questiondetails&_i=133<
Go to Top of Page

ndguy
Starting Member

13 Posts

Posted - 01 July 2004 :  12:50:31  Show Profile  Reply with Quote
Davio,

I just downloaded MySQL front but my hosting company says all SQL database management must be done through their web-based PHPmyadmin interface.

Mysql front seems like a faster easier way to convert can I still do this without using my providers default interface?

Thanks



<
Go to Top of Page

Marcoworld
New Member

Italy
68 Posts

Posted - 02 September 2004 :  14:13:11  Show Profile  Visit Marcoworld's Homepage  Reply with Quote
Hello!!
I converted my ACCESS to MySql:
Access= 13Mb
MySql= 13.9 Mb
is it possible?
Thanks
<

- Excuse me for my bad english... -
http://www.marcoworld.it
http://www.marcoworld.it/forum
http://www.marcoworld.it/erasmus
Go to Top of Page

Marcoworld
New Member

Italy
68 Posts

Posted - 03 September 2004 :  12:12:28  Show Profile  Visit Marcoworld's Homepage  Reply with Quote
Is there anyone that can help me?!?!?
thanks<

- Excuse me for my bad english... -
http://www.marcoworld.it
http://www.marcoworld.it/forum
http://www.marcoworld.it/erasmus
Go to Top of Page

Cool Surfer
Starting Member

India
32 Posts

Posted - 19 October 2004 :  13:56:35  Show Profile  Visit Cool Surfer's Homepage  Send Cool Surfer an AOL message  Send Cool Surfer an ICQ Message  Send Cool Surfer a Yahoo! Message  Reply with Quote
can an existing invision forum version2, sql be used with latest snitz forum pl. I desperately need to convert pl.<

Cool Surfer
Go to Top of Page

Gremlin
General Help Moderator

New Zealand
7528 Posts

Posted - 17 December 2004 :  06:32:41  Show Profile  Visit Gremlin's Homepage  Reply with Quote
While it's fresh in my mind thought I'd post this little gotcha on conversions to mySQL.

I did a conversion earlier this week and there were complaints that the badword filter wasn't working correctly afterwards. Turns out they had several filters loaded with a space after the text so that words like assume didn't get filtered. This in itself wasn't an issue. However the field for the badwords in the database is type VARCHAR and theres an interesting "feature" of mySQL that trims all trailing spaces from data in VARCHAR fields, so consequently these filters were no longer working correctly.

Fairly simple fix was to delete that field and redefine it as type text which retains the trailing space (I tried CHAR but for some reason mySQL kept chaing it to VARCHAR even though I had explictly said CHAR in my CREATE statement.)<

Kiwihosting.Net - The Forum Hosting Specialists
Go to Top of Page

shaungallant
Starting Member

5 Posts

Posted - 17 January 2005 :  15:12:11  Show Profile  Reply with Quote
I've converted my access database to mysql, and I'm having a problem with the connect string. I'm hoping someone can point me in the right direction. Currently I'm getting the following error message:

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
The page cannot be displayed
There is a problem with the page you are trying to reach and it cannot be displayed.

--------------------------------------------------------------------------------

Please try the following:

Click the Refresh button, or try again later.

Open the www.miltonhog.ca home page, and then look for links to the information you want.
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services

--------------------------------------------------------------------------------

Technical Information (for support personnel)

Error Type:
Provider (0x8000FFFF)
Catastrophic failure
/forum_new/inc_header.asp, line 114


Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)

Page:
GET /forum_new/Default.asp

Time:
Monday, January 17, 2005, 3:03:48 PM


More information:
Microsoft Support



This is my connect string:

strConnString = "driver={MySQL ODBC 3.51 Driver};server=localhost;uid=root;pwd=**********;database=snitz"

Can anyone point me in the right direction?

Thanks,

Shaun<
Go to Top of Page

Gremlin
General Help Moderator

New Zealand
7528 Posts

Posted - 18 January 2005 :  03:46:44  Show Profile  Visit Gremlin's Homepage  Reply with Quote
Either of the two provided in the config.asp should work


'strConnString = "driver=MySQL;server=SERVER_IP;uid=UID;pwd=PWD;database=DB_NAME" '## MySQL w/ MyODBC v2.50
'strConnString = "driver={MySQL ODBC 3.51 Driver};option=4;server=SERVER_IP;user=UID;password=PWD;DATABASE=DB_NAME;" '##MySQL w/ MyODBC v3.51
<

Kiwihosting.Net - The Forum Hosting Specialists
Go to Top of Page
Page: of 6 Previous Topic Topic Next Topic  
Previous Page | Next Page
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.12 seconds. Powered By: Snitz Forums 2000 Version 3.4.07