{"id":21634,"date":"2021-03-03T20:40:45","date_gmt":"2021-03-04T01:40:45","guid":{"rendered":"http:\/\/bangla.salearningschool.com\/recent-posts\/optimize-your-mysql-tables-in-phpmyadmin-web-development-by-sayed-ahmed\/"},"modified":"2021-03-03T20:40:45","modified_gmt":"2021-03-04T01:40:45","slug":"optimize-your-mysql-tables-in-phpmyadmin-web-development-by-sayed-ahmed","status":"publish","type":"post","link":"http:\/\/bangla.sitestree.com\/?p=21634","title":{"rendered":"Optimize your MySQL tables in PhpMyAdmin #Web Development #By Sayed Ahmed"},"content":{"rendered":"<p>Enter your phpMyAdmin\/MySQL control panel. Click on the database (not the table, the database name), and on the right hand column your tables should be listed. Scroll down till you see the .Check all. link. Click on that link, make sure all database tables are checked and then from the drop-down next to it, and carefully select .Optimize table..<\/p>\n<p>&nbsp;<\/p>\n<p>Additionally, adding indexes to your table(s) may improve performance.<\/p>\n<p>&nbsp;<\/p>\n<p>You can also try the repair tables, analyze tables. From: http:\/\/sitestree.com\/?p=817<br \/> Categories:Web Development, By Sayed Ahmed<br \/>Tags:<br \/> Post Data:2014-02-08 22:35:50<\/p>\n<p>\t\tShop Online: https:\/\/www.ShopForSoul.com\/<br \/>\n\t\t(Big Data, Cloud, Security, Machine Learning): Courses:http:\/\/Training.SitesTree.com<br \/>\n\t\tBlog: http:\/\/Bangla.SaLearningSchool.com<br \/>\n\t\thttp:\/\/SitesTree.com<br \/>\n\t\t8112223 Canada Inc.\/JustEtc: http:\/\/JustEtc.net (Software\/Web\/Mobile\/Big-Data\/Machine Learning)<br \/>\n\t\tShop Online: https:\/\/www.ShopForSoul.com\/<br \/>\n\t\tMedium: https:\/\/medium.com\/@SayedAhmedCanada<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Enter your phpMyAdmin\/MySQL control panel. Click on the database (not the table, the database name), and on the right hand column your tables should be listed. Scroll down till you see the .Check all. link. Click on that link, make sure all database tables are checked and then from the drop-down next to it, and &hellip; <\/p>\n<p><a class=\"more-link btn\" href=\"http:\/\/bangla.sitestree.com\/?p=21634\">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-21634","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":16499,"url":"http:\/\/bangla.sitestree.com\/?p=16499","url_meta":{"origin":21634,"position":0},"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":22790,"url":"http:\/\/bangla.sitestree.com\/?p=22790","url_meta":{"origin":21634,"position":1},"title":"Working with VisitorsShop.com PHPMyAdmin WHM Cpanel MySQL #Root #By Sayed Ahmed","author":"Author-Check- Article-or-Video","date":"March 20, 2021","format":false,"excerpt":"Working with visitorsshop.com phpmyadmin whm cpanel mysql WHM - web hosting manager Cpanel - web hosting control panel PHPMyAdmin - MySQL IDE \u00a0 [youtube http:\/\/www.youtube.com\/watch?v=1TtD_o4Z1WY?feature=player_detailpage&w=640&h=360] From: http:\/\/sitestree.com\/?p=1497 Categories:Root, By Sayed AhmedTags: Post Data:2014-09-10 21:16:22 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\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":69428,"url":"http:\/\/bangla.sitestree.com\/?p=69428","url_meta":{"origin":21634,"position":2},"title":"Tools to create ER diagrams from a database dynamically #2","author":"Author-Check- Article-or-Video","date":"August 20, 2021","format":false,"excerpt":"Microsoft Visio, and dbVisualizer provide features to create ER diagrams from existing database tables.Why needed?ER diagram is very useful to understand the total database structure that helps a new programmer to work on the existing databases more efficiently.Visio:While creating Database diagrams, a menu item named database is displayed. Reverse Engineering\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":68481,"url":"http:\/\/bangla.sitestree.com\/?p=68481","url_meta":{"origin":21634,"position":3},"title":"How to Convert Microsoft Access Database to MySQL Database #90","author":"Author-Check- Article-or-Video","date":"August 4, 2021","format":false,"excerpt":"Approaches: Access exports its own tables: write access table data in a text file then use load data command from mysql to load those data in a table. Example: select access table->right click->export. From MySQL: run the queryLOAD DATA LOCAL INFILE 'c:student.txt' INTO TABLE student FIELDS TERMINATED BY ',' LINES\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":70215,"url":"http:\/\/bangla.sitestree.com\/?p=70215","url_meta":{"origin":21634,"position":4},"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":[]},{"id":69091,"url":"http:\/\/bangla.sitestree.com\/?p=69091","url_meta":{"origin":21634,"position":5},"title":"MySql Administration SQL Commands #5","author":"Author-Check- Article-or-Video","date":"August 12, 2021","format":false,"excerpt":"Using MySQL, AdministrationWorkshop RequirementsYou should have access to the MySQL command line client software.Various different PRIVILEGES on the MySQL ServerIntroductionIn the other MySQL Virtual Workshops we have used commands that are pretty much applicable to anyone. This part of the MySQL series is aimed at giving a rudimentary understanding of\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\/21634","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=21634"}],"version-history":[{"count":0,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/21634\/revisions"}],"wp:attachment":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=21634"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=21634"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=21634"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}