RE: Access mySQL database across Internet
The connection time to my mySQL database is OK from the ASP page. Are there any ways to speed this up though ? From: [EMAIL PROTECTED] To: My.SQL mysql@lists.mysql.com@ashcomp.net Subject: RE: Access mySQL database across Internet Date: Fri, 11 Aug 2006 12:20:19 -0400 On Fri, 11 Aug 2006 15:02:12 +, Neil Tompkins wrote At the moment our mysql server hosted by an ISP, is updated every second by a program running on our local Internet connection from our own office network. We have seen no performance issues from our websites hosted by the same ISP running our mySQL server. That's fairly impressive, but I hope you mean that you only *consider* updating once per second, if actually necessary. It would be an awful lot of wasteful traffic if you actually had the two machines talking every seconed to transmit nothing. Barry -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] _ Be one of the first to try Windows Live Mail. http://ideas.live.com/programpage.aspx?versionId=5d21c51a-b161-4314-9b0e-4911fb2b2e6d
Re: Access mySQL database across Internet
You could look into establishing persistent connections. Know it's possible with mod_perl and I believe PHP. Not sure about ASP. Basically, this leaves a connection always open, eliminating the overhead of resolving host, connecting, authenticating, switching to the proper database. Not really a lot of time saved but for a high-volume site it can make a difference; also may help if you are experiencing network latency. Is establishing a connection what you feel is slow? Or the transfer of data between your servers is what's slow? Dan On 8/15/06, Neil Tompkins [EMAIL PROTECTED] wrote: The connection time to my mySQL database is OK from the ASP page. Are there any ways to speed this up though ? From: [EMAIL PROTECTED] To: My.SQL mysql@lists.mysql.com@ashcomp.net Subject: RE: Access mySQL database across Internet Date: Fri, 11 Aug 2006 12:20:19 -0400 On Fri, 11 Aug 2006 15:02:12 +, Neil Tompkins wrote At the moment our mysql server hosted by an ISP, is updated every second by a program running on our local Internet connection from our own office network. We have seen no performance issues from our websites hosted by the same ISP running our mySQL server. That's fairly impressive, but I hope you mean that you only *consider* updating once per second, if actually necessary. It would be an awful lot of wasteful traffic if you actually had the two machines talking every seconed to transmit nothing. Barry -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] _ Be one of the first to try Windows Live Mail. http://ideas.live.com/programpage.aspx?versionId=5d21c51a-b161-4314-9b0e-4911fb2b2e6d -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Access mySQL database across Internet
The problem appears to be retrieving the data which is slow. Date: Tue, 15 Aug 2006 11:32:23 -0500 From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: Access mySQL database across Internet CC: mysql@lists.mysql.com You could look into establishing persistent connections. Know it's possible with mod_perl and I believe PHP. Not sure about ASP. Basically, this leaves a connection always open, eliminating the overhead of resolving host, connecting, authenticating, switching to the proper database. Not really a lot of time saved but for a high-volume site it can make a difference; also may help if you are experiencing network latency. Is establishing a connection what you feel is slow? Or the transfer of data between your servers is what's slow? Dan On 8/15/06, Neil Tompkins [EMAIL PROTECTED] wrote: The connection time to my mySQL database is OK from the ASP page. Are there any ways to speed this up though ?From: [EMAIL PROTECTED] To: My.SQL mysql@lists.mysql.com@ashcomp.net Subject: RE: Access mySQL database across Internet Date: Fri, 11 Aug 2006 12:20:19 -0400 On Fri, 11 Aug 2006 15:02:12 +, Neil Tompkins wrote At the moment our mysql server hosted by an ISP, is updated every second by a program running on our local Internet connection from our own office network. We have seen no performance issues from our websites hosted by the same ISP running our mySQL server. That's fairly impressive, but I hope you mean that you only *consider* updating once per second, if actually necessary. It would be an awful lot of wasteful traffic if you actually had the two machines talking every seconed to transmit nothing. Barry -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] _ Be one of the first to try Windows Live Mail. http://ideas.live.com/programpage.aspx?versionId=5d21c51a-b161-4314-9b0e-4911fb2b2e6d _ Be one of the first to try Windows Live Mail. http://ideas.live.com/programpage.aspx?versionId=5d21c51a-b161-4314-9b0e-4911fb2b2e6d
Re: Access mySQL database across Internet
Neil Tompkins wrote: The problem appears to be retrieving the data which is slow. Are you sure it's not the actual query that's slow? If you run the query in mysql (ie through the command prompt) is it fast? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Access mySQL database across Internet
At the moment our mysql server hosted by an ISP, is updated every second by a program running on our local Internet connection from our own office network. We have seen no performance issues from our websites hosted by the same ISP running our mySQL server. My question is because of this remote update, would we see a problem if we queried the mysql database from webpages from another ISP ? Date: Thu, 10 Aug 2006 16:09:29 -0500 From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: Access mySQL database across Internet CC: mysql@lists.mysql.com A good point to make here is that averages are generally a poor calculation to use when planning for load, since your systems have to handle the peaks as well as the average. I know this, fought a number of fights over it at my last job - don't know why I just quoted you averages! If 99% of your 1000 hits occur between 7:59 AM and 8:01 AM (some sort of workday login validaton system perhaps ) then obviously you need to handle as many as 500 a minute or more. So it may vary from average quite a bit based on your peak times - that will be good information to research as part of your planning process. Dan On 8/10/06, Dan Buettner [EMAIL PROTECTED] wrote: No, 1000 hits / day isn't terribly high traffic, if you're serving pretty normal stuff. That averages out to a hit every 32 seconds or so during the course of an 8 to 5 business day, a hit every 86 seconds or so in a full day. No problems at that level. When you get to 1000 hits / minute, then you're talking high traffic! Dan On 8/10/06, Neil Tompkins [EMAIL PROTECTED] wrote: What would you assume to be high traffic ? 1000 hits per day or more ? Date: Thu, 10 Aug 2006 13:05:11 -0500 From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: Access mySQL database across Internet CC: mysql@lists.mysql.com Neil, in theory, this should work fine, given sufficient bandwidth between the two sites. In practice, if it is a high traffic site generating a large number of connections, or a high traffic site pulling large pieces of data (BLOBs or TEXT) from the remote database, you may find performance to be unacceptable. Latency to establish a connection will be slightly higher, on a busy internet day possibly noticeable to end uers. You'll have to be sure you open up any firewalls and also MySQL's own access control to your remote server. Some ISPs prohibit connections like this, so check with yours - would be disappointing for sure to build it all then get a call saying cease and desist; read our acceptable use policy. Dan On 8/10/06, Neil Tompkins [EMAIL PROTECTED] wrote: Hi We have a mysql database hosted with a IIS server on the same network accessible over the Internet. Now we want to set-up a new website with another ISP therefore located in a different datacenter. Has anyone had any experience of this. What performance issues would I get if I access the database from the other datacenter across the Internet ? Thanks Neil-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] _ Be one of the first to try Windows Live Mail. http://ideas.live.com/programpage.aspx?versionId=5d21c51a-b161-4314-9b0e-4911fb2b2e6d
Re: Access mySQL database across Internet
If it's a simple update, then it's doubful a once-a-second update would cause any problems. Databases are built to handle exactly that sort of work. On 8/11/06, Neil Tompkins [EMAIL PROTECTED] wrote: At the moment our mysql server hosted by an ISP, is updated every second by a program running on our local Internet connection from our own office network. We have seen no performance issues from our websites hosted by the same ISP running our mySQL server. My question is because of this remote update, would we see a problem if we queried the mysql database from webpages from another ISP ? Date: Thu, 10 Aug 2006 16:09:29 -0500 From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: Access mySQL database across Internet CC: mysql@lists.mysql.com A good point to make here is that averages are generally a poor calculation to use when planning for load, since your systems have to handle the peaks as well as the average. I know this, fought a number of fights over it at my last job - don't know why I just quoted you averages! If 99% of your 1000 hits occur between 7:59 AM and 8:01 AM (some sort of workday login validaton system perhaps ) then obviously you need to handle as many as 500 a minute or more. So it may vary from average quite a bit based on your peak times - that will be good information to research as part of your planning process. Dan On 8/10/06, Dan Buettner [EMAIL PROTECTED] wrote: No, 1000 hits / day isn't terribly high traffic, if you're serving pretty normal stuff. That averages out to a hit every 32 seconds or so during the course of an 8 to 5 business day, a hit every 86 seconds or so in a full day. No problems at that level. When you get to 1000 hits / minute, then you're talking high traffic! Dan On 8/10/06, Neil Tompkins [EMAIL PROTECTED] wrote: What would you assume to be high traffic ? 1000 hits per day or more ? Date: Thu, 10 Aug 2006 13:05:11 -0500 From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: Access mySQL database across Internet CC: mysql@lists.mysql.com Neil, in theory, this should work fine, given sufficient bandwidth between the two sites. In practice, if it is a high traffic site generating a large number of connections, or a high traffic site pulling large pieces of data (BLOBs or TEXT) from the remote database, you may find performance to be unacceptable. Latency to establish a connection will be slightly higher, on a busy internet day possibly noticeable to end uers. You'll have to be sure you open up any firewalls and also MySQL's own access control to your remote server. Some ISPs prohibit connections like this, so check with yours - would be disappointing for sure to build it all then get a call saying cease and desist; read our acceptable use policy. Dan On 8/10/06, Neil Tompkins [EMAIL PROTECTED] wrote: Hi We have a mysql database hosted with a IIS server on the same network accessible over the Internet. Now we want to set-up a new website with another ISP therefore located in a different datacenter. Has anyone had any experience of this. What performance issues would I get if I access the database from the other datacenter across the Internet ? Thanks Neil -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] Be one of the first to try Windows Live Mail. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Access mySQL database across Internet
On Fri, 11 Aug 2006 15:02:12 +, Neil Tompkins wrote At the moment our mysql server hosted by an ISP, is updated every second by a program running on our local Internet connection from our own office network. We have seen no performance issues from our websites hosted by the same ISP running our mySQL server. That's fairly impressive, but I hope you mean that you only *consider* updating once per second, if actually necessary. It would be an awful lot of wasteful traffic if you actually had the two machines talking every seconed to transmit nothing. Barry -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Access mySQL database across Internet
Neil, in theory, this should work fine, given sufficient bandwidth between the two sites. In practice, if it is a high traffic site generating a large number of connections, or a high traffic site pulling large pieces of data (BLOBs or TEXT) from the remote database, you may find performance to be unacceptable. Latency to establish a connection will be slightly higher, on a busy internet day possibly noticeable to end uers. You'll have to be sure you open up any firewalls and also MySQL's own access control to your remote server. Some ISPs prohibit connections like this, so check with yours - would be disappointing for sure to build it all then get a call saying cease and desist; read our acceptable use policy. Dan On 8/10/06, Neil Tompkins [EMAIL PROTECTED] wrote: Hi We have a mysql database hosted with a IIS server on the same network accessible over the Internet. Now we want to set-up a new website with another ISP therefore located in a different datacenter. Has anyone had any experience of this. What performance issues would I get if I access the database from the other datacenter across the Internet ? Thanks Neil _ Be one of the first to try Windows Live Mail. http://ideas.live.com/programpage.aspx?versionId=5d21c51a-b161-4314-9b0e-4911fb2b2e6d -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Access mySQL database across Internet
What would you assume to be high traffic ? 1000 hits per day or more ? Date: Thu, 10 Aug 2006 13:05:11 -0500 From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: Access mySQL database across Internet CC: mysql@lists.mysql.com Neil, in theory, this should work fine, given sufficient bandwidth between the two sites. In practice, if it is a high traffic site generating a large number of connections, or a high traffic site pulling large pieces of data (BLOBs or TEXT) from the remote database, you may find performance to be unacceptable. Latency to establish a connection will be slightly higher, on a busy internet day possibly noticeable to end uers. You'll have to be sure you open up any firewalls and also MySQL's own access control to your remote server. Some ISPs prohibit connections like this, so check with yours - would be disappointing for sure to build it all then get a call saying cease and desist; read our acceptable use policy. Dan On 8/10/06, Neil Tompkins [EMAIL PROTECTED] wrote: Hi We have a mysql database hosted with a IIS server on the same network accessible over the Internet. Now we want to set-up a new website with another ISP therefore located in a different datacenter. Has anyone had any experience of this. What performance issues would I get if I access the database from the other datacenter across the Internet ? Thanks Neil _ Be one of the first to try Windows Live Mail. http://ideas.live.com/programpage.aspx?versionId=5d21c51a-b161-4314-9b0e-4911fb2b2e6d _ Be one of the first to try Windows Live Mail. http://ideas.live.com/programpage.aspx?versionId=5d21c51a-b161-4314-9b0e-4911fb2b2e6d
Re: Access mySQL database across Internet
No, 1000 hits / day isn't terribly high traffic, if you're serving pretty normal stuff. That averages out to a hit every 32 seconds or so during the course of an 8 to 5 business day, a hit every 86 seconds or so in a full day. No problems at that level. When you get to 1000 hits / minute, then you're talking high traffic! Dan On 8/10/06, Neil Tompkins [EMAIL PROTECTED] wrote: What would you assume to be high traffic ? 1000 hits per day or more ? Date: Thu, 10 Aug 2006 13:05:11 -0500 From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: Access mySQL database across Internet CC: mysql@lists.mysql.com Neil, in theory, this should work fine, given sufficient bandwidth between the two sites. In practice, if it is a high traffic site generating a large number of connections, or a high traffic site pulling large pieces of data (BLOBs or TEXT) from the remote database, you may find performance to be unacceptable. Latency to establish a connection will be slightly higher, on a busy internet day possibly noticeable to end uers. You'll have to be sure you open up any firewalls and also MySQL's own access control to your remote server. Some ISPs prohibit connections like this, so check with yours - would be disappointing for sure to build it all then get a call saying cease and desist; read our acceptable use policy. Dan On 8/10/06, Neil Tompkins [EMAIL PROTECTED] wrote: Hi We have a mysql database hosted with a IIS server on the same network accessible over the Internet. Now we want to set-up a new website with another ISP therefore located in a different datacenter. Has anyone had any experience of this. What performance issues would I get if I access the database from the other datacenter across the Internet ? Thanks Neil -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Access mySQL database across Internet
A good point to make here is that averages are generally a poor calculation to use when planning for load, since your systems have to handle the peaks as well as the average. I know this, fought a number of fights over it at my last job - don't know why I just quoted you averages! If 99% of your 1000 hits occur between 7:59 AM and 8:01 AM (some sort of workday login validaton system perhaps ) then obviously you need to handle as many as 500 a minute or more. So it may vary from average quite a bit based on your peak times - that will be good information to research as part of your planning process. Dan On 8/10/06, Dan Buettner [EMAIL PROTECTED] wrote: No, 1000 hits / day isn't terribly high traffic, if you're serving pretty normal stuff. That averages out to a hit every 32 seconds or so during the course of an 8 to 5 business day, a hit every 86 seconds or so in a full day. No problems at that level. When you get to 1000 hits / minute, then you're talking high traffic! Dan On 8/10/06, Neil Tompkins [EMAIL PROTECTED] wrote: What would you assume to be high traffic ? 1000 hits per day or more ? Date: Thu, 10 Aug 2006 13:05:11 -0500 From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: Access mySQL database across Internet CC: mysql@lists.mysql.com Neil, in theory, this should work fine, given sufficient bandwidth between the two sites. In practice, if it is a high traffic site generating a large number of connections, or a high traffic site pulling large pieces of data (BLOBs or TEXT) from the remote database, you may find performance to be unacceptable. Latency to establish a connection will be slightly higher, on a busy internet day possibly noticeable to end uers. You'll have to be sure you open up any firewalls and also MySQL's own access control to your remote server. Some ISPs prohibit connections like this, so check with yours - would be disappointing for sure to build it all then get a call saying cease and desist; read our acceptable use policy. Dan On 8/10/06, Neil Tompkins [EMAIL PROTECTED] wrote: Hi We have a mysql database hosted with a IIS server on the same network accessible over the Internet. Now we want to set-up a new website with another ISP therefore located in a different datacenter. Has anyone had any experience of this. What performance issues would I get if I access the database from the other datacenter across the Internet ? Thanks Neil -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: access-mysql
MySQL-Front was super and has a built in utility. Can do it remotely or locally. To bad they stopped supporting it. - Original Message - From: Sandeep Murphy [EMAIL PROTECTED] To: Crercio O. Silva [EMAIL PROTECTED]; MySQL List [EMAIL PROTECTED] Sent: Thursday, December 05, 2002 5:06 AM Subject: RE: access-mysql thnx to all! am checking this links out.. looks great! :) -Original Message- From: Crercio O. Silva [mailto:[EMAIL PROTECTED]] Sent: quinta-feira, 5 de Dezembro de 2002 12:30 To: MySQL List Subject: Re: access-mysql DBTools works great on this matter. You find it at http://www.dbtools.com.br/EN and is totally free. []s Crercio - Original Message - From: Sandeep Murphy [EMAIL PROTECTED] To: MySQL List [EMAIL PROTECTED] Sent: Wednesday, December 04, 2002 12:39 PM Subject: access-mysql Hi, Can anyone please suggest a simple and effective method for converting a huge database i hv in Access xp to MySQL ?? hv tried various methods, including using dsns , a small script available at http://www.cynergi.net/exportsql/ etc.. they all work but not deliver a clean result... any tried and trusted method?? thnx in adv, sands - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: access-mysql
I have used Access to MySQL pro and it worked for a few of my databases. http://www.convert-in.com/acc2sqlp.htm Chris -Original Message- From: Sandeep Murphy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 04, 2002 8:39 AM To: MySQL List Subject: access-mysql Hi, Can anyone please suggest a simple and effective method for converting a huge database i hv in Access xp to MySQL ?? hv tried various methods, including using dsns , a small script available at http://www.cynergi.net/exportsql/ etc.. they all work but not deliver a clean result... any tried and trusted method?? thnx in adv, sands - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: access-mysql
I can concur - you pay a little, but you get a much better product with this one. Ian Zabel wrote: The only one I found that creates a good schema that only needs minimal massages, and imports all the data correctly is Access-To-MySQL. It's not free though, but they have a trial. Once I went through my access database and removed certain invalid records (some rows had a screwed up primary key in access that mysql didn't like, and the import would fail), I got a perfect copy of my access database into MySQL. http://www.convert-in.com/acc2sql.htm -Original Message- From: Sandeep Murphy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 04, 2002 9:39 AM To: MySQL List Subject: access-mysql Hi, Can anyone please suggest a simple and effective method for converting a huge database i hv in Access xp to MySQL ?? hv tried various methods, including using dsns , a small script available at http://www.cynergi.net/exportsql/ etc.. they all work but not deliver a clean result... any tried and trusted method?? thnx in adv, sands - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: access-mysql
DBTools works great on this matter. You find it at http://www.dbtools.com.br/EN and is totally free. []s Crercio - Original Message - From: Sandeep Murphy [EMAIL PROTECTED] To: MySQL List [EMAIL PROTECTED] Sent: Wednesday, December 04, 2002 12:39 PM Subject: access-mysql Hi, Can anyone please suggest a simple and effective method for converting a huge database i hv in Access xp to MySQL ?? hv tried various methods, including using dsns , a small script available at http://www.cynergi.net/exportsql/ etc.. they all work but not deliver a clean result... any tried and trusted method?? thnx in adv, sands - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: access-mysql
thnx to all! am checking this links out.. looks great! :) -Original Message- From: Crercio O. Silva [mailto:[EMAIL PROTECTED]] Sent: quinta-feira, 5 de Dezembro de 2002 12:30 To: MySQL List Subject: Re: access-mysql DBTools works great on this matter. You find it at http://www.dbtools.com.br/EN and is totally free. []s Crercio - Original Message - From: Sandeep Murphy [EMAIL PROTECTED] To: MySQL List [EMAIL PROTECTED] Sent: Wednesday, December 04, 2002 12:39 PM Subject: access-mysql Hi, Can anyone please suggest a simple and effective method for converting a huge database i hv in Access xp to MySQL ?? hv tried various methods, including using dsns , a small script available at http://www.cynergi.net/exportsql/ etc.. they all work but not deliver a clean result... any tried and trusted method?? thnx in adv, sands - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: access-mysql
I saved the email last time this was posted, didn't look into it but someone suggested looking at this site. http://www.intranet2internet.com . Another option was to link the table, not exactly sure of all the steps but maybe create an empty table in mysql with all fields and data types, then set up an odbc connection to mysql then link the empty table from access to mysql and copy data from access table to linked mysql table, this way its all done in access. HTH, Steve Bradwell MIS Department. If you give someone a program, you will frustrate them for a day. If you teach them how to program, you will frustrate them for a lifetime. -Original Message- From: Sandeep Murphy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 04, 2002 9:39 AM To: MySQL List Subject: access-mysql Hi, Can anyone please suggest a simple and effective method for converting a huge database i hv in Access xp to MySQL ?? hv tried various methods, including using dsns , a small script available at http://www.cynergi.net/exportsql/ etc.. they all work but not deliver a clean result... any tried and trusted method?? thnx in adv, sands - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: access-mysql
I used MySQLFront. It wasn't entirely automatic, but it did a reasonable job. There are some gotchas. Take your time, and be sure to read the notes for using Access and MyODBC with MySQL, if that's how you're going to do it -- some column types are not recommended. You'll want to add a TIMESTAMP column to each table, as well, after importing. Some of MySQLFront's choices for column types aren't the best -- you should check them by hand before doing the import. In particular it doesn't handle currency fields properly unless you manually set the type. (It defaults to Integer, and truncates the decimal parts.) If you have any table names with spaces, fix those before you try to import. MySQLFront will happily create them, but you'll find them impossible to actually use. You'll have to do some hand editing of your Access queries. Access doesn't support relationships between ODBC data source tables, so you'll need to manually set up the joins in each query. Keep in mind that Access will not enforce data integrity on ODBC tables. Also remember that Access is not case-sensitive, but MySQL is! You should try hard to get the tables correct in MySQL before you deploy the database to users, because after that changing them gets more difficult. If a table definition is changed, you have to go back and delete the link to it in Access, then recreate it. If you don't do this, Access gets confused and goes into an endless loop. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: access-mysql
The only one I found that creates a good schema that only needs minimal massages, and imports all the data correctly is Access-To-MySQL. It's not free though, but they have a trial. Once I went through my access database and removed certain invalid records (some rows had a screwed up primary key in access that mysql didn't like, and the import would fail), I got a perfect copy of my access database into MySQL. http://www.convert-in.com/acc2sql.htm -Original Message- From: Sandeep Murphy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 04, 2002 9:39 AM To: MySQL List Subject: access-mysql Hi, Can anyone please suggest a simple and effective method for converting a huge database i hv in Access xp to MySQL ?? hv tried various methods, including using dsns , a small script available at http://www.cynergi.net/exportsql/ etc.. they all work but not deliver a clean result... any tried and trusted method?? thnx in adv, sands - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: access-mysql
On Wed, 4 Dec 2002 14:39:01 -, Sandeep Murphy wrote: method for converting a huge database i hv in Access xp to MySQL ?? I just wrote a short program in Delphi (using MyODBC) to pull information from an Access MDB and update a MySQL table. Worked fine. I'm sure one could accomplish the same thing in Access natively but I'm far better versed in Delphi. One note...at least in Delphi, uploading from the desktop is FAR faster using a query and update/insert than using a table, especially since one can use multiple VALUES per INSERT query. - Steve Yates - Line noise provided by Ameritech! ~ Taglines by Taglinator - www.srtware.com ~ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: access MySQL server from remote windows m/c
On Mon, 28 Oct 2002, aman mysql wrote: Hi all How do I access a remote MySQL server (on LINUX platform), from a windows application. What drivers I need to download and from where? Hi! You don't need any special drivers. Just the MySQL command-line client will do the job. It can be downloaded from www.mysql.com along with the server package. How do I set permissions on the mysql server to let be accessed by the remote windows machine. See http://www.mysql.com/doc/en/GRANT.html for details on how to set up new users and permissions. You'll need something like GRANT all ON *.* TO yourusername IDENTIFIED BY 'yourpassword'; This will give your users a broad set of permissions, please have a look at the docs if you want to restrict those. Best regards, Iikka ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Access - Mysql conversion
I too am researching how to do this. I've found plenty of products that will do this, of course, I'd rather do it myself. here's some links i've found: http://www.convert-in.com/acc2sqlp.htm http://ultradev.buzzinet.co.uk/mysql/tutorials/converting_data/index.asp http://www.winmysql.com/ i hope that helps at all. If you find anything useful, would you be able to pass the word along? Thanks. Mike -Original Message- From: Joel Wickard [mailto:[EMAIL PROTECTED]] Sent: Monday, January 21, 2002 3:43 PM To: [EMAIL PROTECTED] Subject: Access - Mysql conversion I'm looking for a program, standalone, or web-based, to convert a current access database to mysql. any hints? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Access - Mysql conversion
Another option might be ursql (http://www.urbanresearch.com/ursql). This tool has the ability to generate MySQL-compatible CREATE TABLE scripts from a connected MS Access database. Once the basic CREATE TABLE scripts are generated, you can easily tweak the data types to your liking. In my experience, there's almost always some manual tweaking... On Mon, 21 Jan 2002, Mike Grabski wrote: I too am researching how to do this. I've found plenty of products that will do this, of course, I'd rather do it myself. here's some links i've found: http://www.convert-in.com/acc2sqlp.htm http://ultradev.buzzinet.co.uk/mysql/tutorials/converting_data/index.asp http://www.winmysql.com/ i hope that helps at all. If you find anything useful, would you be able to pass the word along? Thanks. Mike - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
