Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- forum DBs
- Nathan In Montana
April 11, 2007, 1:11 am
rate this thread
im currently running several forums on a dedicated windows 2000 server using
MS access databases. one site in particular averages 15,000+ total site
visitors per day with roughly half that using the forum. for that site,
access is just to slow and id like to make the switch over to a mysql DB.
trouble is i know absolutely _nothing_ about mysql and i just havent the
time to learn it right now (not for about 5-6 weeks). i dont have a clue
how to create or use mysql DBs. any help such as a "mysql for dummies"
would certainly be appreciated.
Nathan in Montana
Re: forum DBs
Nathan In Montana wrote:
And are you connecting to the current access database via ODBC+DSNs or some
other weird-ass method? If ODBC, there are ODBC drivers available for
MySQL, which would make porting the forums over to MySQL a lot easier --
still hard, but a lot easier than it would otherwise be!
Basic technique would be to create a copy of the data into an empty MySQL
database. As Access is able to link into external ODBC databases, you
should be able to mostly do that through the comfort of a GUI.
After that, create a copy of your forum software and try visiting it in
your web browser. Chances are that you'll get tonnes of errors. This is
basically because although both Access and MySQL speak SQL, neither of
them speak standards-compliant SQL -- they both speak bastardised
versions. (Pretty much every RDBMS does to a certain degree.)
Your challenge then is to work your way through the forum's coding and fix
every SQL error. The chances are that there will be lots of them, but none
of them should require a degree in astrophysics to figure out -- it's just
a matter of finding the SQL query that causes the problem, figuring out
what Access-specific syntax was used, and replacing it with the
MySQL-specific equivalent, or better yet, the standards-compliant
equivalent if there is one. And doing that many, many times.
When you're done, empty out the MySQL database and copy across the data
again, because the chances are that there will be several days of new
posts in the forum now. Then remove access to the Access forum, but keep
it hanging around on your server for a few weeks just in case you need to
whip it out in an emergency.
This is assuming that the forum software was written by yourself, or you
need to maintain it yourself. If it was written by a third party to whom
you are paying support money, then they should be responsible for any
modification to the forum software, or else you should go elsewhere.
(Though that may involve leaving behind your corpus of messages.)
Toby A Inkster BSc (Hons) ARCS
Contact Me ~ http://tobyinkster.co.uk/contact
Geek of ~ HTML/SQL/Perl/PHP/Python*/Apache/Linux
* = I'm getting there!
Re: forum DBs
Re: forum DBs
Google "sql tutorial"
Top one is one example how simple it is to get going.
Quite frankly I'd recommend you not to upgrade. I wouldn't want my
MySQL adminsitrator to not even know how to create a table.
Re: forum DBs
"> im currently running several forums on a dedicated windows 2000 server
Have you tried to specifically open and close connections in the ASP pages
so that the only time a connection is active is when your actually reading,
writing, updating? Unless you do it manually, my understanding, is the DB
will stay open. Since someplace arround 20 open connections Access starts
to slow down. This might help stretch out Access's resources till you get
either MS 2005 express running or until you do the following......
Another possible solution is to "unload" the DB into a comma delimited text
file. Make the appropriate changes using a text editor and then re-load the
DB into a Php/MySql based forum system. Then you don't have to try to
integrate a new DB into your current forum software.
A third possible solution is to not port the text messages at all. Instead,
make the old fourm system read only and point everyone to the new forum
This hobby has definitely gotten away from me!
Try http://www.ChatNFiles.com which has a new telnet chat system and a HUGE
file downloads collection. Ecard: http://bccs.chatnfiles.com/ecard3.htm .
Posted via a free Usenet account from http://www.teranews.com
- » script to offer download after completing an offer
- — Next thread in » Webmaster Forum
- » ssh on command line: force using a group size (prime size) of 1024 (and no...
- — The site's Newest Thread. Posted in » Secure Shell Forum