The importance of backups
MySQL backup tools
Backup is not only running the backup command
Backup time and frequency
Testing backups routinely
Automating the process
Continue reading MySQL Backup Strategy
After Microsoft has launched SQL Server for Linux, even if your main tech stack is tied to Windows Server you may need to copy the database to another SQL Server located on a Linux computer.
For example, this can come in handy if you want to provide developers with a database for testing without buying a Windows Server license.
There are a few ways to tackle this task. This article examines the following methods to copy SQL Server database from Windows to Linux:
- Using T-SQL’s BACKUP DATABASE and RESTORE DATABASE commands;
- Generation of T-SQL database script (such as mysqldump);
- Creating BACPAC;
- SqlBak service.
Below is a short step-by-step tutorial on how to get private keys for OneDrive for Business. Continue reading How to get app keys for OneDrive For Business
Jupyter Notebook is a great tool for data analysis. And one of its greatest features is that you can easily combine runnable code with rich-text annotations. Markdown cells that contain such annotations support both HTML and Markdown syntax. Continue reading Jupyter Notebook Markdown Cheatsheet
If during setting up of SqlBak on Linux or during a backup job one of the following errors occurs:
PostgreSQL DBMS – /bin/sh: 1: /usr/bin/psql: not found
PostgreSQL DBMS – /bin/sh: 1: /usr/bin/pgdump: not found
it means that SqlBak app could not find the path to postgresql executables. By default, SqlBak looks for postgresql files in the /usr/bin/psql directory. Continue reading PostgreSQL DBMS – /bin/sh: 1: /usr/bin/psql: not found
Automated backup of MySQL databases can be a serious task. The proper way to automate backups involves the following steps:
- Create a database backup
- Zip the backup
- Encrypt the compressed file
- Send the backup to storage over the Internet, FTP, Dropbox, AWS, Google Drive, etc.
- Receive email notifications concerning backup results
- Create a backup schedule
- Delete old backups
That issue may occur if the SqlBak (SQL Server Backup) Windows Service was interrupted by an error. Continue reading How to fix SqlBak “Service failed” error
Basically, to update SqlBak on Linux you need to update the package lists and reinstall or restart the SqlBak application. Below are some examples of how to do it on popular Linux distributions. Continue reading How to Update SqlBak on Linux
SqlBak application connects your Linux servers to sqlbak.com allowing you to manage MySQL, PostgreSQL and MS SQL Server database backups from the web. It should successfully work on different Linux distributions such as Ubuntu, Debian, Fedora, CentOS, and RHEL, but if you face any difficulty in using the app on your GNU/Linux distribution let us know. Continue reading Starting with SqlBak on Linux