Home |  Mewsoft |   Overview |  Features |  License |  Installation |  Troubleshooting |  SDK |  Customization |  FAQ |  PDF    
 
 Engine Management
  Auctions Manager
  Accounts Manager
  Pending Accounts
  Accounting Manager
  Banner Advertisers
  Mail Manager

  System Statistics

 System Management 
  Category Manager
  Language Manager
  Fees Manager
  Database & SQL Manager
  System Announcements
  System Maintenance
 System Setup
  Configuration
  General Options
  Category Options
  Listing Options
  File Upload Options
  Billing System Setup
  Portal Tools
 Layout & Integration
  General Classes
  Special Classes
  Template Editor
  Custom Functions
 System Tools
  Lock System Access
  Server Backup
  Setup Wizard

 

Database & SQL Server Manager

 

 Overview

 Backup SQL Database Into Text Files

 Load SQL Database From The Text Files Backup

 Load/Unload SQL Database Tables

 Manage SQL Database Tables

 Empty

 Delete

 Optimize

 Describe
 Manage SQL Databases
 Delete Database
 Create Database
 Display SQL Server Status
 Display SQL Server Variables
 

 

Overview

The database manager tools allows you to backup and restore your system database online, manage SQL databases, Tables, SQL server information and status, and load and unload tables. Figure (1) shows the database and SQL manager main page.

 

Database & SQL Manager

  What's This?   


Backup SQL Database Into Text Files

Load SQL Database From The Text Files Backup

Load/Unload SQL Database Tables

Manage SQL Database Tables

Manage SQL Databases

Display SQL Server Status

Display SQL Server Variables

Figure (1) Database & SQL Manager Main Menu.

 

Backup SQL Database Into Text Files

This process will unload the system SQL database into a text files in specific format on the local cgi-bin/database directory. This will destroy any previous versions of the backup you have done. It is very recommended is to download the backup every time to your local computer and store for emergency need. The backup process may take from few seconds to several hours depending on the system database size.

The backup done by this process can only be restored from the Load SQL Database From The Text Files Backup tools in the database manager. All database fields are separated by the pipe character.

The backup process will create filename the same as the tables names in the database with the extension ".sql.txt" this will inform the FTP programs to automatically transfer these files in ASCII mode. For example the Categories SQL table will be stored in a file called Categories.sql.txt. Please do not rename these backup file since they will be restored to the same SQL tables that have the same file name.

The backup process will backup all the database tables even if you have tables that are not used by the program itself. The program will find all the tables in this database and create backup of all of them.

If you can access your server using for example Telnet or PC Any where and you have access to the SQL server then it is very recommended to backup your SQL database directly.

For example if you have Telnet access to your server and you are using MySQL server , then you can backup your whole system database in just few seconds what ever the size of the database is in a very safe process by using the command below:

% mysqldump -p database_name > backup_full_filename

for example to backup a MySQL database called mewsoft to a single text file called mewsoft.sql.txt enter the followig command:

% mysqldump -p mewsoft > /usr/www/mewsoft/html/mewsoft.sql.txt

This process will create the file mewsoft.sql.txt in your directory /usr/www/mewsoft/html. Please download this file to your computer in ASCII mode and also when you need to upload it to the server.

Any time you need to restore the SQL database from the above backup just use the following command:

% mysql -p database_name > backup_full_filename

in the above example to restore the database from the file mewsoft.sql.txt issue this command:

% mysql -p mewsoft < /usr/www/mewsoft/html/mewsoft.sql.txt

 

Load SQL Database From The Text Files Backup

This tools will load the system database from a previous backup created by Backup SQL Database Into Text Files. Please be very careful when using this utility as it will delete completely all your current system database and load the contents in the backup files only. Again this process will NOT add the backup contents to the system database, instead it the backup contents will be the only thing in the database after the load process. You normally may need this process only for system crash or emergency and in immigrating to another server.

 

Load/Unload SQL Database Tables

The load and unload process is the same as the backup and restore above except that here you can do it on the one SQL table level. Instead of doing a backup and restore of all the database tables, here you select the table or group of tables you want to backup or restore. Selecting all the tables is the same as doing the above backup and load.

 

Load / Unload SQL Tables

  What's This?   

To select more than one table, drag your mouse or click with the <CTRL> Key pressed.

Select Table(s):

   

Figure (2) Loading / Unloading SQL Tables.

 

Manage SQL Database Tables

The tables actions tools lets you manage the SQL database tables for best performance.

 

Empty

Delete all table contents. Please be very careful as this process will empty total the contents of the selected tables and this process can not be redone.

 

Delete

Delete table and its contents. Please be very careful as this process will delete the selected tables completely and all its contents and this process can not be undone.

 

Optimize

Eliminate any wasted space. The optimization process is done totally by the SQL server itself by eliminating any wasted disk space in the database files which also speed up the SQL server processes. This process is safe but it may take long time with big tables.

 

Describe

Show table information. This process displays the selected tables information like number of rows and file size which helps you see how big is the database file size for this table and many other information. Please note this features is not available in older versions of MySQL server. If you got an error message during this process then it means this feature is not available with the current MySQL server version.

 

Manage SQL Tables

  What's This?   

SQL Database Tables Management

Selecte Table(s):

To select more than one table, drag your mouse or click with the <CTRL> Key pressed.

What to do:

Delete all selected tables contents

Delete selected tables and its contents

Eliminate any wasted space

Show selected tables information

Figure (3) SQL Tables Manager.

 

Manage SQL Databases
The database actions allows you to create and delete SQL databases. To create or delete databases you must have the full privileges to do this or you must be the root user. Normal MySQL users can not create or drop MySQL databases.

 

Manage SQL Databases

  What's This?   


Delete Database:


Create Database:

Figure (4) Database Manager.

 

Delete Database

Select the database you want to delete from the menu and click Delete Database button. You must have the SQL server privileges to delete databases. Normal sql users can not delete databases.

 

Create Database

Enter the name of the database you want to create in the text box and click Create Database button. You must have the SQL server privileges to create databases. Normal sql users can not create databases.

 

Display SQL Server Status

This will display all the current SQL server status variables

 

Display SQL Server Variables

This will display all the current SQL server variables settings which help you change some of them to fine tune your SQL server

 




.

 
Copyright 2001-2004 Mewsoft Corporation. All rights reserved.