restore Archives - Software Blog

MSSQL Server – Creating A New Database From A Backup Of Another Database

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 »

5 cents hint – Dump and restore MySQL database on WAMP server

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 »