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/