Today’s task is to backup database in one MSSQL server and restore database on another server. There is no direct connection between this setup, so backup can be transferred only via ftp. First, create a blank target database. Then, in “SQL Server Management Studio” restore wizard, look for the option to overwrite target database. It… Read More »
For backing up and restoring MySQL database on WAMP server no fancy tools are needed. Out of the box command line tools will do all you need: Dump database : [path to wamp mysql bin directory]\bin\mysqldump -u[user]-p[password] [database name] > [destination file] For example C:\wamp64\bin\mysql\mysql5.6.17\bin\mysqldump -uroot -p mydatabase > c:\temp\mydatabase.sql And restoring same thing back: [path to wamp… Read More »
More and more computers are using fast SSD storage. Even the sizes are growing it it still too valuable space to use for backups. iTunes backs up only part of iOS data like app files, settings and camera roll photos from the iPhone, iPad, or iPod Touch each time you sync. Nevertheless, the iOS backup files may quickly accumulate… Read More »
Plesk has a set of command line tools which we can use to create a backup manually. The tool is called pleskbackup and it lives in the Plesk utilities directory. On CentOS this is in /usr/local/psa/bin. If called without parameters you’ll see a long list of options you can pass to this command:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 |
Usage: pleskbackup <command></command> [] Commands: server Backs up whole Plesk. resellers-name Backs up selected resellers. Reseller's logins are read from command line, space-separated. If no resellers provided, backs up all resellers on the host. resellers-id Backs up selected resellers. Reseller's identificators are read from command line, space-separated. If no resellers provided, backs up all resellers on the host. clients-name Backs up selected clients. Client's logins are read from command line, space-separated. If no clients provided, backs up all clients on the host. clients-id Backs up selected clients. Client's identificators are read from command line, space-separated. If no clients provided, backs up all clients on the host. domains-name Backs up selected domains. Domain's names are read from command line, space-separated. If no domains provided, backs up all domains on the host. domains-id Backs up selected domains. Domain's identificators are read from command line, space-separated. If no domains provided, backs up all domains on the host. Use Exclude options to exclude some resellers/clients/domains. help Shows this help page ... Output file option: --output-file= /fullpath/filename - regular file, - - use stdout for output, [ftp|ftps]://[[:]@]/fullpath/filename - storing the backup to ftp server. FTP_PASSWORD environment variable can be used for setting password. FTP option '--ftp-login' can be used for setting login. FTP option '--ftp-password' (with '--ftp-login') can be used for setting password. If your password contains slash, you have to use '--ftp-password' option or FTP_PASSWORD environment variable. 'ftps' protocol can be specified to use FTP over SSL, instead of plain FTP. With ftps specify 990 port to use implicit FTPS, otherwise explicit mode will be used. Used to import dump from repository into the single file. |