Re: MySQL & WebDNA on Windows

This WebDNA talk-list message is from

2006


It keeps the original formatting.
numero = 66681
interpreted = N
texte = Thanks Adam That should keep me busy for a while :) Stuart Tremain idfk web developments, sydney, australia On 03 Apr 2006, at 8:57 AM, Adam O'Connor wrote: > Stuart, > > Its pretty straight forward, 1) Install the latest community > edition of MySQL; 2) Configure MySQL by creating a root user > account, along with perhaps two others (siteuser and admin > accounts); 3) Create a databases (schema); 4) Create your tables; > thats it. You may want to grab the MySQL administrator and Query > Analyzer while you getting MySQL, they make databases > administration and query testing easier - or - you can grab a third > party GUI such as NaviCat -which is very much like MS SQL > Enterprise/Query Analyzer. > You will use webcat's native SQL features, 1) Create a connection; > 2) Send SQL to the db; 3) Manage your returned recordset, if there > is one. This is it in a nutshell, of course MySQL has lots of > features and configurations methods, something to look into as you > get more familiar with using it. > > Have fun. > > > > > > Stuart Tremain wrote: >> After all this talk about mySQL, I have decided to put it onto a >> development machine and give it a go. >> >> Could someone please give me a rundown on setting it up on a >> windows server so that it will work with WebDNA ? >> >> Stuart Tremain >> idfk web developments, sydney, australia >> >> >> >> ------------------------------------------------------------- >> This message is sent to you because you are subscribed to >> the mailing list . >> To unsubscribe, E-mail to: >> To switch to the DIGEST mode, E-mail to > digest@talk.smithmicro.com> >> Web Archive of this list is at: http://webdna.smithmicro.com/ > > > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to digest@talk.smithmicro.com> > Web Archive of this list is at: http://webdna.smithmicro.com/ ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Cannot get WebDNA and MySQL working. (Donovan Brooke 2015)
  2. RE: [WebDNA] Cannot get WebDNA and MySQL working. ("Keith Scarzafava" 2015)
  3. Re: [WebDNA] Cannot get WebDNA and MySQL working. (Donovan Brooke 2015)
  4. Re: [WebDNA] Cannot get WebDNA and MySQL working. (Donovan Brooke 2015)
  5. RE: [WebDNA] Cannot get WebDNA and MySQL working. ("Keith Scarzafava" 2015)
  6. Re: [WebDNA] Cannot get WebDNA and MySQL working. (Donovan Brooke 2015)
  7. Re: [WebDNA] Cannot get WebDNA and MySQL working. (Donovan Brooke 2015)
  8. RE: [WebDNA] Cannot get WebDNA and MySQL working. ("Keith Scarzafava" 2015)
  9. Re: [WebDNA] Cannot get WebDNA and MySQL working. (Stuart Tremain 2015)
  10. RE: [WebDNA] Cannot get WebDNA and MySQL working. ("Keith Scarzafava" 2015)
  11. Re: [WebDNA] Cannot get WebDNA and MySQL working. (Stuart Tremain 2015)
  12. [WebDNA] Cannot get WebDNA and MySQL working. ("Keith Scarzafava" 2015)
  13. [WebDNA] MySQL Query failure (Stuart Tremain 2013)
  14. [WebDNA] For WebDNA 6.0, MYSQL is the only type supported. (WebDNA Solutions 2012)
  15. Re: [WebDNA] Now: Listfields does not work with tables - Was: [OT] MySQL Users (Kenneth Grome 2011)
  16. Re: [WebDNA] Now: Listfields does not work with tables - Was: [OT] MySQL Users (Brian Fries 2011)
  17. Re: [WebDNA] Now: Listfields does not work with tables - Was: [OT] MySQL Users (Govinda 2011)
  18. [WebDNA] Now: Listfields does not work with tables - Was: [OT] MySQL Users (Donovan Brooke 2011)
  19. Re: [WebDNA] [OT] MySQL Users (Paul Willis 2011)
  20. [WebDNA] [OT] MySQL Users (Steve Craig 2011)
  21. Re: [WebDNA] Use of MySQL with WebDNA (Stuart Tremain 2010)
  22. RE: [WebDNA] Use of MySQL with WebDNA ("Dale Therio" 2010)
  23. Re: [WebDNA] Use of MySQL with WebDNA (Brian Fries 2010)
  24. Re: [WebDNA] Use of MySQL with WebDNA ("Mr. Robert Minor Jr." 2010)
  25. Re: [WebDNA] Use of MySQL with WebDNA (Kenneth Grome 2010)
  26. RE: [WebDNA] Use of MySQL with WebDNA ("Terry Nair" 2010)
  27. Re: [WebDNA] Use of MySQL with WebDNA (Paul Willis 2010)
  28. Re: [WebDNA] Use of MySQL with WebDNA (christophe.billiottet@webdna.us 2010)
  29. Re: [WebDNA] Use of MySQL with WebDNA (Paul Willis 2010)
  30. Re: [WebDNA] Use of MySQL with WebDNA (christophe.billiottet@webdna.us 2010)
  31. Re: [WebDNA] Use of MySQL with WebDNA (Govinda 2010)
  32. Re: [WebDNA] Use of MySQL with WebDNA (Toby Cox 2010)
  33. RE: [WebDNA] Use of MySQL with WebDNA ("Will Starck" 2010)
  34. Re: [WebDNA] Use of MySQL with WebDNA (Govinda 2010)
  35. Re: [WebDNA] Use of MySQL with WebDNA (Toby Cox 2010)
  36. [WebDNA] Use of MySQL with WebDNA (christophe.billiottet@webdna.us 2010)
  37. Re: [WebDNA] MySQL float problems with WebDNA (Toby Cox 2010)
  38. Re: [WebDNA] MySQL float problems with WebDNA (JJ WebDNA 2010)
  39. [WebDNA] MySQL float problems with WebDNA (Toby Cox 2010)
  40. Re: [WebDNA] 3-5 GB of native WebDNA db in RAM?, else MySQL w/WebDNA [SQL] tags, else skip WebDNA altogether? (christophe.billiottet@webdna.us 2009)
  41. Re: [WebDNA] 3-5 GB of native WebDNA db in RAM?, else MySQL w/WebDNA [SQL] tags, else skip WebDNA altogether? (Palle Bo Nielsen 2009)
  42. Re: [WebDNA] 3-5 GB of native WebDNA db in RAM?, else MySQL w/WebDNA [SQL] tags, else skip WebDNA altogether? (Palle Bo Nielsen 2009)
  43. Re: [WebDNA] 3-5 GB of native WebDNA db in RAM?, else MySQL w/WebDNA [SQL] tags, else skip WebDNA altogether? (Govinda 2009)
  44. Re: [WebDNA] 3-5 GB of native WebDNA db in RAM?, else MySQL w/WebDNA [SQL] tags, else skip WebDNA altogether? (Palle Bo Nielsen 2009)
  45. Re: [WebDNA] 3-5 GB of native WebDNA db in RAM?, else MySQL w/WebDNA [SQL] tags, else skip WebDNA altogether? (Govinda 2009)
  46. Re: [WebDNA] 3-5 GB of native WebDNA db in RAM?, else MySQL w/WebDNA (Donovan Brooke 2009)
  47. Re: [WebDNA] 3-5 GB of native WebDNA db in RAM?, else MySQL w/WebDNA [SQL] tags, else skip WebDNA altogether? (christophe.billiottet@webdna.us 2009)
  48. Re: [WebDNA] 3-5 GB of native WebDNA db in RAM?, else MySQL w/WebDNA [SQL] tags, else skip WebDNA altogether? (christophe.billiottet@webdna.us 2009)
  49. Re: [WebDNA] 3-5 GB of native WebDNA db in RAM?, else MySQL w/WebDNA [SQL] tags, else skip WebDNA altogether? (Govinda 2009)
  50. Re: [WebDNA] 3-5 GB of native WebDNA db in RAM?, else MySQL w/WebDNA (Donovan Brooke 2009)
  51. Re: [WebDNA] 3-5 GB of native WebDNA db in RAM?, else MySQL w/WebDNA [SQL] tags, else skip WebDNA altogether? (Patrick McCormick 2009)
  52. Re: [WebDNA] 3-5 GB of native WebDNA db in RAM?, else MySQL w/WebDNA [SQL] tags, else skip WebDNA altogether? (Govinda 2009)
  53. Re: [WebDNA] 3-5 GB of native WebDNA db in RAM?, else MySQL w/WebDNA (Donovan Brooke 2009)
  54. [WebDNA] 3-5 GB of native WebDNA db in RAM?, else MySQL w/WebDNA [SQL] tags, else skip WebDNA altogether? (Govinda 2009)
  55. Re: [WebDNA] Comparing 2 MySQL tables (Donovan Brooke 2009)
  56. [WebDNA] Comparing 2 MySQL tables (christophe.billiottet@webdna.us 2009)
  57. 2nd try... any mysql users in the house? ( Phil Herring 2007)
  58. Re: Grep Again (was: MySQL UPDATE) ( Clint Davis 2007)
  59. Grep Again (was: MySQL UPDATE) ( Clint Davis 2007)
  60. Re: MySQL UPDATE ( Marc Thompson 2007)
  61. MySQL UPDATE ( Clint Davis 2007)
  62. Re: MySQL 5/Float ( Clint Davis 2007)
  63. Re: MySQL 5/Float ( Jesse Proudman 2007)
  64. MySQL 5/Float ( Clint Davis 2007)
  65. Re: Help with searching dates from mysql dump & searching ( "Olin Lagon" 2006)
  66. Re: Help with searching dates from mysql dump & searching ( Gary Krockover 2006)
  67. Re: Help with searching dates from mysql dump & searching ( "Olin Lagon" 2006)
  68. Re: Help with searching dates from mysql dump & searching ( Gary Krockover 2006)
  69. Re: Help with searching dates from mysql dump & searching ( Gary Krockover 2006)
  70. Re: Help with searching dates from mysql dump & searching ( "Olin Lagon" 2006)
  71. Re: Help with searching dates from mysql dump & searching ( Grant Hulbert 2006)
  72. Help with searching dates from mysql dump & searching between ( "Olin Lagon" 2006)
  73. Re: MySQL Wildcard Trouble ( Adam O'Connor 2006)
  74. Re: MySQL Wildcard Trouble ( Adam O'Connor 2006)
  75. Re: MySQL Wildcard Trouble ( Sam McConnell 2006)
  76. Re: MySQL Wildcard Trouble ( Adam O'Connor 2006)
  77. Re: MySQL Wildcard Trouble ( Matthew Bohne 2006)
  78. MySQL Wildcard Trouble ( Sam McConnell 2006)
  79. Re: mySQL numfound ( Alex McCombie 2006)
  80. Re: MySQL & WebDNA on Windows ( Stuart Tremain 2006)
  81. Re: MySQL & WebDNA on Windows ( Adam O'Connor 2006)
  82. MySQL & WebDNA on Windows ( Stuart Tremain 2006)
  83. Re: mySQL numfound ( Adam O'Connor 2006)
  84. Re: mySQL numfound ( Alex McCombie 2006)
  85. Re: mySQL numfound ( 2006)
  86. Re: mySQL numfound ( Adam O'Connor 2006)
  87. Re: mySQL numfound ( nitai@computeroil.com 2006)
  88. Re: mySQL numfound ( Donovan Brooke 2006)
  89. Re: mySQL numfound ( Kenneth Grome 2006)
  90. mySQL numfound ( 2006)
  91. Re: OT: auto restart MySQL - System Preferences ( Jim Lanford 2006)
  92. Re: Webcat & MySQL Stored Procedures question -again ( "Nitai @ ComputerOil" 2005)
  93. Webcat & MySQL Stored Procedures question -again ( "Adam O'Connor" 2005)
  94. Stored Procedures using MySQL 5 ( "Adam O'Connor" 2005)
  95. Re: SM: MySQL and Numbers (BUG) ( Clint Davis 2005)
  96. Re: SM: MySQL and Numbers (BUG) ( Jesse Proudman 2005)
  97. Re: SM: MySQL and Numbers (BUG) ( Clint Davis 2005)
  98. Re: SM: MySQL and Numbers (BUG) ( Jesse Proudman 2005)
  99. SM: MySQL and Numbers (BUG) ( Clint Davis 2005)
  100. Re: MySQL and Numbers ( Clint Davis 2005)
  101. Re: MySQL and Numbers ( Thierry Almy 2005)
  102. Re: MySQL and Numbers ( Clint Davis 2005)
  103. Re: MySQL and Numbers ( nitai@computeroil.com 2005)
  104. Re: MySQL and Numbers ( Clint Davis 2005)
  105. Re: MySQL and Numbers ( Thierry Almy 2005)
  106. Re: MySQL and Numbers ( Clint Davis 2005)
  107. Re: MySQL and Numbers ( Thierry Almy 2005)
  108. Re: MySQL and Numbers ( nitai@computeroil.com 2005)
  109. MySQL and Numbers ( Thierry Almy 2005)
  110. Re: mysql errors ( "Chaim Klar" 2005)
  111. Re: mysql errors ( devaulw@onebox.com 2005)
  112. Re: mysql errors ( devaulw@onebox.com 2005)
  113. Re: mysql errors ( "Chaim Klar" 2005)
  114. Re: mysql errors ( devaulw@onebox.com 2005)
  115. mysql errors ( "webdna-talk" 2005)
  116. Re: MySQL TIME FORMAT ( Robert Mosebar 2005)
  117. Re: MySQL TIME FORMAT ( "Nitai @ ComputerOil" 2005)
  118. MySQL TIME_FORMAT ( Robert Mosebar 2005)
  119. Re: MySQL Dates and WebDNA ( "Nitai @ ComputerOil" 2005)
  120. Re: MySQL Dates and WebDNA ( "Scott Anderson" 2005)
  121. MySQL Dates and WebDNA ( "Nitai @ ComputerOil" 2005)
  122. Re: mySQL GROUP BY Aggregate Function Problem ( John Peacock 2005)
  123. Re: mySQL GROUP BY Aggregate Function Problem ( John Hill 2005)
  124. mySQL GROUP BY Aggregate Function Problem ( "Christian F. Gurney" 2005)
  125. Re: WebDNA - mySQL Questions ( John Peacock 2005)
  126. WebDNA - mySQL Questions ( "Christian F. Gurney" 2005)
  127. Re: Catch MySQL Connection error ( "Nitai @ ComputerOil" 2005)
  128. Re: Catch MySQL Connection error ( Larry Hewitt 2005)
  129. Catch MySQL Connection error ( "Nitai @ ComputerOil" 2005)
  130. Re: Note on MySQL Encrypt/Decrypt ( Donovan Brooke 2005)
  131. Note on MySQL Encrypt/Decrypt ( "Christian F. Gurney" 2005)
  132. Hint: WebDNA with MySQL 4.1.x ( "Nitai @ ComputerOil" 2005)
  133. Re: MySQL question ( "Scott Anderson" 2005)
  134. MySQL question ( Larry Hewitt 2005)
  135. Re: MySQL 4.1 ( "Nitai @ ComputerOil" 2004)
  136. MySQL 4.1 ( "Nitai @ ComputerOil" 2004)
  137. Re: Bug: MySQL WebDNA 6 int bigint fail case ( "Steve Contreras" 2004)
  138. Re: Bug: MySQL WebDNA 6 int bigint fail case ( Jim Lanford 2004)
  139. Re: Bug: MySQL WebDNA 6 int bigint fail case ( John Peacock 2004)
  140. Re: Bug: MySQL WebDNA 6 int bigint fail case ( Jim Lanford 2004)
  141. Re: Bug: MySQL WebDNA 6 int bigint fail case ( John Peacock 2004)
  142. Bug: MySQL WebDNA 6 int bigint fail case ( Jim Lanford 2004)
  143. Re: mySQL --- problem?? ( John Peacock 2004)
  144. Re: mySQL --- problem?? ( "Brian Boegershausen" 2004)
  145. Re: mySQL --- problem?? ( Larry Hewitt 2004)
  146. mySQL --- problem?? ( "Brian Boegershausen" 2004)
  147. Re: Using MySQL and WebDNA ( "Erol Guneri" 2004)
  148. Using MySQL and WebDNA ( "Edwin Hoevers" 2004)
  149. Using MySQL and WebDNA ( "Edwin Hoevers" 2004)
  150. Re: MySQL and Decimals ( "Sal" 2004)
  151. Re: MySQL and Decimals ( Larry Hewitt 2004)
  152. Re: MySQL and Decimals ( John Peacock 2004)
  153. Re: MySQL and Decimals ( Larry Hewitt 2004)
  154. Re: MySQL and Decimals ( Larry Hewitt 2004)
  155. Re: MySQL and Decimals ( Larry Hewitt 2004)
  156. Re: MySQL and Decimals ( John Peacock 2004)
  157. MySQL and Decimals ( Larry Hewitt 2004)
  158. Re: [OT] Connect to MySQL (Solved) ( "Nitai @ ComputerOil" 2004)
  159. Re: [OT] MySQL Expert Needed ( Alain Russell 2004)
  160. [OT] MySQL Expert Needed ( Clint Davis 2004)
  161. Re: WebDNA - MySQL - PHP (Alain Russell 2003)
  162. Re: WebDNA - MySQL - PHP (Gary Krockover 2003)
  163. WebDNA - MySQL - PHP (Brian Boegershausen 2003)
  164. Re: MySQL and WebDNA (Alain Russell 2002)
  165. Re: MySQL blob question, Netscape slow question (Glenn Busbin 2002)
  166. Re: MySQL blob question, Netscape slow question (John Peacock 2002)
  167. binary data in mySQL database (Ben Swihart 2002)
  168. Re: WC + MYSQL + ODBC (Alain Russell 2002)
  169. Re: WC + MYSQL + ODBC (Nitai @ ComputerOil 2002)
  170. WC + MYSQL + ODBC (Eric MULLER 2002)
  171. : fyi: getting ODBC MySQL ready for WebCat (Jim Lanford 2001)
  172. Re: mySQL or MS SQL (John Peacock 2000)
  173. Re: mySQL or MS SQL (John 2000)
  174. WebDNA: Innovative alternative to MySQL including a powerful scripting language (WebDNA Team
Thanks Adam That should keep me busy for a while :) Stuart Tremain idfk web developments, sydney, australia On 03 Apr 2006, at 8:57 AM, Adam O'Connor wrote: > Stuart, > > Its pretty straight forward, 1) Install the latest community > edition of MySQL; 2) Configure MySQL by creating a root user > account, along with perhaps two others (siteuser and admin > accounts); 3) Create a databases (schema); 4) Create your tables; > thats it. You may want to grab the MySQL administrator and Query > Analyzer while you getting MySQL, they make databases > administration and query testing easier - or - you can grab a third > party GUI such as NaviCat -which is very much like MS SQL > Enterprise/Query Analyzer. > You will use webcat's native SQL features, 1) Create a connection; > 2) Send SQL to the db; 3) Manage your returned recordset, if there > is one. This is it in a nutshell, of course MySQL has lots of > features and configurations methods, something to look into as you > get more familiar with using it. > > Have fun. > > > > > > Stuart Tremain wrote: >> After all this talk about mySQL, I have decided to put it onto a >> development machine and give it a go. >> >> Could someone please give me a rundown on setting it up on a >> windows server so that it will work with WebDNA ? >> >> Stuart Tremain >> idfk web developments, sydney, australia >> >> >> >> ------------------------------------------------------------- >> This message is sent to you because you are subscribed to >> the mailing list . >> To unsubscribe, E-mail to: >> To switch to the DIGEST mode, E-mail to > digest@talk.smithmicro.com> >> Web Archive of this list is at: http://webdna.smithmicro.com/ > > > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to digest@talk.smithmicro.com> > Web Archive of this list is at: http://webdna.smithmicro.com/ ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Stuart Tremain

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

Searchtitle (2000) Training Tapes Improved (1998) PIXO with cometsite ... and/or other plugins (1998) show all problem (1997) Shopping problems with 2.1b3 acgi (1997) Separate SSL Server (1997) Multiple catalog databases and showcart (1997) [WebDNA] Send Mail and SMTP Host (2015) RE: Supressing Error Messages (1998) Secure Server (1997) Creating 404 Not Found pages (1999) Changes to the List (1997) Online reference (1997) group searching problem (2002) problems with 2 tags shakur (1997) [shell] (2002) TCPConnect / Current Temperature (2004) Locking up with WebCatalog... (1997) PIXO support (1997) Retirement (2000)