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: Usage: pleskbackup… Read More »