CountryGirl Posted March 10, 2010 Share Posted March 10, 2010 Hi all, Alright, I've run into an issue (again!) with our web hosting server. They have been a complete nightmare since we switched to them 3 months ago. The company I'm working for gives me all their data in a Microsoft Access database, so since I'm using PHP & MySQL, obviously I have to convert the Access DB to an SQL DB. I have the BullZip MS Access to MySQL and it's working fine. But, I keep getting an error message saying "Access denied for user such and such." Now, this is an error message I've gotten before when trying to do certain things in the PHPMyAdmin, so I know this is something at the server's end. I called them last Friday to have them look into it. Today I heard back from them and I'm shocked with what I was told. They said that their company does not support database conversion. So, basically there's nothing I can do with all the data that I have to get into the PHP database on their server. This is such a simple conversion and thing to do, I don't get why in the world they wouldn't support database conversion. Has anyone else ever had this happen? Where your server doesn't support DB conversion? If so, what did you do? I've seriously had it with this web hosting company and I'll be sure to let them know that (as politely as I can ) tomorrow when I call to try to talk to someone higher up than the person I just got off the phone with. And see if they are really telling me the straight-facts. Thanks ! Quote Link to comment https://forums.phpfreaks.com/topic/194835-web-hosting-company-not-supporting-db-conversion-anyone-hadheard-this-prob/ Share on other sites More sharing options...
anatak Posted March 11, 2010 Share Posted March 11, 2010 This probably sounds stupid but why don't you convert the database at your work and then export that data to import it in your hostings db ? Sorry I never ran into any problem like this but I firmly believe in voting with your money and letting them know that you are considering another hosting company. Quote Link to comment https://forums.phpfreaks.com/topic/194835-web-hosting-company-not-supporting-db-conversion-anyone-hadheard-this-prob/#findComment-1024491 Share on other sites More sharing options...
roopurt18 Posted March 11, 2010 Share Posted March 11, 2010 Unless they advertised that they were experts at database conversion or specifically outline what they would convert from and convert to, I wouldn't expect any web hosting company to perform database conversions. I've performed a number of data migrations in my life time and I'll tell you right now it's not an easy task. Quote Link to comment https://forums.phpfreaks.com/topic/194835-web-hosting-company-not-supporting-db-conversion-anyone-hadheard-this-prob/#findComment-1024495 Share on other sites More sharing options...
TapeGun007 Posted March 11, 2010 Share Posted March 11, 2010 I had a similar experience, but I ended up using a different output method on Bullzip. I think it was outputting to a comma delimited file, and was able to import that way. Worth a try anyway? Quote Link to comment https://forums.phpfreaks.com/topic/194835-web-hosting-company-not-supporting-db-conversion-anyone-hadheard-this-prob/#findComment-1024597 Share on other sites More sharing options...
CountryGirl Posted March 11, 2010 Author Share Posted March 11, 2010 I talked to them again today and since I threatened to leave the company, they actually do have a way that I can convert an Access DB into the PHP. They're supposed to be calling me back with all that info. We'll see how it goes. Thanks guys! Quote Link to comment https://forums.phpfreaks.com/topic/194835-web-hosting-company-not-supporting-db-conversion-anyone-hadheard-this-prob/#findComment-1024916 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.