Warcraftwarriors weblog

January 20, 2009

Browsers war – Internet explorer vs Firefox

Filed under: Web browsers — Administrator @ 8:49 pm

Following the post from 2005 http://www.warcraftwarriors.com/?p=27 when we have wrote that IE start to lose the battle vs Firefox become true. According our web statistic on our web sites – the war between this 2 most popular browsers continue – but with one small difference – Firefox is winning. If in 2005 Firefox has only 20% market share and IE with 71 %. Now the story is different. Firefox gain 43% market ( or 43 % of all our visitors has use Firefox) and IE is 44% – 1 % more.

 Here is all list with browser share:

MS Internet Explorer No 127361 44 %
Firefox No 125665 43.4 %
Safari No 15003 5.1 %
Unknown ? 8534 2.9 %
Opera No 8322 2.8 %
Mozilla No 2409 0.8 %
Netscape No 1643 0.5 %
Acrobat Webcapture Yes 102 0 %
Samsung (PDA/Phone browser) No 59 0 %
K-Meleon No 36 0 %

Microsoft start to change the look of the IE specialy with the new 8.0 version. But Firefox does not stand in one place – they continue to develop already sucessful browser.

September 2, 2007

restart apache – pid (number) not running?

Filed under: MySQL & Apache — Administrator @ 12:12 am

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.

Free SFTP client for Windows

Filed under: MySQL & Apache — Administrator @ 12:05 am

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/

Moving MySQL database from one server to another

Filed under: MySQL & Apache — Administrator @ 12:01 am

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/

January 6, 2007

BlackNova Traders – January 2007 winners

Filed under: General — Administrator @ 2:42 pm

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

November 19, 2006

BlackNova trader server restarted!!!!

Filed under: General — Administrator @ 4:35 pm

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/

July 23, 2006

Black Nova Traders server restart

Filed under: General — Administrator @ 10:35 pm

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

Sorry for the incoviniece caused.

 

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

April 28, 2006

Black Nova Traders – now hosted on WarcraftWarriors!

Filed under: General — Administrator @ 11:49 pm

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/

Older Posts »

Powered by WordPress