Simple guide to database backups: MySQL, PostgreSQL and SQL Server
A database backup is a special copy of data that can be used to restore the database to a specific point in […]
Author: Ivan Gusev
Where to find my.ini, mysql.exe, mysqld.exe, mysqlbackup.exe on Windows
To find these files, please follow these steps: Press win+r Enter services.msc Find MySQL service
MySQL Incremental Backups on Windows
Making a full database backup is very easy with mysqldump . Details are available in this article. However, such backups are a […]
Automating SQL Server backups on Windows: why you need it and how to do it
A backup is a copy of data taken and stored elsewhere so that you can restore it in case of a database […]
[SRV:8007#1326] The User Name or Password is Incorrect
During the backup you can get the following error message: [SRV:8007#1326] Authorization failed. Computer name: <computer name>. Username: <user name>. Domain: <domain> […]
[DBMS-MSSQL:11006#11007] MySQL backup error: unknown variable ‘column-statistics=0’
The following error message: [DBMS-MSSQL:11006#11007] MySQL backup error: unknown variable ‘column-statistics=0’ means that the version of mysqldump utility used by SQLBackupAndFTP to […]