Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MySql
 When I access my homepage for the forum

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!
Before posting, make sure you have read this topic!

Screensize:
UserName:
Password:
Format Mode:
Format: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkInsert EmailInsert Image Insert CodeInsert QuoteInsert List
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
   

T O P I C    R E V I E W
mkervin 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.
10   L A T E S T    R E P L I E S    (Newest First)
mkervin Posted - 04 April 2011 : 19:47:34
OK, I will pen something up and get it posted.
ruirib 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.
mkervin 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.
mkervin 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.
ruirib Posted - 03 April 2011 : 17:55:04
I would say login details are wrong or you have a permissions issue. I suggest you talk to your host.
mkervin 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.
ruirib Posted - 03 April 2011 : 17:01:08
Is the database server a linux one?
mkervin Posted - 03 April 2011 : 15:22:06
I just logged into my remote MySQL database via HeidiSQL and it is all there.
mkervin 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?
ruirib Posted - 03 April 2011 : 14:40:55
Are you sure the database has all the data in the hosting server?

Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000 Version 3.4.07