I have a potential client who is unhappy with their hosting solution, and would like to go with us. They are currently using a MS Access 2000 database.<br /><br />First, is it possible for them to simply put their DB up on TCH servers and access it via MyODBC? If so, does anybody out there have experience and know how to do it?<br /><br />If not (as I expect), how hard or easy is it to convert to a MySQL DB, and then to upload changes? The best of all worlds would be for the person currently managing the data not to have to learn a whole new interface.<br /><br />Thanks in advance for any help you can give me.<!--content-->
Migrating data from Access to MySQL is fairly simple. I have exported several db's from Access as CSV data, then used PHPMyAdmin (accessible from cpanel) to import the data to a MySQL db.<br /><br />Is the database populated with static data, or will the person managing the data be making changes on a regular basis? You could write a custom PHP interface for data modification & entry, but it wouldn't be the same as using Access.<br /><br />On machines at work (not TCH servers) I have migrated several db's from Access to MySQL, and then written web interfaces in PHP for them. If you end up going that route, I'm willing to help any way I can. I'm certainly not an expert in PHP or MySQL, but I have a good working knowledge of both.<br /><br />Good Luck -<br /><br />Allan Doute<br /><a href="http://www.doute.net" target="_blank">www.doute.net</a><!--content-->
Hi,<br /><br />Your best bet unless you want to pay, would be to read this webpages through as it explains everything for you.<br /><br /><a href="http://www.phphelp.com/tutorial/using-myodbc-to-connect-to-a-remote-database.html" target="_blank">http://www.phphelp.com/tutorial/using-myod...e-database.html</a><br /><br />Jim<!--content-->
Thanks for the quick replies. I'll check out the info you've given me.<br /><br />More later.<!--content-->
Allan - thanks for the tips on migrating from Access to MySQL. I have written a couple of Web-based interfaces, so that shouldn't be a problem if I decide to go that route. I do appreciate your offer of help, and will try not to abuse it.<br /><br />Jim - thank you for the link to phphelp. Seems that it would be possible to let the client use Access as the interface to MySQL. <br /><br />The big question is Does TCH allow remote access to databases in this manner? Is there a GURU listening who has an answer to this?<!--content-->
Hi,<br /><br />You can access the database remotley yes.<br /><br />See here:<br /><br /><a href="http://www.totalchoicehosting.com/help/textpagea9.htm" target="_blank">http://www.totalchoicehosting.com/help/textpagea9.htm</a><br /><br />Jim<!--content-->
Thanks again, Jim. You're always right there with a great tip.<!--content-->
Trying to do something like this now. I've got an Access *.mde beta that I'm trying to migrate to MySQL and then plan to create PHP pages for it. Through some research, I've been able to create a dump file and ftp'd it to my site but have been unable to locate any documentation on how to extract it onto TCH's servers. <br /><br />I tho't about going from *.mde to *.mdb and trying to convert that way. However, I can only get some of the data structure to convert. I realize that I'll lose some of the code in the conversion, but I can work around that. I could do each of the tables by hand, but it would take quite a bit of time. I <i><b>KNOW</b></i> there has to be an easier way out there somewhere! But if that's the way it has to be, so be it. (I got the time to do it!)<br /><br />Any suggestions/help from the "guru's" would be appreciated. TIA.<!--content-->
Steve,<br />I haven't done exactly what you're asking, but it would seem that an easy solution would be to create a CSV from the Access db and then use phpMyadmin to upload the files.<br /><br />But if you have a dump file.... if it's in SQL, I'd first try pasting the code into the query field in phpMyAdmin.<br /><br />That's how I transfered my 95 databases from my old host to TCH. But I was going from MySQL to MySQL... so there might be another twist in there that I'm not aware of.<!--content-->
Can't create new db. Is there a FAQ that I can look at to make sure I'm not doing something wrong?<!--content-->
Don't try to create new db through phpMyAdmin, instead us the Manage MySQL link in cpanel to create the db, create the user and assign the user to the db. Then all other functions can be done within phpMyAdmin.<br /><br />Hope that helps.<!--content-->
Try this thread that I started today in the Scripting forum<br /><br /><a href="http://www.totalchoicehosting.com/forums/index.php?act=ST&f=59&t=2399" target="_blank">http://www.totalchoicehosting.com/forums/i...=ST&f=59&t=2399</a><br /><br />Not the end all and be all of db info... but it should get you going in the right direction. Follow the suggestions to other resources and it should be pretty easy.<br /><br />If you still need more help after trying the suggestions in that post then let us know where you get stuck.<!--content-->
Jack:<br /><br />Thanks for the "Into to PHP" thread. It nicely puts the basics into a language everyone can easily understand. It will also nicely augment my growing stack of PHP documentation.<br /><br />Still having a problem trying to move my dumpfile into an actual database. I've got the database created (thanks lstover!). But I'm assuming (I know..I know!) that I can't use the mysqldump from the query field in phpMyAdmin to create the sql statement to dump the tables from the dump file into the blank database. Only select statements are allowed there, correct?<br /><br />I'm sure it's buried in the mysql documentation somewhere, but I'm on the road for my job and I'm limited as to how long I can stay dialed-up without being charged. I seem to remember having a difficult time first learning Oracle, but as time progressed, it started to come easily enough. I'm sure this is the same way...just gotta get over that initial stumbling block!<br /><br />Thanks for all the help so far.<!--content-->
Yes. You can use the dumpfile by pasting it right into the SQL field in phpMyAdmin.<br /><br />It will create all the tables and populate it with data, assuming the dumpfile is written correctly.<br /><br />I've had to restore a database before and that's exactly what you do. Now the dumpfile I was using was made by phpMyAdmin... but there's no reason I can think of why this wouldn't work for you.<!--content-->
Ok...I'm officially stumped. Head Bash I've read the MySQL manual and tried to enter the syntax in to the SQL field in phpMyAdmin. However, all I got was an error message.<br /><br />Syntax used: mysqldump databasename < dumpfile.sql<br /><br />Somehow I'm just not getting it! Any and all help appreciated.<!--content-->
Tip: Open your dumpfile.sql for editing through the cPanel FileManager. Highlight all contents of the file and CTRL+C to copy. Then open phpMyAdmin and click SQL. Paste in the contents of your copy via CTRL+V. <br /><br />You may need to edit the content to exclude any comments, etc. Make sure that the SQL statement then ENDS in a semi-colon (<img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/wink.gif" style="vertical-align:middle" emoid="
" border="0" alt="wink.gif" />.<br /><br />Go<br /><br />Good luck<!--content-->
Okay... I haven't used this personally.<br /><br />But here's a link you might try<br /><br /><a href="http://www.bullzip.com/products/msa2mys/info.php" target="_blank">http://www.bullzip.com/products/msa2mys/info.php</a><br /><br />I found in Google with search<br /><!--quoteo--><div class='quotetop'>QUOTE</div><div class='quotemain'><!--quotec-->access mysql dump transfer<!--QuoteEnd--></div><!--QuoteEEnd--><!--content-->
I am happy to report that I've finally figured what I've been doing wrong. It took some digging, trial and error, but I now got it.<br /><br />Many thanks to lstover and surfire for the guidance and links. BTW...msa2mys works just fine with some slight modifications. Saves a BUNCH of typing!<br /><br />This makes me happy I'm here with TCH!<br /><br /> Rock Sign<!--content-->
Glad to have you as a TCH member. And thanks for using the forums.<!--content-->
Migrating data from Access to MySQL is fairly simple. I have exported several db's from Access as CSV data, then used PHPMyAdmin (accessible from cpanel) to import the data to a MySQL db.<br /><br />Is the database populated with static data, or will the person managing the data be making changes on a regular basis? You could write a custom PHP interface for data modification & entry, but it wouldn't be the same as using Access.<br /><br />On machines at work (not TCH servers) I have migrated several db's from Access to MySQL, and then written web interfaces in PHP for them. If you end up going that route, I'm willing to help any way I can. I'm certainly not an expert in PHP or MySQL, but I have a good working knowledge of both.<br /><br />Good Luck -<br /><br />Allan Doute<br /><a href="http://www.doute.net" target="_blank">www.doute.net</a><!--content-->
Hi,<br /><br />Your best bet unless you want to pay, would be to read this webpages through as it explains everything for you.<br /><br /><a href="http://www.phphelp.com/tutorial/using-myodbc-to-connect-to-a-remote-database.html" target="_blank">http://www.phphelp.com/tutorial/using-myod...e-database.html</a><br /><br />Jim<!--content-->
Thanks for the quick replies. I'll check out the info you've given me.<br /><br />More later.<!--content-->
Allan - thanks for the tips on migrating from Access to MySQL. I have written a couple of Web-based interfaces, so that shouldn't be a problem if I decide to go that route. I do appreciate your offer of help, and will try not to abuse it.<br /><br />Jim - thank you for the link to phphelp. Seems that it would be possible to let the client use Access as the interface to MySQL. <br /><br />The big question is Does TCH allow remote access to databases in this manner? Is there a GURU listening who has an answer to this?<!--content-->
Hi,<br /><br />You can access the database remotley yes.<br /><br />See here:<br /><br /><a href="http://www.totalchoicehosting.com/help/textpagea9.htm" target="_blank">http://www.totalchoicehosting.com/help/textpagea9.htm</a><br /><br />Jim<!--content-->
Thanks again, Jim. You're always right there with a great tip.<!--content-->
Trying to do something like this now. I've got an Access *.mde beta that I'm trying to migrate to MySQL and then plan to create PHP pages for it. Through some research, I've been able to create a dump file and ftp'd it to my site but have been unable to locate any documentation on how to extract it onto TCH's servers. <br /><br />I tho't about going from *.mde to *.mdb and trying to convert that way. However, I can only get some of the data structure to convert. I realize that I'll lose some of the code in the conversion, but I can work around that. I could do each of the tables by hand, but it would take quite a bit of time. I <i><b>KNOW</b></i> there has to be an easier way out there somewhere! But if that's the way it has to be, so be it. (I got the time to do it!)<br /><br />Any suggestions/help from the "guru's" would be appreciated. TIA.<!--content-->
Steve,<br />I haven't done exactly what you're asking, but it would seem that an easy solution would be to create a CSV from the Access db and then use phpMyadmin to upload the files.<br /><br />But if you have a dump file.... if it's in SQL, I'd first try pasting the code into the query field in phpMyAdmin.<br /><br />That's how I transfered my 95 databases from my old host to TCH. But I was going from MySQL to MySQL... so there might be another twist in there that I'm not aware of.<!--content-->
Can't create new db. Is there a FAQ that I can look at to make sure I'm not doing something wrong?<!--content-->
Don't try to create new db through phpMyAdmin, instead us the Manage MySQL link in cpanel to create the db, create the user and assign the user to the db. Then all other functions can be done within phpMyAdmin.<br /><br />Hope that helps.<!--content-->
Try this thread that I started today in the Scripting forum<br /><br /><a href="http://www.totalchoicehosting.com/forums/index.php?act=ST&f=59&t=2399" target="_blank">http://www.totalchoicehosting.com/forums/i...=ST&f=59&t=2399</a><br /><br />Not the end all and be all of db info... but it should get you going in the right direction. Follow the suggestions to other resources and it should be pretty easy.<br /><br />If you still need more help after trying the suggestions in that post then let us know where you get stuck.<!--content-->
Jack:<br /><br />Thanks for the "Into to PHP" thread. It nicely puts the basics into a language everyone can easily understand. It will also nicely augment my growing stack of PHP documentation.<br /><br />Still having a problem trying to move my dumpfile into an actual database. I've got the database created (thanks lstover!). But I'm assuming (I know..I know!) that I can't use the mysqldump from the query field in phpMyAdmin to create the sql statement to dump the tables from the dump file into the blank database. Only select statements are allowed there, correct?<br /><br />I'm sure it's buried in the mysql documentation somewhere, but I'm on the road for my job and I'm limited as to how long I can stay dialed-up without being charged. I seem to remember having a difficult time first learning Oracle, but as time progressed, it started to come easily enough. I'm sure this is the same way...just gotta get over that initial stumbling block!<br /><br />Thanks for all the help so far.<!--content-->
Yes. You can use the dumpfile by pasting it right into the SQL field in phpMyAdmin.<br /><br />It will create all the tables and populate it with data, assuming the dumpfile is written correctly.<br /><br />I've had to restore a database before and that's exactly what you do. Now the dumpfile I was using was made by phpMyAdmin... but there's no reason I can think of why this wouldn't work for you.<!--content-->
Ok...I'm officially stumped. Head Bash I've read the MySQL manual and tried to enter the syntax in to the SQL field in phpMyAdmin. However, all I got was an error message.<br /><br />Syntax used: mysqldump databasename < dumpfile.sql<br /><br />Somehow I'm just not getting it! Any and all help appreciated.<!--content-->
Tip: Open your dumpfile.sql for editing through the cPanel FileManager. Highlight all contents of the file and CTRL+C to copy. Then open phpMyAdmin and click SQL. Paste in the contents of your copy via CTRL+V. <br /><br />You may need to edit the content to exclude any comments, etc. Make sure that the SQL statement then ENDS in a semi-colon (<img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/wink.gif" style="vertical-align:middle" emoid="
" border="0" alt="wink.gif" />.<br /><br />Go<br /><br />Good luck<!--content-->Okay... I haven't used this personally.<br /><br />But here's a link you might try<br /><br /><a href="http://www.bullzip.com/products/msa2mys/info.php" target="_blank">http://www.bullzip.com/products/msa2mys/info.php</a><br /><br />I found in Google with search<br /><!--quoteo--><div class='quotetop'>QUOTE</div><div class='quotemain'><!--quotec-->access mysql dump transfer<!--QuoteEnd--></div><!--QuoteEEnd--><!--content-->
I am happy to report that I've finally figured what I've been doing wrong. It took some digging, trial and error, but I now got it.<br /><br />Many thanks to lstover and surfire for the guidance and links. BTW...msa2mys works just fine with some slight modifications. Saves a BUNCH of typing!<br /><br />This makes me happy I'm here with TCH!<br /><br /> Rock Sign<!--content-->
Glad to have you as a TCH member. And thanks for using the forums.<!--content-->