| Author |
 Topic  |
|
|
mkervin
Junior Member
100 Posts |
 Posted - 03 April 2011 : 14:18:56
|
after converting our db from MS Access to MySQL I am thrown to the setup page where my choice is to create the tables for the database. My database is sitting on our hosting server with the tables already in it. If I run the forum on our local machine, with the exact same files and database, it connects just fine, and everything works and all our data is there. But once I try to access it from our host, after uploading the directory from our testing server and pointing our connection string to our on line db it wants to build the tables again.
What do I do? If I tell it to build the tables will it destroy all our data? I don't want to loose all our work converting the old database into this new one. Help!
And yes our database is sitting on our MySQL server; I checked. And all our data exsist in the tables. |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
mkervin
Junior Member
100 Posts |
Posted - 03 April 2011 : 15:14:35
|
| Yes, I pushed it to the database and all the tables are there with the data in them. What table should I be looking at that may be triggering the problem? |
 |
|
|
mkervin
Junior Member
100 Posts |
Posted - 03 April 2011 : 15:22:06
|
| I just logged into my remote MySQL database via HeidiSQL and it is all there. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
mkervin
Junior Member
100 Posts |
Posted - 03 April 2011 : 17:44:00
|
I am paying for a Microsoft Server but to say for sure, I can't.
This is the message I am getting trying to connect.
The database could not be opened !!
Check your config.asp file and set the
strConnString so it points to the database.
Also check if strDBType is set to the right databasetype.
Code : 80004005
Error Description :
[MySQL][ODBC 5.1 Driver]Access denied for user '??????'@'???.???.???.??' #using password: YES#
I removed the username and ip address, there was actual data when the question marks are.
And the lines that are mentioned are correct. |
Edited by - mkervin on 03 April 2011 17:48:59 |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
mkervin
Junior Member
100 Posts |
Posted - 03 April 2011 : 20:49:58
|
I am expecting a call from my host tomorrow; I spoke to a tech and he had no idea so he put me in for a call back.
I want to thank you for all the help; it is surely appreciated. And if I get the forum up and running on MySQL after the conversion from Access I will be sure to "Pay it forward" over here if anyone needs the help as to what I went through to get it working. Again THANK YOU! I will let you know the outcome. |
|
|
|
mkervin
Junior Member
100 Posts |
Posted - 04 April 2011 : 18:15:33
|
Rui, again let me thank you for ALL your help; it was appreciated.
I am happy to report our forum is up and running on MySQL after being converted from an Access database. I will be happy to help anyone in need of it if you are moving from an Access db to MySQL it isn't that hard but you will need a little computer knowledge to do it.
As for my problem with the connection string it was a problem with the server IP assigned to our account that prevented me from accessing the database once I received the correct one I was able to connect. One thing that did happen was the database wanted to run setup eventhough everything was there. And when it did run setup it created another set of tables. All I did was log into the database through HeidiSQL and renamed the tables and presto it worked.
Now before anyone thinks this was a walk in the park it wasn't. I had to first convert all the tables in the Access database to MySQL, and then set all the data correctly. If this site would like me to pen a step by step conversion I will be happy to, just let me know.
Again thank you all for the help. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 04 April 2011 : 18:30:23
|
I think you did it all pretty much by yourself :).
We still have a sticky around, but I just noticed that it is done for an older import tool. The import tool is rather important in this process, so if you want to describe it, I think it can be useful, even now :).
Thanks. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
mkervin
Junior Member
100 Posts |
Posted - 04 April 2011 : 19:47:34
|
| OK, I will pen something up and get it posted. |
|
|
| |
Topic |
|
When I access my homepage for the forum
