<?xml version="1.0" encoding="UTF-8"?><rss version="0.92">
<channel>
	<title>123 Tweak</title>
	<link>http://www.123tweak.com</link>
	<description>Optimize your Website</description>
	<lastBuildDate>Tue, 10 Jan 2012 05:54:18 +0000</lastBuildDate>
	<docs>http://backend.userland.com/rss092</docs>
	<language>en</language>
	<!-- generator="WordPress/3.0.1" -->

	<item>
		<title>MySQL Import Command</title>
		<description><![CDATA[How do I import data stored in a &#8220;.sql&#8221; file (created by mysqldump command) under UNIX or Linux operating systems? The syntax is as follows to import the data created by mysqldump command: mysql -u{DB-USER-NAME} -p{DB-PASSWORD} {DB-NAME} &#60; {db.file.sql} mysql -h{MySQL-SERVER-HOST-NAME} -u{DB-USER-NAME} -p{DB-PASSWORD} {DB-NAME} &#60; {db.file.sql} In this example import a file called sales.sql for [...]]]></description>
		<link>http://www.123tweak.com/mysql-import-command/</link>
			</item>
	<item>
		<title>CentOS / Red Hat IPv6 Network Configuration</title>
		<description><![CDATA[Setting up IPv6 on CentOS, and for that matter RHEL and Fedora Linux, is quite straight forward. You need to edit just two files: 1. /etc/sysconfig/network-scripts/ifcfg- 2. /etc/sysconfig/network Configure the IP address. For example, for interface eth0, edit /etc/sysconfig/network-scripts/ifcfg-eth0 and make the necessary changes as below.DEVICE=eth0 HWADDR=00:22:15:17:CC:C1 BOOTPROTO=static IPADDR=192.168.1.2 NETMASK=255.255.255.0 NETWORK=192.168.1.0 BROADCAST=192.168.1.255 IPV6INIT=yes IPV6_AUTOCONF=no IPV6ADDR=&#60;ipv6 [...]]]></description>
		<link>http://www.123tweak.com/centos-red-hat-ipv6-network-configuration/</link>
			</item>
	<item>
		<title>Reset MySQL root Password</title>
		<description><![CDATA[To reset MySQL root user&#8217;s password, follow the following steps. Terminate all running instances of MySQL server. You can do that either via the RC script (/etc/init.d/&#60;script_name&#62; stop or /user/local/etc/rc.d/&#60;script_name&#62; stop for FreeBSD) or using the tools like kill and pkill. To use kill or pkill, you will have to use ps or pgrep to [...]]]></description>
		<link>http://www.123tweak.com/reset-mysql-root-password/</link>
			</item>
	<item>
		<title>Turn on MySQL query cache to speed up query performance?</title>
		<description><![CDATA[Many times developers looking for ways to speed up query, in mysql we can enable query cache to speed up query performance. Whenever query cache is enable, it will cache the query in memory and boost query performance. As we know, speed is always the most important element in developing a website especially for those [...]]]></description>
		<link>http://www.123tweak.com/turn-on-mysql-query-cache-to-speed-up-query-performance/</link>
			</item>
	<item>
		<title>How to find large files in Linux</title>
		<description><![CDATA[At the command line as root enter: find / -size +102400k This will find all files on the entire system that are bigger than 100 MB. Use this one to see the sizes: find / -size +103400k &#124; xargs ls -laAh Use &#8220;find .&#8221; to look only in the current directory. find . -size +103400k [...]]]></description>
		<link>http://www.123tweak.com/how-to-find-large-files-in-linux/</link>
			</item>
	<item>
		<title>Schedule tasks on Linux using crontab</title>
		<description><![CDATA[If you&#8217;ve got a website that&#8217;s heavy on your web server, you might want to run some processes like generating thumbnails or enriching data in the background. This way it can not interfere with the user interface. Linux has a great program for this called cron. It allows tasks to be automatically run in the [...]]]></description>
		<link>http://www.123tweak.com/schedule-tasks-on-linux-using-crontab/</link>
			</item>
	<item>
		<title>Change the default editor Linux</title>
		<description><![CDATA[Ever wanted to change the crontab of a server, but got an editor on screen that you&#8217;re totally unfamiliar with? There are a lot of causes for this annoyance, but one is that somebody recently installed or used midnight commander (mc) which for whatever reason seams to overrule your session&#8217;s default editor. Changing the editor [...]]]></description>
		<link>http://www.123tweak.com/change-the-default-editor-linux/</link>
			</item>
	<item>
		<title>Backup MySQL in command line with compression</title>
		<description><![CDATA[For those who looking for way to backup mysql database, you can use mysqldump to backup mysql database. Below is the script example to backup mysql database in command line:- $ mysqldump -h localhost -u username -p password database_name &#62; backup_db.sql If your mysql database is very big, you might want to compress your sql [...]]]></description>
		<link>http://www.123tweak.com/backup-mysql-in-command-line-with-compression/</link>
			</item>
	<item>
		<title>How to install MySQL on CentOS Redhat Linux</title>
		<description><![CDATA[Install MySQL with YUM yum install mysql-server mysql php-mysql How to configure MySQL Set the MySQL service to start on boot chkconfig --levels 235 mysqld on Start the MySQL service service mysqld start Log into MySQL mysql -u root Set the root user password for all local domains SET PASSWORD FOR 'root'@'localhost' = PASSWORD('new-password'); SET [...]]]></description>
		<link>http://www.123tweak.com/how-to-install-mysql-on-centos-redhat-linux/</link>
			</item>
	<item>
		<title>Optimizing a php application in 5 minutes</title>
		<description><![CDATA[It is often said that premature optimization is the root of all evil: it is indeed true that the optimization stage must come after the main development of an application has been completed. Optimizing means reducing loading and execution times, improving the user experience by making the application reacting more responsively. When it comes the [...]]]></description>
		<link>http://www.123tweak.com/optimizing-php-application/</link>
			</item>
	<item>
		<title>How to upgrade Linux kernel</title>
		<description><![CDATA[How do I upgrade my Linux kernel? I would like to upgrade kernel without compiling from source code i.e. binary upgrade. How do I perform the actual upgrade of the kernel in Linux? You need to compile kernel only if: You need custom made kernel for specific task such as embedded kernel. Apply third party [...]]]></description>
		<link>http://www.123tweak.com/how-to-upgrade-linux-kernel/</link>
			</item>
	<item>
		<title>Securing PHP webservers</title>
		<description><![CDATA[PHP applications have a reputation for higher than average security problems. What configuration techniques do you use for making sure the application is secure as possible ? I&#8217;m looking for ideas like: Using Hardened PHP/Suhosin Using mod_security Disabling register_globals and allow_url_fopen in php.ini I normally use Linux, but feel free to suggest Windows solutions too. [...]]]></description>
		<link>http://www.123tweak.com/securing-php-webservers/</link>
			</item>
	<item>
		<title>IP Address conversion in PHP</title>
		<description><![CDATA[The purpose of this technote is to provide a small recipe for manipulating and/or converting IP addresses to decimals and back. I wrote a similar technote on how to do this in the Perl language. I thought it would be just as useful to know how to do the same thing in PHP. PHP has [...]]]></description>
		<link>http://www.123tweak.com/ip-address-conversion-in-php/</link>
			</item>
	<item>
		<title>MySQL IF() usage</title>
		<description><![CDATA[This article discusses the usage of the MySQL IF() function to display the status of a BOOLEAN or TINYINT(1) column. While working on a tool to track a migration, I needed a means to show the migration status of a collection of tasks. If all the tasks had been migrated, then I needed to summarize [...]]]></description>
		<link>http://www.123tweak.com/mysql-if-usage/</link>
			</item>
	<item>
		<title>Google Sandbox FAQ</title>
		<description><![CDATA[What is the sandbox? Basically its a time period that keywords that are competitive must wait in order to achieve results on Google. Is it real? Better believe it. Does the sandbox effect my entire site? No! It is keyword related only. Say you make a site for home loans. Everything about the site is [...]]]></description>
		<link>http://www.123tweak.com/google-sandbox-faq/</link>
			</item>
	<item>
		<title>Reset lost root password in MySQL</title>
		<description><![CDATA[This is a handy procedure that can be used to reset the root password for the MySQL account. I had to use this procedure on a failed installation. It appeared that I had a problem with the bin/install_db command, and it failed to pre-populate the mysql.user table with the correct initial permissions and grants. Without [...]]]></description>
		<link>http://www.123tweak.com/reset-lost-root-password-in-mysql/</link>
			</item>
	<item>
		<title>How to install UnixBench ?</title>
		<description><![CDATA[UnixBench is the original BYTE UNIX benchmark suite, updated and revised by many people over the years. The purpose of UnixBench is to provide a basic indicator of the performance of a Unix-like system; hence, multiple tests are used to test various aspects of the system&#8217;s performance. These test results are then compared to the [...]]]></description>
		<link>http://www.123tweak.com/how-to-install-unixbench/</link>
			</item>
	<item>
		<title>10 Tips to Keep Email Out of the Spam Folder</title>
		<description><![CDATA[1. Be Compliant with the CAN-SPAM Act If you are sending “any electronic mail message, the primary purpose of which is the commercial advertisement or promotion of a commercial product or service,” then you must comply with the following 7 main requirements (or face penalties up to $16,000) [5]: Don’t use false or misleading header [...]]]></description>
		<link>http://www.123tweak.com/10-tips-to-keep-email-out-of-the-spam-folder/</link>
			</item>
	<item>
		<title>Export MySQL data into CSV or PSV files</title>
		<description><![CDATA[One way to export data from MySQL tables into plain text files would be to use mysqldump, then remove SQL from the dump file. Perhaps an easier way is to pipe SQL SELECT output to a file. For CSV (comma delimited, enclosing content in quotes): mysql mydb -e "SELECT * FROM my_table" &#124; sed 's/\t/","/g;s/^/"/;s/$/"/;' [...]]]></description>
		<link>http://www.123tweak.com/export-mysql-data-into-csv-or-psv-files/</link>
			</item>
	<item>
		<title>Install mcache (msession) to be used for session caching in PHP</title>
		<description><![CDATA[Installing mcache, previously known as msession, on CentOS 32 bit system. MCache can be used completely transparently to a PHP application. By editing PHP&#8217;s “php.ini” file to use MCache as its default session handler (see Appendix D), applications will simply use MCache without knowing. This has an advantage in that MCache presents a standard interface [...]]]></description>
		<link>http://www.123tweak.com/install-mcache-msession/</link>
			</item>
</channel>
</rss>

