To find these files, please follow these steps:
- Press win+r
- Enter
services.msc
- Find MySQL service Continue reading Where to find my.ini, mysql.exe, mysqld.exe, mysqlbackup.exe on Windows
To find these files, please follow these steps:
services.msc
Making a full database backup is very easy with mysqldump
. Details are available in this article. However, such backups are a heavy load on the database because they require a lot of space and take a long time to create. This is not acceptable for a large production database. Therefore, instead of FULL database backups, you can do incremental database backups.
Incremental backups do not contain all database data but only the data that changed since the previous backup. In this case, to restore the data, you will need the entire chain of backups. Continue reading MySQL Incremental Backups on Windows
A backup is a copy of data taken and stored elsewhere so that you can restore it in case of a database breakdown. The most common causes of a breakdown include the following:
Continue reading Automating SQL Server Backups on Windows: Why You Need It and How to Do It
During the backup you can get the following error message:
[SRV:8007#1326] Authorization failed. Computer name: <computer name>. Username: <user name>. Domain: <domain> > The user name or password is incorrect Computer name: <computer name> Continue reading [SRV:8007#1326] The User Name or Password is Incorrect
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 create MySQL backup doesn’t support the –column-statistics parameter (it should be older than 8.0.2). Continue reading [DBMS-MSSQL:11006#11007] MySQL backup error: unknown variable ‘column-statistics=0’