{"id":75998,"date":"2024-05-05T15:10:04","date_gmt":"2024-05-05T19:10:04","guid":{"rendered":"https:\/\/bangla.sitestree.com\/?p=75998"},"modified":"2024-05-05T15:10:04","modified_gmt":"2024-05-05T19:10:04","slug":"sample-mysql-configurations-application-properties","status":"publish","type":"post","link":"http:\/\/bangla.sitestree.com\/?p=75998","title":{"rendered":"Sample MySQL Configurations (application.properties)"},"content":{"rendered":"

\"\"<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[182],"tags":[],"class_list":["post-75998","post","type-post","status-publish","format-standard","hentry","category---blog","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":75998,"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 "AI ML DS RL DL NN NLP Data Mining Optimization"","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":16439,"url":"http:\/\/bangla.sitestree.com\/?p=16439","url_meta":{"origin":75998,"position":1},"title":"Mysql error after upgrading magento 2.3.2 to 2.3.3","author":"Sayed","date":"November 30, 2019","format":false,"excerpt":"Solution to: SQLSTATE[HY000]: General error: 1419 You do not have the SUPER privilege and binary logging is enabled (you might want to use the less safe log_bin_trust_function_creators variable), query was: CREATE TRIGGER trg_catalog_product_entity_after_insert AFTER INSERT ON catalog_product_entity FOR EACH ROW BEGIN INSERT IGNORE INTO `scconnector_google_feed_cl` (`entity_id`) VALUES (NEW.`entity_id`); END Sol:\u2026","rel":"","context":"In "AI ML DS RL DL NN NLP Data Mining Optimization"","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":68268,"url":"http:\/\/bangla.sitestree.com\/?p=68268","url_meta":{"origin":75998,"position":2},"title":"BiGDump #Blog #DevOps","author":"Author-Check- Article-or-Video","date":"July 31, 2021","format":false,"excerpt":"If you are having issues to import large SQL files, one possible solution is BiGDump script. However, accessing the server through ssh and using mysql command to import\/restore will work as well (and the better solution). I just tried BigDump - it worked pretty well for me. The idea is\u2026","rel":"","context":"In "FromSitesTree.com"","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":14893,"url":"http:\/\/bangla.sitestree.com\/?p=14893","url_meta":{"origin":75998,"position":3},"title":"AI\/ML\/Data Science: Cross Validation: KFold Cross validation: Concepts, Examples, Projects","author":"Sayed","date":"July 9, 2019","format":false,"excerpt":"Train\/Test Split and Cross Validation in Python https:\/\/towardsdatascience.com\/train-test-split-and-cross-validation-in-python-80b61beca4b6 sklearn.ensemble.RandomForestRegressor\u00b6 https:\/\/scikit-learn.org\/stable\/modules\/generated\/sklearn.ensemble.RandomForestRegressor.html \"A random forest regressor. A random forest is a meta estimator that fits a number of classifying decision trees on various sub-samples of the dataset and uses averaging to improve the predictive accuracy and control over-fitting. The sub-sample size is\u2026","rel":"","context":"In "AI ML DS RL DL NN NLP Data Mining Optimization"","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":75870,"url":"http:\/\/bangla.sitestree.com\/?p=75870","url_meta":{"origin":75998,"position":4},"title":"PHP Topics to Learn","author":"Sayed","date":"August 1, 2023","format":false,"excerpt":"Identifiers https:\/\/docstore.mik.ua\/orelly\/webprog\/php\/ch02_01.htm#:~:text=An%20identifier%20is%20simply%20a,ASCII%200x7F%20and%20ASCII%200xFF. PHP Data Types https:\/\/www.odinschool.com\/learning-hub\/php\/datatypes Type Hinting https:\/\/www.honeybadger.io\/blog\/php-type-hinting\/#:~:text=Type%2Dhinting%20means%20explicitly%20stating,to%20write%20more%20robust%20code. PDO and MySQL https:\/\/www.w3schools.com\/php\/php_mysql_connect.asp PHP OOP https:\/\/www.w3schools.com\/php\/php_oop_what_is.asp abstract classes https:\/\/www.w3schools.com\/php\/php_oop_classes_abstract.asp Abstract vs Interface https:\/\/www.w3schools.com\/php\/php_oop_interfaces.asp#:~:text=PHP%20%2D%20Interfaces%20vs.%20Abstract%20Classes&text=Interfaces%20cannot%20have%20properties%2C%20while,abstract%20keyword%20is%20not%20necessary , methods, interfaces, and inheritance Pillars of OOP The Four pillars of OOPs, abstraction, encapsulation, inheritance, and polymorphism, are integral to understanding and using OOP https:\/\/datatrained.com\/post\/four-pillars-of-oops\/#:~:text=The%20Four%20pillars%20of%20OOPs%2C%20abstraction%2C%20encapsulation%2C%20inheritance%2C,to%20understanding%20and%20using%20OOP. Four\u2026","rel":"","context":"In "PHP"","block_context":{"text":"PHP","link":"http:\/\/bangla.sitestree.com\/?cat=1427"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":19426,"url":"http:\/\/bangla.sitestree.com\/?p=19426","url_meta":{"origin":75998,"position":5},"title":"WordPress Tips","author":"Sayed","date":"January 30, 2021","format":false,"excerpt":"20 Time-Saving WordPress SQL Query Snippets https:\/\/speckyboy.com\/wordpress-sql-query-snippets\/ 20 Code Snippets for Extending the Functionality of WordPress How to Add SSL to Your WordPress Website 10 Best Free Security Plugins for WordPress How to Avoid Common WordPress Theme Development Mistakes Getting Started with WordPress Shortcodes & Sample Snippets Styling Wide and\u2026","rel":"","context":"In "\u09ac\u09cd\u09b2\u0997 \u0964 Blog"","block_context":{"text":"\u09ac\u09cd\u09b2\u0997 \u0964 Blog","link":"http:\/\/bangla.sitestree.com\/?cat=182"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/75998","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\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=75998"}],"version-history":[{"count":1,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/75998\/revisions"}],"predecessor-version":[{"id":76000,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/75998\/revisions\/76000"}],"wp:attachment":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=75998"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=75998"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=75998"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}