WordPress is best known for hosting service available through blogs http://wordpress.org/, but it is actually a content manager for general use, that can be installed on any server that supports PHP and MySQL licensed under the GPL, and source code is available and can be customized freely.

You can even install it at home to play and test the functions, need to have a pre-configured LAMP server. If you do not know what I mean, here’s a brief explanation:

Apache continues to provide only static HTML pages. When prompted for a page in PHP or another language, kicks in the appropriate module, which makes the necessary processing and returns to the Apache html page that appears. The content managers and boards then come into play, which combine the features of PHP with a database like MySQL, accessed through it. The combination of all this as the solution that is popularly called ” LAMP “( Linux Apache MySQL PHP ).

The possibility of running WordPress on your own server is not only interesting if you are interested in using the system on your own site or a site that manages, but also for dedicated server hosting companies in general, which may offer installation and administration Content Manager as an additional service. You can download the installation package from the official website.

To install, copy the package files to the folder of the web server and unzip it using “unzip” (if it is not available, install the package “unzip” using the package manager), as in:

$ Unzip latest.zip

This will create the “wordpress” folder in the folder where you unzipped the file, creating the url ” http://server/wordpress . ” If you want the manager to be available in another folder on the server, just rename it before proceeding, using the mv command, as in:

Mv wordpress blog

If you prefer to make it available through the root URL of the site, move all files within the folder to the root directory of the site.

Just like phpBB, WordPress requires a database and a user access to the MySQL server you can add them quickly through the MySQL prompt, using the commands we’ve seen before:

$ Mysql-u root-p

mysql> CREATE DATABASE wordpress;
mysql> GRANT ALL ON wordpress;
mysql> FLUSH PRIVILEGES;

The next step is to adjust the configuration of WordPress so that it uses the database created. For this, the first step is to access the root folder and rename the file “wp-config-sample.php” to “wp-config.php”, as in:

$ Cd wordpress
$ mv wp-config-sample.php wp-config.php

Open the file using a text editor and set any options for the database, adding the database, user and password created:

/ / ** MySQL settings ** / /
define (‘DB_NAME’, ‘ wordpress ‘); / / The name of the database
define (‘DB_USER’, ‘ wordpress ‘); / / Your MySQL username
define (‘db_password’ ‘ 8oNqrQsh ‘) / / … and password
define (‘DB_HOST’, ‘localhost’) / / 99% chances are, you will not need to change this value

The “DB_HOST” indicates the address of the MySQL server used. Except where you are using separate servers for the function of web server and database, we use “localhost” or “127.0.0.1″ that guide the system to contact a MySQL server running on the same machine.

A curiosity is that the file “wp-config.php” gets with read permission for everyone. However, if you try to access it directly from the browser (http://my-site/wordpress/wp-config.php), or try to download it from another machine using wget (or other download manager) will realize that the system always delivers an empty file instead of displaying the passwords. This is because of the extension. “Php”, the web server always processes the file using the PHP interpreter, without displaying it directly. A PHP function within the file then takes care of showing the blank page instead of displaying the configuration information.

Continuing, after setting up the file, just complete the installation by accessing the script via browser “wp-admin/install.php” folder inside the installation of WordPress, as in ” http://mydomain/wordpress/wp-admin/install.php “or” http://mydomain/wp-admin/install.php . ”

The installer asks only the title of your blog and e-mail contact. By clicking the “Install WordPress” the installation is completed automatically:

Thereafter, the remaining steps are done through the WordPress admin interface, available via the folder “wp-admin” in the installation directory, as in ” http://mydomain/wordpress/wp-admin/ . ” Simply login using the password created during installation:

Databases are always being the main concern of the servers. Along with backups one can be rest assured that their database is secure and can be utilized as and when required. Websites today rely a great deal on databases to store vital data, which may include member information as well as website content.

Backing up MySQL database involves a strategic integration of resources. One can give preference to the automated backups as well. While automated backups are important, sometimes you just want to take a quick snapshot before making a change to your data. Dedicated web hosting solutions gives you full control over them. This helps you in making any crucial changes on your own and also gives you the liberty of installing or updating any softwares. You can do whatever you want with the box, implement services and of course a full root access with the machine.

People with the past experience in the web technologies knows that backups are a good practice and better too many than none. This practice of backing up the database of a website is fairly proves to be fruitful for a website and its content. If something happens (for instance, if the database gets corrupted), you’ll get to experience will be worst, but with the backups you can anytime recover it without any hassles. MySQL databases are the most popular open source databases that are used to power most of the websites today. This is why, it is very important to understand some basic working and administration of MySQL databases to comfortably manage your website.

We will have a quick peak into as how to make a backup and also restore a MySQL database with the following procedure:

The first and foremost step is to “Login into cPanel” you can follow the procedure like : type the URL http://<yourwebsite address>/cPanel in the Address bar of your Web browser and then press Enter. When prompted, enter your user id and password.

Then on the second step “ Login to PHPMyAdmin”: Sign into it as a valid root user or an administrator for your database. Then select the database which you want to backup. The menu for the database will come on the left side margin.

Then the another step is to Click on the Export tab once web page screening the selected database. Click on the saves as file option, which will save the file on your PC >> You can select database format either CSV, CSV for Excel or in .sql format.

Then with the ADD DROP TABLE option you can add table functionality. Generally the table exists in the database backup.

After that to import.sql file >> Click on the Import option (right side on the export tab).

Finally, Click on the Browse button to select .sql file from your local PC.

From the drop down menu, you can choose the character set of the file. If you are not firm with the character set then leave it default. Then the last step would be in order to proceed, click on the Go button (bottom of the right).

Questions and Answers for Recovery for MySQL Database

Q: Can Recovery for MySQL repair my MySQL database?

A: The effective way to know if a MySQL database is recoverable is to try the demo version of Recovery for MySQL on it.

Note: Always backup your original corrupted MySQL database before proceeding with any recovery activity!

Q: What limitations does the demo version mysql recover?

A: The demo version recovers limited number of rows in the corrupted database. The remaining rows are blank. The full version of Recovery for MySQL retrieves records from limited demo.

N rows or tables or other elements and features of the original database will be recovered by commercial version of Recovery for MySQL if absent from the production of demonstration.

Q: I tried the demo. How I can decide whether to purchase the full version of Recovery for MySQL?

A: Evaluation of the results of demo recovery can help in making the decision.

Q: Why do results of recovery contain less data than the original MySQL database?

A: This is normal. The damaged parts of the MySQL database will convert to zero size on output. The common cause of decrease in other file size is when some of the characteristics of the original database are not supported and therefore absent from the recovered database.

Demo-recovered database is smaller because it mostly consists of demo placeholders than actual data.

Q: Running Recovery for MySQL from the command line (through Windows Start -> Run menu).

A: If the license type of business or service, you can run Recovery for MySQL from the command line and use these calls in your batch files. The standard version is not compatible with the command line. The format to call the command line is:

myr.exe <original filename with path> “<path to directory to store the recovered file(s)>”
(Without parentheses).

Note that the directory for recovered file (s) must be created before starting the recovery.

The command line mode is compatible with the patterns of ‘*’ (replaces one set of symbols) and “?” (Replaces one symbol).

Q: After running the recovery of MySQL in the corrupted database, a folder with the SQL script (s) and the batch file has been created. How can these files be transfigured into a database?

A: To re-create the database, process resulting from SQL scripts schema.sql and following by dataNNNN.sql. The database will be recreated from scratch.

To make the import procedure more convenient for the end user of a batch file properly, it is automatically created and put in the same folder of SQL script (s).

Recovery of MySQL error messages

Q: Recovery for MySQL error: Internal error message program.

A: To run Recovery for MySQL in a logged mode and contact our support team with detailed description of the problem and the log file.

To create the log file, please press the Shift key while clicking the Recover on the toolbar of Recovery for MySQL or selecting the Recover: item in the main menu. You can also press CTRL + SHIFT + R after launching the recovery of MySQL.

Q: Recovery for MySQL Error: Not enough disk space.

A: To solve this problem you need to set temporary directory to the drive with free space available (2-3 times the size of the original database). Fix the Windows environment variable to use. Do the following:

Open System in Control Panel.

In the tab Advanced, click Environment Variables, then click the name of the user variable (TEMP or TMP) you want to change.

Click Modify to change the value.

• Set path to the location where temporary data should be stored (for example E: \).

• Restart the computer for the changes to take effect.

• Run the software again.

• You can also use the special environment variable called OFFICERECOVERY_TMP to set the directory where Recovery for MySQL should store its temporary files. Use the method shown above to add / edit environment variable.