Backup and Restore MySQL Databases

If you are using WordPress or other CMS for your website, it is important to do a regular backup of your website database. Because you don’t knows when disaster strike (hard disk failure, site been hacked, corrupted database, etc). At that time you will realize how important to backup your database.  Doing a MySQL database backup is quite easy. Just type a few command line and you have you backup that can be restore at any time.

Assume that you have root to your server. Initiate an SSH connection to your server and type the following command to backup your MySQL database.

mysqldump –u username –p databasename > backup.sql

Read more

WordPress Permalinks on Nginx

First open your nginx configuration file.

nano /etc/nginx/nginx.conf

But if you set up a virtual host, you should open the virtual host configuration for the host where you install wordpress. If you are using Debian, the configuration files is located at /etc/nginx/sites-available/. The following command should do that.

nano /etc/nginx/sites-available/example.com

Read more

Configuring WordPress to send email using Gmail on Debian

1. Install ssmtp using the following command.

apt-get install ssmtp

2. Edit ssmtp.conf

nano /etc/ssmtp/ssmtp.conf

Now update or add the following configuration to the ssmtp.conf

mailhub=smtp.gmail.com:587
AuthUser=user@gmail.com
AuthPass=YourGmailPassword
FromLineOverride=YES
UseSTARTTLS=YES

You should replace user@gmail.com with your gmail email address.

Read more

Access Your Linux Partition from Windows

I have a dual boot system (Arch Linux and Windows XP). When I boot my Linux OS I have no problem accessing my Windows XP partition because Linux support mounting NTFS and FAT file system. But Windows do not support mounting or accessing other file system beside its own file system without any third party software or drivers.  So I tried Google to find the programs that help me to access my Linux partition. And, I found 3 useful software that can be use to access Linux partition if you have a dual boot system like me. Read more

Boot Games from PC on PSP via USB Cable

Hostcore is a module that enables you to play games or access media from your PC. All you need to install this module is a PSP with custom firmware 3.80 m33 or higher, memory stick and USB cable.

Installation

Download the software / modules / driver listed below:

Hostcore 1.2 – 2alien.info

USBHostFS_PC Windows version - 2alient.info

PSP Type B Driver – MediaFire | Maxconsole Forums (need registration)

libusb – sourceforge.net

After all the download complete. Create a folder name PSP on your C: drive (you can select a different name and create it on any drive you like). Now extract HostCore_1.2.tar.gz to the folder you just created. Read more

« Previous Page — Next Page »