<?xml version="1.0" encoding="utf-8"?>
<!-- generator="FeedCreator 1.7.2-ppt DokuWiki" -->
<?xml-stylesheet href="https://wiki.nicksoft.com/lib/exe/css.php?s=feed" type="text/css"?>
<rdf:RDF
    xmlns="http://purl.org/rss/1.0/"
    xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
    xmlns:slash="http://purl.org/rss/1.0/modules/slash/"
    xmlns:dc="http://purl.org/dc/elements/1.1/">
    <channel rdf:about="https://wiki.nicksoft.com/feed.php">
        <title>NS Doc lcb:webserver</title>
        <description></description>
        <link>https://wiki.nicksoft.com/</link>
        <image rdf:resource="https://wiki.nicksoft.com/lib/images/favicon.ico" />
       <dc:date>2026-05-07T17:06:24+03:00</dc:date>
        <items>
            <rdf:Seq>
                <rdf:li rdf:resource="https://wiki.nicksoft.com/lcb:webserver:301-redirect-to-www"/>
                <rdf:li rdf:resource="https://wiki.nicksoft.com/lcb:webserver:apache-php-mysql-static"/>
                <rdf:li rdf:resource="https://wiki.nicksoft.com/lcb:webserver:hexadecimal-ips-mysql"/>
                <rdf:li rdf:resource="https://wiki.nicksoft.com/lcb:webserver:home"/>
                <rdf:li rdf:resource="https://wiki.nicksoft.com/lcb:webserver:mysqldump-extended-options"/>
            </rdf:Seq>
        </items>
    </channel>
    <image rdf:about="https://wiki.nicksoft.com/lib/images/favicon.ico">
        <title>NS Doc</title>
        <link>https://wiki.nicksoft.com/</link>
        <url>https://wiki.nicksoft.com/lib/images/favicon.ico</url>
    </image>
    <item rdf:about="https://wiki.nicksoft.com/lcb:webserver:301-redirect-to-www">
        <dc:format>text/html</dc:format>
        <dc:date>2008-09-22T14:39:18+03:00</dc:date>
        <title>301 Redirect to www</title>
        <link>https://wiki.nicksoft.com/lcb:webserver:301-redirect-to-www</link>
        <description>Using http redirect (code 301 - Moved Permanently) is useful because search engines gives negative credits for using multiple domains on the same site (mirror sites doesn't count).
Other issue is when you have domain “examle.com” and both “example.com” and “www.example.com” are valid. Most of you know that one of factors that search engines use to assess site importance is so called back-links. However some site link to “example.com” and other to “www.example.com”. This way search engine ranking…</description>
    </item>
    <item rdf:about="https://wiki.nicksoft.com/lcb:webserver:apache-php-mysql-static">
        <dc:format>text/html</dc:format>
        <dc:date>2008-09-22T14:38:46+03:00</dc:date>
        <title>MySQL, Apache+PHP static howto</title>
        <link>https://wiki.nicksoft.com/lcb:webserver:apache-php-mysql-static</link>
        <description>Download Sources


download apache, php, mysql and mod_ssl to /usr/local/src directory.



tar zxf apache_1.3.41.tar.bz2
tar jxf php-4.4.9.tar.bz2
tar zxf mysql-5.0.67.tar.gz
tar zxf mod_ssl-2.8.31-1.3.41.tar.gz
mv apache_1.3.41 apache-1.3.41


Last step is important! if you skip it you'll have to adjust all commands that comtain apache directory.</description>
    </item>
    <item rdf:about="https://wiki.nicksoft.com/lcb:webserver:hexadecimal-ips-mysql">
        <dc:format>text/html</dc:format>
        <dc:date>2008-09-22T14:48:45+03:00</dc:date>
        <title>Storing ips in database as hexadecimal strings</title>
        <link>https://wiki.nicksoft.com/lcb:webserver:hexadecimal-ips-mysql</link>
        <description>PHPBB2 stores ips as hexadecimal strings. php function that could convert ip to phpbb2 ip string is this: 



echo sprintf('%08X',ip2long('192.168.0.1'));//result: C0A80001


converting back hexadecimal IP to dot style with php can be done with base_convert function:</description>
    </item>
    <item rdf:about="https://wiki.nicksoft.com/lcb:webserver:home">
        <dc:format>text/html</dc:format>
        <dc:date>2008-09-22T14:49:32+03:00</dc:date>
        <title>Webserver</title>
        <link>https://wiki.nicksoft.com/lcb:webserver:home</link>
        <description>*  301 Redirect to www
	*  MySQL, Apache+PHP static howto
	*  Storing ips in database as hexadecimal strings
	*  mysqldump - extended options</description>
    </item>
    <item rdf:about="https://wiki.nicksoft.com/lcb:webserver:mysqldump-extended-options">
        <dc:format>text/html</dc:format>
        <dc:date>2008-09-22T14:57:18+03:00</dc:date>
        <title>mysqldump - extended options</title>
        <link>https://wiki.nicksoft.com/lcb:webserver:mysqldump-extended-options</link>
        <description>mysqldump command dumps databases/tables to standart output. You can use pipe redirect to save it to file:
mysqldump [options] &gt;dump.sql

When you dump a database there are some options of mysqladmin you need to understand:

	*  --skip-comments - Use this option if you want make a smaller file
	*  --compatible - if you export database from higher version to lower you will need this option. Possible values are:
		*   --compatible=mysql323
		*   --compatible=mysql40
		*   --compatible=mysql323</description>
    </item>
</rdf:RDF>
