{"id":3276,"date":"2010-06-03T21:19:10","date_gmt":"2010-06-03T21:19:10","guid":{"rendered":""},"modified":"2026-04-18T22:54:03","modified_gmt":"2026-04-18T22:54:03","slug":"b2evolution-on-my-laptop-and-rtfm","status":"publish","type":"post","link":"https:\/\/hellem.org\/wblog\/?p=3276","title":{"rendered":"B2Evolution on my laptop and RTFM"},"content":{"rendered":"<p>Spent a couple of hours setting up my blog engine B2Evolution to run on my Ubuntu 10.4 installation. The most tricky part of doing so is often to get your webserver up and running together with PHP and MySQL. That challenge is easily solved by using <a href=\"http:\/\/www.apachefriends.org\/en\/index.html\">XAMPP, or LAMPP<\/a> in my case since I&#8217;m running Linux. By installing XAMPP you get Apache, PHP and MySql (with PHPMyAdmin) together with a bunch more stuff just like that.<\/p>\n<p>All I had to do was to copy my local blog folder to the \/opt\/lampp\/-folder, then run \/blog\/install and voila, B2 up and running.<\/p>\n<p>But then I had to provide the blog with content downloaded as a SQL-file from my &#8220;real&#8221; blog. Had to struggle a bit with that one. Using the PHPMyAdmin console to do the import failed, first by a timeout, then because the SQL-file was to big. Soon found out that the best option is to use command line to import data to MySQL. First I tried the command <a href=\"http:\/\/dev.mysql.com\/doc\/refman\/5.0\/en\/mysqlimport.html\">MySQLImport<\/a>, but I never got it to work. A bit embarrassing to realize that this was a case of <a href=\"http:\/\/en.wikipedia.org\/wiki\/RTFM\">RTFM<\/a> (Read The Fucking Manual).  First of all, note that the filename of the SQL-file must match the table you want to import data to, then when realizing that I understood that MySQLImport was not what I wanted. I want to import data to several tables, so I had to use the <a href=\"http:\/\/forum.codecall.net\/database-database-programming\/1133-import-sql-file-command-line.html\">MySQL-command like this<\/a>.<\/p>\n<p>Now I have B2Evolution running on my local computer with content from hellem.org, based on my latest backup, because I backup regularly and I&#8217;m also able to do a restore \ud83d\ude09<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Spent a couple of hours setting up my blog engine B2Evolution to run on my Ubuntu 10.4 installation. The most tricky part of doing so is often to get your webserver up and running together with PHP and MySQL. That challenge is easily solved by using XAMPP, or LAMPP in my case since I&#8217;m running [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[47],"tags":[],"class_list":["post-3276","post","type-post","status-publish","format-standard","hentry","category-work-geek"],"_links":{"self":[{"href":"https:\/\/hellem.org\/wblog\/index.php?rest_route=\/wp\/v2\/posts\/3276","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hellem.org\/wblog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hellem.org\/wblog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hellem.org\/wblog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hellem.org\/wblog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3276"}],"version-history":[{"count":1,"href":"https:\/\/hellem.org\/wblog\/index.php?rest_route=\/wp\/v2\/posts\/3276\/revisions"}],"predecessor-version":[{"id":14326,"href":"https:\/\/hellem.org\/wblog\/index.php?rest_route=\/wp\/v2\/posts\/3276\/revisions\/14326"}],"wp:attachment":[{"href":"https:\/\/hellem.org\/wblog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3276"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hellem.org\/wblog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3276"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hellem.org\/wblog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3276"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}