Levdbas
2/23/2017 - 11:34 AM

backup script code om wp sites te importeren en exporteren

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
)