mysqldump - a database backup program
The mysqldump client is a backup program originally written by Igor Romanenko. It can be used to dump a database or a collection of databases for backup or transfer to another SQL server (not necessarily a MySQL server).
If you are doing a backup on the server and your tables all are MyISAM tables, consider using the mysqlhotcopy instead because it can accomplish faster backups and faster restores. See mysqlhotcopy(1).
There are three general ways to invoke mysqldump:
shell> mysqldump [options] db_name [tables]
shell> mysqldump [options] –databases db_name1 [db_name2 db_name3...]
shell> mysqldump [options] –all-databases
If you do not name any tables following db_name or if you use the –databases or –all-databases option, entire databases are dumped.
Creating the postfix aliases database
Postfix uses a Sendmail-compatible aliases(5) table to redirect mail for local(8) recipients. Typically, this information is kept in two files: in a text file /etc/aliases and in an indexed file /etc/aliases.db. The command “postconf alias_maps” will tell you the exact location of the text file.
root@dell:~# postconf alias_maps
alias_maps = hash:/etc/aliases
root@dell:~#
First, be sure to update the text file with aliases for root, postmaster and “postfix” that forward mail to a real person. Postfix has a sample aliases file /etc/postfix/aliases that you can adapt to local conditions.
/etc/aliases:
root: you
postmaster: root
Note: there should be no whitespace before the “:”.
Finally, build the indexed aliases file with one of the following commands:
# newaliases
# sendmail -bi
Postfix uses database files for access control
Postfix uses database files for access control, address rewriting and other purposes.
Here is a common example of how Postfix invokes a database:
/etc/postfix/main.cf:
virtual_alias_maps = hash:/etc/postfix/virtual
Whenever you make a change to the main.cf or master.cf file, execute the following command as root in order to refresh a running mail system:
The database utility is used to manage databases and database users in Plesk through CLI. By using this utility, you can perform the following tasks:
* creating or deleting databases
* adding and removing database users
* adding or removing database access records for database users
* editing database user credentials
* setting charset for PostgreSQL databases
Example
The following command creates database buddies on a database server accessible at the IP address and port number 192.0.2.78:3838 and prints the created Plesk database ID:
# ./database –create buddies -domain example.com -server 192.0.2.78:3838 -print-id
To create the database buddies for the domain example.com on the local MySQL server:
# ./database –create buddies -domain example.com -type mysql
To upload a backup file to backup repository:
Go to Domains > domain name > Backup Manager (in the Files group) > Database Backup Repository and click Upload Backup File.
Select the database in which repository you want to upload the backup file to in the Database name menu.
Click Browse… and select the required backup file.
Leave the Restore database backup immediately upon uploading check box selected if you want the database contents to be restored immediately after the backup file is uploaded.
Click OK.
The database backup file will be uploaded to the backup repository of the specified database.
Resource : http://parallels.com/Plesk/
