URL Rewrite Using Lighttpd

http://puravidashollow.com/online-essay-grammer-revisors/ online essay grammer revisors You will need to enable the mod-rewrite in Lighttpd and then open up the file under /etc/lighttpd/lighttpd.conf

assessment discovery $HTTP["host"] =~ "www.asianeric.com" { url.rewrite-final = ( # Exclude some directories from rewriting "^/(wp-admin|wp-includes|wp-content)/(.*)" => "$0", # Exclude .php files at root from rewriting "^/(.*.php)" => "$0", # Handle permalinks and feeds "^/(.*)$" => "/index.php/$1" ) }

buy papers for school This configuration should work well with WordPress installation using permalinks.

Migrated from MySQL to SQLite

http://gpsemirates.com/order-a-dissertation/ I bought a new VPS from HostMist a few weeks back and installed Ubuntu with 128M RAM. After running Apache and MySQL for a while, I realised that 128M is simply not enough. So I decided to give Lighttpd and SQLite a try.

go Installation is very smooth in Ubuntu for both and configure Lighttpd is easy enough. However, it does take me sometime to figure out how to migrate the data from MySQL to SQLite. I will explain what I did in this post.

http://casinoguider.com/?p=Buy-a-descriptive-essay Firstly you will need to install a PDO plugin for SQLite to run under WordPress. It should be straightforword enough and no explanations would be needed.

http://eaglesviewinc.org/thesis-writing-phd/ Secondly you will need to migrate your existing data in MySQL into SQlite, unless you just started your new blog. I have found a little shell script to convert exported MySQL schema to SQLite syntax at JBipNet, it is very useful:

compare and contrast essay introduction help #!/bin/bash if [ "x$1" == "x" ]; then echo "Usage: $0 " exit fi cat $1 | grep -v ' KEY "' | grep -v ' UNIQUE KEY "' | grep -v ' PRIMARY KEY ' | sed '/^SET/d' | sed 's/ unsigned / /g' | sed 's/ auto_increment/ primary key autoincrement/g' | sed 's/ smallint([0-9]*) / integer /g' | sed 's/ tinyint([0-9]*) / integer /g' | sed 's/ int([0-9]*) / integer /g' | sed 's/ character set [^ ]* / /g' | sed 's/ enum([^)]*) / varchar(255) /g' | sed 's/ on update [^,]*//g' | sed 's/\\r\\n/\\n/g' | sed 's/\\"/"/g' | perl -e 'local $/;$_=;s/,\n\)/\n\)/gs;print "begin;\n";print;print "commit;\n"' | perl -pe ' if (/^(INSERT.+?)\(/) { $a=$1; s/\\'\''/'\'\''/g; s/\\n/\n/g; s/\),\(/\);\n$a\(/g; } ' > $1.sql cat $1.sql | sqlite3 $1.db > $1.err ERRORS=cat $1.err | wc -l if [ $ERRORS == 0 ]; then echo "Conversion completed without error. Output file: $1.db" rm $1.sql rm $1.err else echo "There were errors during conversion. Please review $1.err and $1.sql for details." fi

http://joannjansen.com/phd-research-proposal-on-entrepreneurship/ phd research proposal on entrepreneurship I simply copy the code to my local directory named “mysql-sqlite-converter.sh”, dump the MySQL database with:

http://kkkreation.com/?p=phd-thesis-in-health-insurance mysqldump -u {user} -p --compatible=ansi --skip-opt {database} {tablelist} > MyBlog

next You will need to make sure that your SQLite database file has the same name as the new dumped MySQL file, in my case is MyBlog.sqlite. Now simply run the script saved before:

blank sh mysql-sqlite-converter.sh MyBlog

click The script will create and overwrite the original MyBlog.sqlite file and you are ready.

professional resume services online 2014 Enjoy!!

URL rewrite support for Lighttpd server

homework help sequence I was setting up WordPress permalinks with Lighttpd but encounter some problems: mod_magnet module was not available for the Lighttpd installed on my VPS. It turned out that I need to install the module manually and then restart the server:

http://www.srisiddheswariseva.org/college-entry-essay-writers/ user@server$ sudo apt-get install lighttpd-mod-magnet user@server$ sudo lighty-enable-mod magnet user@server$ sudo /etc/init.d/lighttpd force-reload

thesis statement examples for a research paper For the permalink to work I did the following.

http://skbioextracts.com/good-essay-words/ Add this piece of code to /etc/lighttpd/lighttpd.conf

literature essays $HTTP["host"] == "dev.sudhaker.com" { server.document-root = "/sites/sudhaker.com/htdocs" magnet.attract-physical-path-to = ( server.document-root + "/rewrite.lua" ) }

And then

attr = lighty.stat(lighty.env["physical.path"])

if (not attr) then
lighty.env["uri.path"] = "/index.php"
lighty.env["physical.rel-path"] = lighty.env["uri.path"]
lighty.env["physical.path"] = lighty.env["physical.doc-root"] .. lighty.env["physical.rel-path"]
end

to the rewrite.lua under the server document root directory and it should be up and running.