backup script code om wp sites te importeren en exporteren
@ECHO OFF
CLS
SET database=riskid
IF "%COMPUTERNAME%"=="ERIK-PC" (
SET onedrive=D:\OneDrive - Based Online\Webprojecten\Studio Lemon
SET website=D:\server\Ampps\www\riskid.dev\
SET mysql=D:\server\Ampps\mysql
) else (
SET onedrive=C:\OneDrive - Based Online\Studio Lemon\riskid
SET website=C:\Ampps\www\woonhuysgouda.dev
SET mysql=C:\Ampps\mysql
)
set /p task="import of export van %COMPUTERNAME%: "
IF "%task%"=="export" (
ECHO Export plugins
"C:\Program Files\WinRAR\WinRAR.exe" a -afzip -ep1 -o+ -r "%onedrive%\plugins.zip" "%website%\plugins"
ECHO Export uploads
"C:\Program Files\WinRAR\WinRAR.exe" a -afzip -ep1 -r -o+ "%onedrive%\uploads.zip" "%website%\uploads"
ECHO Export database
"%mysql%\bin\mysqldump.exe" --no-create-db --user=root --password=mysql %database% > "%onedrive%\%database%.sql"
)
IF "%task%"=="import" (
ECHO import plugins
"C:\Program Files\WinRAR\winrar.exe" x -o+ "%onedrive%\plugins.zip" *.* "%website%\wp-content\"
ECHO import uploads
"C:\Program Files\WinRAR\winrar.exe" x -o+ "%onedrive%\uploads.zip" *.* "%website%\wp-content\"
ECHO Import database
"%mysql%\bin\mysql.exe" -u root %database% < "%onedrive%\%database%.sql
)