Esvon Classifieds

Unofficial Manual

Synopsis

This feature allows you to take an instant “dump” of the database and save as a file to your computer hard-disk or other storage device.

Backup Procedure

1. Select the type of compression you wish to receive the file in:

2. Click backup and select a destination for the file. The name is pre-defined in the format “ec_db_ddmmyy.sql” but can be changed to suit your requirements though the extension .sql should be retained for identification purpose.

The file can be opened in a text editor, if desired. This might be useful when recovering single items of data, for example when a member accidentally deletes an advert.

The estimated uncompressed size of the backup file is shown for your information.

1. More database backup techniques are discussed here.

Optimizing the database tables

There is also an option to optimize the database tables manually.

Table optimization is recommended especially where fields of variable lengths are used. As these types of  records are updated, inserted or deleted they will take up the same amount of space so data gets fragmented, just like on a hard-disk. This will eventually cause MySQL to slow down.

However, this process is normally carried out automatically by the built-in cron job.

Synopsis

The software requires a single MySQL database. The way you set it up may differ depending on your server administration software. This page provides you with an example for cPanel and Plesk. Refer to your webspace provider for instructions for other types of control panels.

Procedure

CPANEL USERS

If your server provides you with CPanel you will need to log in to your administration panel and click on the MySQL icon.:

Then do the following:

Step Three Use the drop-down boxes to assign the new username to the new database you just created The privileges should be left to ‘all’ as Esvon needs most of them. Click ‘Add User to Db’ to complete the assignment.

Step Four The PHP part of the Connection String provides you with the information you require to install the database required by Esvon. In this case the host is (1) localhost, the username is (2) ecusbnet_test and the database name is (3) ecusbnet_test

PLESK USERS

Logon on to your Plesk admin control panel:

	Click on the domain you wish to work on
	Click on the Databases icon Click on Add New Database
	Enter the new database name click ok
	Click on Add New Database User
	Enter a username (letters/numbers and underscore accepted) Enter a password and confirm it Click ok
	You will be retured to the database panel Click on DB WebAdmin if you wish to access PHPMyAdmin

The username, password and database name you created in these panels will now be required by the install script or, if you are installing the syxtem manually, the information is required in inc/application.php.

Synopsis

EC uses one MySQL database to store all the advert information, member profiles, system settings and logs.

Technical requirements

Your server must be able to support MySql version 3.23.23 or better.

At time of writing the latest version is 5.0 though most servers are likely to be using 4.1.x.

There are different types of MySQL packages – for the purposes of EC the standard version is sufficient.

One database is required for each EC installation. A typical EC installation uses between 30-36 tables.  The database does not have to be on the same server as the software.

The purpose of each of these tables is discussed here.