{"id":48,"date":"2023-07-27T20:16:16","date_gmt":"2023-07-28T03:16:16","guid":{"rendered":"http:\/\/Macdaddy4sure.com\/?p=48"},"modified":"2023-07-27T20:16:16","modified_gmt":"2023-07-28T03:16:16","slug":"_augmentedintelligence-wikipedia2mysql","status":"publish","type":"post","link":"http:\/\/macdaddy4sure.ai\/index.php\/2023\/07\/27\/_augmentedintelligence-wikipedia2mysql\/","title":{"rendered":"_AugmentedIntelligence Wikipedia2MySQL"},"content":{"rendered":"\n<p>The following guide will teach one step by step to upload Wikipedia and other Wikia XML Wikidumps to MySQL.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Install MySQL if you have not installed already.\n<ol class=\"wp-block-list\">\n<li>Go to <a rel=\"noreferrer noopener\" href=\"https:\/\/www.mysql.com\/downloads\/\" target=\"_blank\">https:\/\/www.mysql.com\/downloads\/<\/a><\/li>\n<\/ol>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Download the community version of MySQL<\/li>\n\n\n\n<li>After the executable has been downloaded; execute it.<\/li>\n\n\n\n<li>Install the community installer and the most recent version of MySQL server. Note: I would recommend installing the Visual Studio C++ Connector if you plan to edit or mod the source of _AugmentedIntelligence or if you wish to use your own or third party software.<\/li>\n\n\n\n<li>Make sure MySQL Server is installed as a service.<\/li>\n<\/ol>\n<\/li>\n\n\n\n<li>Download a Wikia Dump from <a href=\"https:\/\/dumps.wikimedia.org\/backup-index.html\">https:\/\/dumps.wikimedia.org\/backup-index.html<\/a><\/li>\n\n\n\n<li>Download 7-zip if you have not installed it already.\n<ol class=\"wp-block-list\">\n<li>Go to <a href=\"https:\/\/www.7-zip.org\/download.html\">https:\/\/www.7-zip.org\/download.html<\/a><\/li>\n\n\n\n<li>I recommend downloading the 64-bit Windows Executable file (64-bit Windows x64)<\/li>\n\n\n\n<li>After the executable has been downloaded, install it<\/li>\n<\/ol>\n<\/li>\n\n\n\n<li>Extract the Wikia dump XML file from the archive.<\/li>\n\n\n\n<li>Download the following PowerShell tool for extracting the dump.\n<ol class=\"wp-block-list\">\n<li>Open PowerShell as an administrator.<\/li>\n\n\n\n<li>Run the following: Install-Script Split-Wikipedia -Scope CurrentUser<\/li>\n\n\n\n<li>Close PowerShell and launch it again as an administrator.<\/li>\n\n\n\n<li>In PowerShell Prompt type: Split-Wikipedia -Path .\/enwiki-latest-pages-articles.xml<\/li>\n\n\n\n<li>This process will take a number of hours.<\/li>\n\n\n\n<li>The articles are saved to .\/articles<\/li>\n<\/ol>\n<\/li>\n\n\n\n<li>Download and install Git\n<ol class=\"wp-block-list\">\n<li>If you have not installed git; Go to:<a href=\"https:\/\/git-scm.com\/download\/win\">https:\/\/git-scm.com\/download\/win<\/a><\/li>\n\n\n\n<li>Download and install git.<\/li>\n\n\n\n<li>Open Advanced System Settings by right clicking on This PC and left clicking on Properties.<\/li>\n\n\n\n<li>Click on Environment Variables.<\/li>\n\n\n\n<li>Under the Path variable, paste the installation path or bin directory of git.<\/li>\n\n\n\n<li>Save and close Environment Variables.<\/li>\n<\/ol>\n<\/li>\n\n\n\n<li>Download or Clone the repository\n<ol class=\"wp-block-list\">\n<li>Go to: <a href=\"https:\/\/github.com\/Macdaddy4sure\/WikipediaParser3\">https:\/\/github.com\/Macdaddy4sure\/WikipediaParser3<\/a><\/li>\n\n\n\n<li>Click on the green button toward the top right of the page.<\/li>\n\n\n\n<li>Copy the text URL inside the menu.<\/li>\n\n\n\n<li>Open Command Prompt and navigate to the directory you would like to store the source and executable for Wikipedia Parser.<\/li>\n\n\n\n<li>Type in the prompt: git clone https:\/\/github.com\/Macdaddy4sure\/WikipediaParser3.git<\/li>\n<\/ol>\n<\/li>\n\n\n\n<li>Use DirectoryUpLevel.exe to move all files inside of .\/articles to another directory.\n<ol class=\"wp-block-list\">\n<li>DirectoryUpLevel.exe is located inside the x64 directory under the cloned repository.<\/li>\n\n\n\n<li>Open DirectoryUpLevel.exe and type in the path to the articles directory.<\/li>\n\n\n\n<li>I recommend creating a directory on the same level as the articles directory and call it .\/Done.<\/li>\n\n\n\n<li>Enter that directory into the second prompt in DirectoriesUpLevel.<\/li>\n\n\n\n<li>Press enter and the process will be executed.<\/li>\n<\/ol>\n<\/li>\n\n\n\n<li>Open Command Prompt and Create a new database inside of MySQL for the Wiki you are uploading.<\/li>\n\n\n\n<li>Open WikipediaParser3 and configure the program.\n<ol class=\"wp-block-list\">\n<li>Open WikipediaParser3<\/li>\n\n\n\n<li>Press 0 (Zero) and press enter to open the settings menu.<\/li>\n\n\n\n<li>Use the options in the menu to configure the program.<\/li>\n<\/ol>\n<\/li>\n\n\n\n<li>Option 5. The Wiki Dump location should be the directory of the &#8220;Done&#8221; folder.\n<ol class=\"wp-block-list\">\n<li>Make sure all of the forward slashes are forward slashes (\/).<\/li>\n<\/ol>\n<\/li>\n\n\n\n<li>Press 0 to return to the main menu.<\/li>\n\n\n\n<li>Press 1 to start the process.<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>The following guide will teach one step by step to upload Wikipedia and other Wikia XML Wikidumps to MySQL.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-48","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"http:\/\/macdaddy4sure.ai\/index.php\/wp-json\/wp\/v2\/posts\/48","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/macdaddy4sure.ai\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/macdaddy4sure.ai\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/macdaddy4sure.ai\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/macdaddy4sure.ai\/index.php\/wp-json\/wp\/v2\/comments?post=48"}],"version-history":[{"count":2,"href":"http:\/\/macdaddy4sure.ai\/index.php\/wp-json\/wp\/v2\/posts\/48\/revisions"}],"predecessor-version":[{"id":51,"href":"http:\/\/macdaddy4sure.ai\/index.php\/wp-json\/wp\/v2\/posts\/48\/revisions\/51"}],"wp:attachment":[{"href":"http:\/\/macdaddy4sure.ai\/index.php\/wp-json\/wp\/v2\/media?parent=48"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/macdaddy4sure.ai\/index.php\/wp-json\/wp\/v2\/categories?post=48"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/macdaddy4sure.ai\/index.php\/wp-json\/wp\/v2\/tags?post=48"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}