{"id":69097,"date":"2021-08-12T00:03:14","date_gmt":"2021-08-12T04:03:14","guid":{"rendered":"http:\/\/bangla.salearningschool.com\/recent-posts\/mysql-resources-mysql-start-5\/"},"modified":"2021-08-12T00:03:14","modified_gmt":"2021-08-12T04:03:14","slug":"mysql-resources-mysql-start-5","status":"publish","type":"post","link":"http:\/\/bangla.sitestree.com\/?p=69097","title":{"rendered":"MySQL Resources: MySQL Start #5"},"content":{"rendered":"<h2>Mysql Resources:<\/h2>\n<p>First you need the latest\/stable version of MySQL. Right now 6.0 is the latest version. Mysql has two different releases like:<br \/>community server[free] <br \/>enterprise server[commercial]<\/p>\n<p>Note: MAXDB is the current full package with many features that may not be fully tested. <\/p>\n<h2>Download MySQL:<\/h2>\n<p>You can download MySQL from<\/p>\n<p>http:\/\/dev.mysql.com\/downloads\/mysql\/5.0.html <\/p>\n<p>Check the lower portion of the webpage.<\/p>\n<h2>Working with Mysql:<\/h2>\n<p>After installation you can interact with MySQL server through command line[Best to become guru]. But you may also want to use GUI IDE to interact with. GUI tools can be downloaded from:<\/p>\n<p>http:\/\/dev.mysql.com\/downloads\/gui-tools\/5.0.html <\/p>\n<p>GUI are of two types: to administer MySQL server. Used for backup, restore, security <\/p>\n<p>Development: For creating Database and interact with database using tables, Queries, Stored procedures, triggers<\/p>\n<p><\/p>\n<h2>Application Development:<\/h2>\n<p>You can build appications that use MySQL databases at the backend. You can use languages like PHP, Perl, Java, .net to interact with MySQL databases. Usually, the package for these languages contain a driver to provide the functionalities. Otherwise, you can download drivers from:<\/p>\n<p>http:\/\/dev.mysql.com\/downloads\/connector\/ <\/p>\n<p>for many different programming languages like Java, PHP, Perl and similar.<\/p>\n<p>From: http:\/\/sitestree.com\/?p=4728<br \/> Categories:5<br \/>Tags:<br \/> Post Data:2009-01-22 07:30:25<\/p>\n<pre><code>    Shop Online: &lt;a href='https:\/\/www.ShopForSoul.com\/' target='new' rel=\"noopener\"&gt;https:\/\/www.ShopForSoul.com\/&lt;\/a&gt;\n    (Big Data, Cloud, Security, Machine Learning): Courses: &lt;a href='http:\/\/Training.SitesTree.com' target='new' rel=\"noopener\"&gt; http:\/\/Training.SitesTree.com&lt;\/a&gt; \n    In Bengali: &lt;a href='http:\/\/Bangla.SaLearningSchool.com' target='new' rel=\"noopener\"&gt;http:\/\/Bangla.SaLearningSchool.com&lt;\/a&gt;\n    &lt;a href='http:\/\/SitesTree.com' target='new' rel=\"noopener\"&gt;http:\/\/SitesTree.com&lt;\/a&gt;\n    8112223 Canada Inc.\/JustEtc: &lt;a href='http:\/\/JustEtc.net' target='new' rel=\"noopener\"&gt;http:\/\/JustEtc.net (Software\/Web\/Mobile\/Big-Data\/Machine Learning) &lt;\/a&gt;\n    Shop Online: &lt;a href='https:\/\/www.ShopForSoul.com'&gt; https:\/\/www.ShopForSoul.com\/&lt;\/a&gt;\n    Medium: &lt;a href='https:\/\/medium.com\/@SayedAhmedCanada' target='new' rel=\"noopener\"&gt; https:\/\/medium.com\/@SayedAhmedCanada &lt;\/a&gt;\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Mysql Resources: First you need the latest\/stable version of MySQL. Right now 6.0 is the latest version. Mysql has two different releases like:community server[free] enterprise server[commercial] Note: MAXDB is the current full package with many features that may not be fully tested. Download MySQL: You can download MySQL from http:\/\/dev.mysql.com\/downloads\/mysql\/5.0.html Check the lower portion of &hellip; <\/p>\n<p><a class=\"more-link btn\" href=\"http:\/\/bangla.sitestree.com\/?p=69097\">Continue reading<\/a><\/p>\n","protected":false},"author":8,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1917],"tags":[],"class_list":["post-69097","post","type-post","status-publish","format-standard","hentry","category-fromsitestree-com","item-wrap"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":7729,"url":"http:\/\/bangla.sitestree.com\/?p=7729","url_meta":{"origin":69097,"position":0},"title":"MySQL \u09ac\u09bf\u09b7\u09df \u0997\u09c1\u09b2\u09cb: MySQL \u09b6\u09c1\u09b0\u09c1","author":"Author-Check- Article-or-Video","date":"March 28, 2015","format":false,"excerpt":"MySQL \u09ac\u09bf\u09b7\u09df \u0997\u09c1\u09b2\u09cb: MySQL \u09b6\u09c1\u09b0\u09c1 \u09ae\u09cb\u0983 \u0986\u09a8\u09bf\u09b8\u09c1\u09b0 \u09b0\u09b9\u09ae\u09be\u09a8 \u0987\u09ae\u09a8 https:\/\/www.facebook.com\/casperemon Mysql Resources: \u09aa\u09cd\u09b0\u09a5\u09ae\u09c7 \u0986\u09aa\u09a8\u09be\u0995\u09c7 MySQL \u098f\u09b0 \u09b8\u09b0\u09cd\u09ac\u09b6\u09c7\u09b7 \u09ad\u09be\u09b0\u09cd\u09b6\u09a8 \u0985\u09a5\u09ac\u09be \u09b8\u09cd\u09a5\u09bf\u09a5\u09bf\u09b6\u09bf\u09b2 \u09ad\u09be\u09b0\u09cd\u09b6\u09a8 \u099f\u09bf \u09b8\u0982\u0997\u09cd\u09b0\u09b9 \u0995\u09b0\u09a4\u09c7 \u09b9\u09ac\u09c7\u0964 \u098f\u0996\u09a8 \u09b8\u09b0\u09cd\u09ac\u09b6\u09c7\u09b7 \u09ad\u09be\u09b0\u09cd\u09b6\u09a8 \u09eb.\u09ec.\u09e7\u09ec \u0964 Mysql \u098f\u09b0 \u09a6\u09c1\u099f\u09bf \u09ad\u09bf\u09a8\u09cd\u09a8 \u09b8\u0982\u09b8\u09cd\u0995\u09b0\u09a8 \u0986\u099b\u09c7 \u0964 \u098f\u0995\u099f\u09bf \u09b9\u09b2 community server[\u09ab\u09cd\u09b0\u09c0] \u098f\u09ac\u0982 \u0985\u09a8\u09cd\u09af\u099f\u09bf enterprise server[\u09ac\u09be\u09a3\u09bf\u099c\u09cd\u09af\u09bf\u0995] MySQL \u09a1\u09be\u0989\u09a8\u09b2\u09cb\u09a1 \u0995\u09b0\u09be: \u0986\u09aa\u09a8\u09bf \u09a8\u09bf\u099a\u09c7\u09b0\u2026","rel":"","context":"In &quot;\u09ae\u09be\u0987 \u098f\u09b8 \u0995\u09bf\u0989 \u098f\u09b2 \/MYSQL&quot;","block_context":{"text":"\u09ae\u09be\u0987 \u098f\u09b8 \u0995\u09bf\u0989 \u098f\u09b2 \/MYSQL","link":"http:\/\/bangla.sitestree.com\/?cat=257"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":67775,"url":"http:\/\/bangla.sitestree.com\/?p=67775","url_meta":{"origin":69097,"position":1},"title":"How to install and Use MySQL GUI Tools #By Sayed Ahmed #MySQL","author":"Author-Check- Article-or-Video","date":"July 28, 2021","format":false,"excerpt":"How to install and Use MySQL GUI Tools [youtube https:\/\/www.youtube.com\/watch?v=GN9UxbNvCS4&w=640&h=360] From: http:\/\/sitestree.com\/?p=3880 Categories:By Sayed Ahmed, MySQLTags:MySQL, MySQL GUI Tools, MySQL Query Browser, MySQL Migration Tools Post Data:2016-08-22 16:53:53 Shop Online: https:\/\/www.ShopForSoul.com\/ (Big Data, Cloud, Security, Machine Learning): Courses: http:\/\/Training.SitesTree.com In Bengali: http:\/\/Bangla.SaLearningSchool.com http:\/\/SitesTree.com 8112223 Canada Inc.\/JustEtc: http:\/\/JustEtc.net (Software\/Web\/Mobile\/Big-Data\/Machine Learning) Shop\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":75589,"url":"http:\/\/bangla.sitestree.com\/?p=75589","url_meta":{"origin":69097,"position":2},"title":"how to install MySQL GUI Tools","author":"Sayed","date":"February 26, 2023","format":false,"excerpt":"https:\/\/youtu.be\/GN9UxbNvCS4","rel":"","context":"In &quot;From Youtube Channel&quot;","block_context":{"text":"From Youtube Channel","link":"http:\/\/bangla.sitestree.com\/?cat=1952"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/img.youtube.com\/vi\/GN9UxbNvCS4\/0.jpg?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":67777,"url":"http:\/\/bangla.sitestree.com\/?p=67777","url_meta":{"origin":69097,"position":3},"title":"How to install and Use MySQL Query Browser #By Sayed Ahmed #MySQL","author":"Author-Check- Article-or-Video","date":"July 28, 2021","format":false,"excerpt":"How to install and Use MySQL Query Browser From: http:\/\/sitestree.com\/?p=3882 Categories:By Sayed Ahmed, MySQLTags:MySQL, MySQL GUI Tools, MySQL Query Browser, MySQL Security Post Data:2016-08-22 16:58:23 Shop Online: https:\/\/www.ShopForSoul.com\/ (Big Data, Cloud, Security, Machine Learning): Courses: http:\/\/Training.SitesTree.com In Bengali: http:\/\/Bangla.SaLearningSchool.com http:\/\/SitesTree.com 8112223 Canada Inc.\/JustEtc: http:\/\/JustEtc.net (Software\/Web\/Mobile\/Big-Data\/Machine Learning) Shop Online: https:\/\/www.ShopForSoul.com\/ Medium:\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":16499,"url":"http:\/\/bangla.sitestree.com\/?p=16499","url_meta":{"origin":69097,"position":4},"title":"Mysql: Repair database and\/or tables","author":"Sayed","date":"December 9, 2019","format":false,"excerpt":"\" mysqldump db_name t1 > dump.sql mysql db_name < dump.sql mysqldump db_name > dump.sql mysql db_name < dump.sql mysqldump --all-databases > dump.sql mysql < dump.sql ALTER TABLE t1 ENGINE = InnoDB; REPAIR TABLE t1; mysqlcheck --repair --databases db_name ... mysqlcheck --repair --all-databases \" Reference: https:\/\/dev.mysql.com\/doc\/refman\/5.7\/en\/rebuilding-tables.html --- Sayed Ahmed BSc. Eng.\u2026","rel":"","context":"In &quot;AI ML DS RL DL NN NLP Data Mining Optimization&quot;","block_context":{"text":"AI ML DS RL DL NN NLP Data Mining Optimization","link":"http:\/\/bangla.sitestree.com\/?cat=1910"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":70215,"url":"http:\/\/bangla.sitestree.com\/?p=70215","url_meta":{"origin":69097,"position":5},"title":"Must Read: Database Driven Software Development #106","author":"Author-Check- Article-or-Video","date":"August 29, 2021","format":false,"excerpt":"If you are developing database driven applications, you must need to know and clearly understand the following concepts. Yes, you also need to apply them in your design and implementation. If you do not follow proper database design strategies, many complexities will arise, adjusting new requirements may become cumbersome to\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/69097","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=69097"}],"version-history":[{"count":0,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/69097\/revisions"}],"wp:attachment":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=69097"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=69097"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=69097"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}