{"id":68481,"date":"2021-08-04T04:10:06","date_gmt":"2021-08-04T08:10:06","guid":{"rendered":"http:\/\/bangla.salearningschool.com\/recent-posts\/how-to-convert-microsoft-access-database-to-mysql-database-90\/"},"modified":"2021-08-04T04:10:06","modified_gmt":"2021-08-04T08:10:06","slug":"how-to-convert-microsoft-access-database-to-mysql-database-90","status":"publish","type":"post","link":"http:\/\/bangla.sitestree.com\/?p=68481","title":{"rendered":"How to Convert Microsoft Access Database to MySQL Database #90"},"content":{"rendered":"<ul>\n<li> Approaches:\n<ul>\n<li>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-&gt;right click-&gt;export. From MySQL: run the queryLOAD DATA LOCAL INFILE &#8216;c:student.txt&#8217; INTO TABLE student FIELDS TERMINATED BY &#8216;,&#8217; LINES TERMINATED BY &#8216;rn&#8217;; <br \/>Syntax:\n<pre>LOAD DATA INFILE SyntaxLOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE 'file_name'    [REPLACE | IGNORE]    INTO TABLE tbl_name    [CHARACTER SET charset_name]    [FIELDS        [TERMINATED BY 'string']        [[OPTIONALLY] ENCLOSED BY 'char']        [ESCAPED BY 'char']    ]    [LINES        [STARTING BY 'string']        [TERMINATED BY 'string']    ]    [IGNORE number LINES]    [(col_name_or_user_var,...)]    [SET col_name = expr,...]<\/pre>\n<\/li>\n<li> You can also use mysqlimporti command. Such as: <a href='http:\/\/www.informit.com\/articles\/article.aspx?p=174365&amp;seqNum=3'>Check the syntax here<\/a>        <\/li>\n<li> For converting you can also use: Converters That Generate Intermediate Files : Some converters can create sql files based on your access database. Then use MySQL tools to convert: mysql -h some_host -p -u some_user mydb &lt; file.sql<\/li>\n<li> Converters That Perform Direct Data Transfer:<a href='http:\/\/www.bullzip.com\/products\/a2m\/info.php' target='new' rel=\"noopener\">Use Access to MySQL Tool<\/a><\/li>\n<\/ul>\n<\/li>\n<li> <a href='http:\/\/www.kitebird.com\/articles\/access-migrate.html' target='new' rel=\"noopener\">A Great Resource<\/a> <\/li>\n<\/ul>\n<p> From: http:\/\/sitestree.com\/?p=5130<br \/> Categories:90<br \/>Tags:<br \/> Post Data:2011-01-29 22:20:26<\/p>\n<p>\t\tShop Online: <a href='https:\/\/www.ShopForSoul.com\/' target='new' rel=\"noopener\">https:\/\/www.ShopForSoul.com\/<\/a><br \/>\n\t\t(Big Data, Cloud, Security, Machine Learning): Courses: <a href='http:\/\/Training.SitesTree.com' target='new' rel=\"noopener\"> http:\/\/Training.SitesTree.com<\/a><br \/>\n\t\tIn Bengali: <a href='http:\/\/Bangla.SaLearningSchool.com' target='new' rel=\"noopener\">http:\/\/Bangla.SaLearningSchool.com<\/a><br \/>\n\t\t<a href='http:\/\/SitesTree.com' target='new' rel=\"noopener\">http:\/\/SitesTree.com<\/a><br \/>\n\t\t8112223 Canada Inc.\/JustEtc: <a href='http:\/\/JustEtc.net' target='new' rel=\"noopener\">http:\/\/JustEtc.net (Software\/Web\/Mobile\/Big-Data\/Machine Learning) <\/a><br \/>\n\t\tShop Online: <a href='https:\/\/www.ShopForSoul.com'> https:\/\/www.ShopForSoul.com\/<\/a><br \/>\n\t\tMedium: <a href='https:\/\/medium.com\/@SayedAhmedCanada' target='new' rel=\"noopener\"> https:\/\/medium.com\/@SayedAhmedCanada <\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>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-&gt;right click-&gt;export. From MySQL: run the queryLOAD DATA LOCAL INFILE &#8216;c:student.txt&#8217; INTO TABLE student FIELDS TERMINATED BY &#8216;,&#8217; LINES TERMINATED BY &#8216;rn&#8217;; Syntax: LOAD &hellip; <\/p>\n<p><a class=\"more-link btn\" href=\"http:\/\/bangla.sitestree.com\/?p=68481\">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-68481","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":69091,"url":"http:\/\/bangla.sitestree.com\/?p=69091","url_meta":{"origin":68481,"position":0},"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":[]},{"id":70215,"url":"http:\/\/bangla.sitestree.com\/?p=70215","url_meta":{"origin":68481,"position":1},"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":70063,"url":"http:\/\/bangla.sitestree.com\/?p=70063","url_meta":{"origin":68481,"position":2},"title":"Cheat Sheets for Better Productivity #16","author":"Author-Check- Article-or-Video","date":"August 24, 2021","format":false,"excerpt":"Cheat sheets can increase productivity in programming. How?In a cheat sheet, you can write down different functions [with parameters and syntax] that you use frequently [or all the important functions of a programming language]. Whenever, you are confused, take a quick look at the cheat sheets. Sometimes it can be\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":5941,"url":"http:\/\/bangla.sitestree.com\/?p=5941","url_meta":{"origin":68481,"position":3},"title":"SQL DROP INDEX, DROP TABLE, and DROP DATABASE","author":"Author-Check- Article-or-Video","date":"January 30, 2015","format":false,"excerpt":"Title: SQL DROP INDEX, DROP TABLE, and DROP DATABASE \u0985\u09a8\u09c1\u09ac\u09be\u09a6\u0995: \u09ab\u09df\u09b8\u09be\u09b2 \u09b0\u0995\u09bf (\u098f\u09ae.\u098f) Total word count: 164 DROP statement \u098f\u09b0 \u09b8\u09be\u09b9\u09be\u09af\u09cd\u09af\u09c7 Indexes, tables \u0995\u09bf\u0982\u09ac\u09be databases \u0995\u09c7 \u09b8\u09b9\u099c\u09c7\u0987 deleted \u09ac\u09be removed \u0995\u09b0\u09be \u09af\u09be\u09df\u0964 The DROP INDEX Statement DROP INDEX statement \u09ac\u09cd\u09af\u09ac\u09b9\u09be\u09b0 \u0995\u09b0\u09c7 \u098f\u0995\u099f\u09bf table \u098f\u09b0 \u098f\u0995\u099f\u09bf index \u0995\u09c7 delete \u0995\u09b0\u09be \u09af\u09be\u09df\u0964\u2026","rel":"","context":"In &quot;\u098f\u09b8 \u0995\u09bf\u0989 \u098f\u09b2 - \u09e6\u09e6\u09e7 \u0964 SQL - 001&quot;","block_context":{"text":"\u098f\u09b8 \u0995\u09bf\u0989 \u098f\u09b2 - \u09e6\u09e6\u09e7 \u0964 SQL - 001","link":"http:\/\/bangla.sitestree.com\/?cat=155"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":16499,"url":"http:\/\/bangla.sitestree.com\/?p=16499","url_meta":{"origin":68481,"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":67600,"url":"http:\/\/bangla.sitestree.com\/?p=67600","url_meta":{"origin":68481,"position":5},"title":"Learn some Centos\/Redhat Linux: RHCE: MariaDB Administration on Redhat\/Fedora\/CentOS #DevOps #RHCE","author":"Author-Check- Article-or-Video","date":"July 25, 2021","format":false,"excerpt":"RHCE: MariaDB Administration on Redhat\/Fedora\/CentOS Check if mariaDB is installed or not 130 yum list installed | grep ^mariadb mariaDB originated from MySQL - after MySQL Got Bought by Oracle 133 yum list installed | grep ^mariadb I see - installed though not completely Output: mariadb-libs.x86_64 1:5.5.52-1.el7 @anaconda There are\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\/68481","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=68481"}],"version-history":[{"count":0,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/68481\/revisions"}],"wp:attachment":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=68481"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=68481"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=68481"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}