Warcraftwarriors weblog

Did you try to restart the apache server with restar_apache command and receive error: httpd (pid 324234?) not running
The problem was that the process that was running did not clearor was not killed when you restarted apache.
If this happens then you can run this command :  kill -9 (pid)
The pid number is what it gave you here: httpd (pid 324234?) not running
Once you kill that pid number then you can run restart_apache and you should not receive the error.

WinSCP is an open source free SFTP client and FTP client for Windows. Legacy SCP protocol is also supported. Its main function is safe copying of files between a local and a remote computer.

http://winscp.net/eng/download.php

Another usefull tool is PuTTY: a free telnet/ssh client

 Free and easy to use. You can download from http://www.chiark.greenend.org.uk/~sgtatham/putty/

If you suffer how to transfer big MySQL database from one host to another here is the solution ( simple & easy) 

Step 1: Dump Database

Use SSH and log into server A. Navigate to a temporary folder or create a new folder for dumping the databases into. From the command line issue the following command

CODE:

1. mysqldump DATABASE_NAME > DATABASE_NAME.sql

This will dump the structure and data from the database you named above into the directory you are currently in.

Step 2: Transfer File

Now you need to transfer the file to the new server.

CODE:

1. scp DATABASE_NAME.sql USERNAME@IP_ADDRESS:DIRECTORY_ON_SERVER_B/DATABASE_NAME.sql

Replace DATABASENAME with the name you gave the file in step 1. Replace USERNAME with the login name on server B. I used root. Replace IPADDRESS with the IP of server B. DIRECTORYONSERVER_B is the name of the directory on server B where you want to transfer the file to. It doesn’t really matter where you put it.

Once you issue the above command, you will be asked to provide the password for the username you supplied. Once accepted, the file will be transferred.

Now log into server B and navigate to the directory where you transferred the database file to.

Step 3: Create Database

CODE:

1. mysql -u root -p -e ‘CREATE DATABASE DATABASE_NAME’;

This command will create a new database with the name you provide. Should be the same name as you used on server A. After entering the above command provide the MySQL root password and the new database will be created.

Step 4: Restore Data

CODE:

1. mysql -u root -p DATABASE_NAME < DATABASE_NAME.sql;

This command will import the structure and data from the database on server A. Again you will be asked for the MySQL root password.

Step 5: Grant Users

CODE:

1. grant all on DATABASE_NAME.* to DATABASE_USERNAME@localhost identified by ‘PASSWORD’;

Now you need to create a new user and give that user permission to access the database.

Step 6: Flush Privileges

CODE:

1. FLUSH PRIVILEGES;

Now tell MySQL to reload the new privileges you created.

That’s it. Repeat for each database you are moving.

Here are a few other commands that came in handy

Show the databases:

CODE:

1. SHOW DATABASES;

Show Grants:

CODE:

1. select User,Host from mysql.user;

Delete Grants:

CODE:

1. DELETE FROM mysql.user WHERE User=‘DATABASE_USER’ and host=‘localhost’;

The tips are taken from http://johnhesch.com/2007/01/31/moving-mysql-databases-to-a-new-server/

We have a winner on the tournament of BlackNova trader. The winner is NFSF430 from The Gathering Darkness alliance.

Congratulations for the winner.

Now the game has been restarted.

Join Now to rule the universe !!!!

Join at http://www.warcraftwarriors.com/bnt/

Check the settings here: http://www.warcraftwarriors.com/bnt/settings.php

We have a winner on the tournament of BlackNova trader. The winner is Crummy from Novalords alliance.

Congratulations for the winner.

Now the game has been restarted.

Join Now to rule the universe !!!!

Join at http://www.warcraftwarriors.com/bnt/

Due to problems with database, we have restart the game.

Sorry for the incoviniece caused.

Join on http://www.warcraftwarriors.com/bnt/

What is BlackNova Traders? BlackNova Traders is a turn-based space strategy game where you start off with minimal resources which you must use wisely to make money, money is power. As the game goes on you upgrade your ship make alliances and colonize planets to produce more money in your quest for top rank and domination.

Join NOW!!!

http://www.warcraftwarriors.com/bnt/

Google Pack is:

Essential: Enjoy safe, useful software for your computer Simple: Download and install everything in just a few clicks Customizable: Choose only the software you want Up to date: Get updates & new software via  Google Updater

Google Software Included        
    Google Earth - 3D Earth browser

    * Zoom from space to street level — tour the world
    * Find maps, driving directions, hotels, restaurants, and more
   
    Google Desktop - Desktop companion

    * Find all your email, files, web history, and more
    * Get all your personalized info in one place with Sidebar

    Picasa - Photo organizer

    * Find, edit, and share your photos in seconds
    * Easily remove red eye and fix photos

    Google Toolbar for Internet Explorer - Search toolbar

    * Search from any web page and autofill forms
    * Block annoying pop-ups

    Google Pack Screensaver - Photo screensaver

    * Enjoy photos from your personal collection
    * View pictures full screen or as a collage

 Additional Software Included
    Mozilla Firefox with Google Toolbar - Web browser
Mozilla Corporation

    * Browse the web quickly and securely
    * Switch between pages quickly with tabbed browsing

    Ad-Aware SE Personal - Antispyware utility
Lavasoft

    * Safely detect and remove spyware
    * Protect your privacy with powerful features

    Norton Antivirus 2005 Special Edition - Antivirus utility
Symantec

    * Protect your PC from viruses, worms and Trojan horses
    * Includes 6-month subscription to protection updates

    Adobe Reader 7 - PDF reader
Adobe Systems

    * View, print, and search PDF files
    * Launches up to 50% faster than Reader 6.0

       Optional Software (Add to Pack)      
    Google Talk - Voice and IM application

    * Call or send instant messages to your friends for free
    * Get a free account using your mobile phone
   
    Google Video Player - Video player

    * Play videos purchased and downloaded through the Google Video website

    RealPlayer - Media player

    * Play popular media formats, organize music and videos
    * Transfer music to iPod and other portable media players
   
    GalleryPlayer HD Images - Images

    * High-quality artwork and photos
    * Perfect for your screensaver or desktop

    Trillian - Instant messenger

    * Chat with friends on different IM networks
    * Supports audio chat and secure connections