Mysql database backup error
I'm tying to create an automatic backup for my sql database which I host on my local computer. My goal is to create every day backups and copy backups to my google drive folder (automatically delete old backups)
System: Windows 10 Program: MySQL Workbench 6.3 Version 6.3.9 Community (free version)
I tried so far a few different ways but I always get the similar error.
I found this post "https://www.redolive.com/utah-web-designers-blog/automated-mysql-backup-for-windows/" --> I get an error message: "mysqldump: Got error: 2003: Can't connect to MySQL server on 'localhost' (10061) when trying to connect" (C:\MySQLBackups\backupfiles\dumperrors.txt)
I also tried it directly in the Command Prompt:
C:\Users\cube>cmd Microsoft Windows [Version 10.0.14393] (c) 2016 Microsoft Corporation. All rights reserved.
C:\Users\cube>cd C:\Program Files\MySQL\MySQL Server 5.7\bin
C:\Program Files\MySQL\MySQL Server 5.7\bin>mysqldump.exe -e -uroot -p*** -hlocalhost ucdbx > C:\XYZ.sql Access is denied.
OR with a different command (leads to the old error).
C:\Program Files\MySQL\MySQL Server 5.7\bin>mysqldump.exe Usage: mysqldump [OPTIONS] database [tables] OR mysqldump [OPTIONS] --databases [OPTIONS] DB1 [DB2 DB3...] OR mysqldump [OPTIONS] --all-databases [OPTIONS] For more options, use mysqldump --help C:\Program Files\MySQL\MySQL Server 5.7\bin>mysqldump database mysqldump: Got error: 2003: Can't connect to MySQL server on 'localhost' (10061) when trying to connect
I already checked: - opened as admin "Command Prompt" & "MySQLWorkbench.exe" - checked service in task manager that mysql57 is running - checked in taskbar that mysql notifier is running. (local host online and MySQL57 - running)
I'm new in database management. I already tried for a couple of days. I would really appreciate any ideas and input.