| Author |
 Topic  |
|
|
Hopeful
Junior Member
130 Posts |
 Posted - 17 February 2005 : 08:56:15
|
I am running snitz 3.4 on a my sql database and the database server is constintly down. They told me they have problems with the my sql... How hard would it be to switch my database and all the info and tables to a sql database? Can I just change the connection string and everything will appear?
Thanks! |
Please explain everything in layman terms!!! |
Edited by - Hopeful on 17 February 2005 10:39:17 |
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 17 February 2005 : 09:23:53
|
No, unfortunately it won't be that simple; you'll have to take everything from your MySQL database and dump it into the new MSSQL database - not as easy as task as it sounds. Try searching this forum for posts on converting from MySQL to MSSQL.
|
 Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
 |
|
|
Hopeful
Junior Member
130 Posts |
Posted - 17 February 2005 : 10:24:37
|
Thank you Shaggy!
Can anyone tell me what I need to do to convert from the mysql to sql?
Thanks! |
Please explain everything in layman terms!!! |
|
|
|
NiteOwl
Junior Member
Canada
403 Posts |
Posted - 17 February 2005 : 10:44:01
|
| My suggestion is to find a better mysql host, theer are many around that are in-expensive |
-=NiteOwl=-
|
|
|
|
Hopeful
Junior Member
130 Posts |
Posted - 17 February 2005 : 10:51:23
|
Switching hosts would be a nightmare for me!
I use Brinkster... Does anyone know how to work with their database manager? I do not know how to even access the database so that I can see the information or tables stored?
Thanks! |
Please explain everything in layman terms!!! |
|
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 17 February 2005 : 10:54:41
|
Brinkster are running MySQL now? As big a pain as it may be moving to another host, you'll probably find it a lot less hassle than the problems you're experiencing with Brinkster at the moment and other problems you'll inevitably face in the future as your site grows.
|
Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
|
|
|
Hopeful
Junior Member
130 Posts |
Posted - 17 February 2005 : 10:57:08
|
"Connect to any one of your databases, run queries and updates with this powerful Database Manager tool.
The classic version of our new Database Manager Tool (above). This tool allows you to connect to any one of your databases and run simple queries."
This is what my server offers as far as getting access to my database...
I do not know what it means "to run simple querries or do updates?" I do not know what to do to do the updates?
Can anyone explain how to work with this?
Thanks so much!
|
Please explain everything in layman terms!!! |
|
|
|
Hopeful
Junior Member
130 Posts |
Posted - 17 February 2005 : 10:59:09
|
quote:
Originally posted by Shaggy
Brinkster are running MySQL now? As big a pain as it may be moving to another host, you'll probably find it a lot less hassle than the problems you're experiencing with Brinkster at the moment and other problems you'll inevitably face in the future as your site grows.
Is Brinkster a bad host?
Who else do you recomend and would I lose all my data?
Thanks again! |
Please explain everything in layman terms!!! |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 17 February 2005 : 11:44:35
|
With the proper SQL Server tools it shouldn't be difficult.
1. Setup a normal forum, by changing the config.asp file to connect to your SQL Server database and run setup.asp. This will create the SQL Server tables adequately.
2. Use SQL Server DTS to connect to the MySQL DB and transfer the data to the SQL Server DB. You'd probably need to create an ODBC entry for the MySQL DB, which means that Brinkster would need to allow access to your MySQL DB from the outside. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
Hopeful
Junior Member
130 Posts |
Posted - 17 February 2005 : 13:17:27
|
AHHH hello Rui!!! Jut to be able to tell my customers what is going on with my site I did in fact set up a sql database on Brinkster, changed the connection string in the config.asp file and ran the setup.asp! The forum is up and running! AND the Private Messages MOD installed correctly too!!! (I had errors on my regular forum on the mysql database)
Anyway, the server is still down and they told me I could not access the database until that server is back up and running...
Once it is up, can you guide me through getting all my topics from the old database transfered to the new one? And I would like to only move the topics and not the MODS!!!
Thanks so much! |
Please explain everything in layman terms!!! |
|
|
|
Hopeful
Junior Member
130 Posts |
Posted - 17 February 2005 : 13:23:50
|
Also what is a "SQL Server DTS?" And how do you create an ODBC entry for the MySQL DB?
Thanks again! |
Please explain everything in layman terms!!! |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 17 February 2005 : 14:01:02
|
| The process is a bit complex and difficult to do without the tools and the knowledge about it's use. DTS is Data Transformation Services and it comes with SQL Server. If Brinkster allows external access to your DB I can try and do this for you. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
Hopeful
Junior Member
130 Posts |
Posted - 17 February 2005 : 15:29:34
|
Thank you sooooooooooooooooo much!!!!
I will let you know once they have the MySQL server back up!!!
Thank you Thank you Thank you!!!
Angie
P.S. In the mean time I have been setting up the PM MOD on the new forum that is on the SQL DB server... Will you be able to do the transfer of info without overwriting the MODS that are installed on the new forum?
|
Please explain everything in layman terms!!! |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 17 February 2005 : 17:00:52
|
| To avoid transfer issues, the table structure of your SQL Server DB should be identical to the one in the MySQL DB. So, please run the dbs file for all the mods you have installed with the MySQL based forum in your SQL Server DB. I cannot spend too much time fine tuning the transfer between the two DBs, it's important that both DBs have the same structure. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
Edited by - ruirib on 17 February 2005 17:01:11 |
|
|
|
Hopeful
Junior Member
130 Posts |
Posted - 18 February 2005 : 00:20:12
|
| I believe they do, I will double check! |
Please explain everything in layman terms!!! |
|
|
|
Hopeful
Junior Member
130 Posts |
Posted - 19 February 2005 : 04:32:18
|
Rui, my database server is back up and running and I am sick of changes for awhile!!! I am going to go ahead and stick with the MySQL for now... and hope there are no more problems! Thank you so much for being willing to help me!
|
Please explain everything in layman terms!!! |
|
|
| |
Topic |
|
Topic Locked
