{"id":19,"date":"2009-06-08T17:19:19","date_gmt":"2009-06-08T07:19:19","guid":{"rendered":"http:\/\/www.desiderata.com.au\/blog\/?page_id=19"},"modified":"2009-07-01T10:43:22","modified_gmt":"2009-07-01T00:43:22","slug":"mysql-notes","status":"publish","type":"page","link":"https:\/\/www.desiderata.com.au\/blog\/?page_id=19","title":{"rendered":"mySQL"},"content":{"rendered":"<p><strong>Information about MySQL.<\/strong><\/p>\n<p>An installation for MS Windows is available for free and the zipped setup file is a 45Mb download which requires some configuration during installation such as root password, and various configuration settings such max. connections, character set to use, and then once installs, it has a footprint of ~109Mb &#8211; MUCH bigger and more complex than <a href=\"http:\/\/www.desiderata.com.au\/blog\/?page_id=81\">BlackfishSQL<\/a> but it does not need .NET or java to be installed.<\/p>\n<p><a href=\"http:\/\/search.mysql.com\/search?q=doc&amp;lr=lang_en\">mySQL reference manual:<\/a><\/p>\n<ul>\n<li><a href=\"http:\/\/dev.mysql.com\/doc\/refman\/5.1\/en\/\">v5.1 reference manual<\/a><\/li>\n<\/ul>\n<p><a href=\"http:\/\/www.wikihow.com\/Install-the-MySQL-Database-Server-on-Your-Windows-PC\">Installing mySQL on Windows<\/a><\/p>\n<p><a href=\"http:\/\/dev.mysql.com\/tech-resources\/articles\/4.1\/installer.html\">MySQL Windows installer<\/a><\/p>\n<p><a href=\"http:\/\/hashmysql.org\/index.php?title=Main_Page\">Freenode&#8217;s mySQL wiki<\/a>:<strong><br \/>\n<\/strong><\/p>\n<ul>\n<li><a href=\"http:\/\/hashmysql.org\/index.php?title=Autoincrement_FAQ#How_do_I_get_the_last_inserted_auto_increment_value.3F\">autoincrement faqs<\/a><\/li>\n<\/ul>\n<p><strong>PhP database commands:<\/strong><\/p>\n<ul>\n<li><a href=\"http:\/\/us3.php.net\/manual\/en\/book.mysql.php\">php.net manual<\/a><\/li>\n<\/ul>\n<p><strong>Useful links:<\/strong><\/p>\n<ul>\n<li><a href=\"http:\/\/www.devshed.com\/c\/a\/MySQL\/Backing-up-and-restoring-your-MySQL-Database\/4\/\">Backing up and restoring a MySQL database<\/a><\/li>\n<li><a href=\"http:\/\/www.devshed.com\/c\/a\/MySQL\/Backing-up-and-restoring-your-MySQL-Database\/4\/\">MyDAC &#8211; Delphi VCL connection components for native mySQL database<\/a><\/li>\n<li><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Information about MySQL. An installation for MS Windows is available for free and the zipped setup file is a 45Mb download which requires some configuration during installation such as root password, and various configuration settings such max. connections, character set &hellip; <a href=\"https:\/\/www.desiderata.com.au\/blog\/?page_id=19\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"open","template":"","meta":{"footnotes":""},"class_list":["post-19","page","type-page","status-publish","hentry"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.desiderata.com.au\/blog\/index.php?rest_route=\/wp\/v2\/pages\/19","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.desiderata.com.au\/blog\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.desiderata.com.au\/blog\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.desiderata.com.au\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.desiderata.com.au\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=19"}],"version-history":[{"count":12,"href":"https:\/\/www.desiderata.com.au\/blog\/index.php?rest_route=\/wp\/v2\/pages\/19\/revisions"}],"predecessor-version":[{"id":21,"href":"https:\/\/www.desiderata.com.au\/blog\/index.php?rest_route=\/wp\/v2\/pages\/19\/revisions\/21"}],"wp:attachment":[{"href":"https:\/\/www.desiderata.com.au\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=19"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}