Breaking News: Grepper is joining You.com. Read the official announcement!

mysql sichern batch datei

Harveyhase68 answered on March 29, 2023 Popularity 1/10 Helpfulness 1/10

answer mysql sichern batch datei

mysql sichern batch datei

Comment

In Windows, to dump MySql or MariaDB use mysqldump.exe here is a sample of a working .bat file:

@echo off
REM ********************************
REM **     BACKUP MYSQL	          **
REM ********************************
REM ** CREATE DATE WITHOUT " " **
set DATETIME=%date:~-4%-%date:~-7,2%-%date:~-10,2%-%time:~-11,2%-%time:~-8,2%-%time:~-5,2%
set DATETIME=%DATETIME: =%
REM ** SET DATE && TIME **
set sqlfile=%TEMP%\%DATETIME%.sql
REM ** SET DROPBOX FILE AND DIR **
set dropboxfile=%USERPROFILE%\Dropbox\dayly\%DATETIME%.zip
REM ** DELETE FILES OLDER THAN 1 MONTH TO SAVE SPACE **
ForFiles /P "%USERPROFILE%\Dropbox\dayly" /S /M *.zip /D -30 /C "cmd /c del @file"
REM ** EXPORT .SQL FROM MYSQL = PORT, USER, PASSWORD, DATABASE, SQL FILE
"C:\wamp\bin\mysql\mysql8.0.31\bin\mysqldump.exe" --port=3306 --user=root --password=*yourpw* *yourdb* > %sqlfile%
REM ** ZIP AND COPY TO DROPBOX DIRECTORY **
"C:\Program Files\7-Zip\7z.exe" a %dropboxfile% %sqlfile%
REM ** DELETE THE .SQL FILE SAVE SPACE **
DEL %sqlfile%

This example creates a .zip file for every backup you make, retaining only 30 days for saving space, each file gets a date/timestamp and we use 7-Zip which is open-source.

Popularity 1/10 Helpfulness 1/10 Language shell

Source: Grepper

Tags: mysql shell

Link to this answer
Share Copy Link

Contributed on Mar 29 2023

Harveyhase68

0 Answers Avg Quality 2/10

mysql sichern batch datei

Contents

More Related Answers

mysql sichern batch datei

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.