Manual Backups

[Boxman80 352]

Does anyone know how to perform a manual backup using HeidiSQL?  Is it just the "export database as SQL"?

 

Thanks in advance for helping a newbie! 

Edited January 28, 2016 by Boxman80

[red_ned 658]

yup that's the one @Boxman80 , just remember to select the data being exported, do the drop/create table but unless the SQL install is on your own machine don't select create/drop database, then select zip

 

Edited January 29, 2016 by red_ned

[Boxman80 352]

Sweet, thanks very much @red_ned

[Boxman80 352]

Sorry to be a pain but does anyone know or can anyone help me in creating a batch file to automatically connect and create a batch file  - or is it easier to schedule this via HeidiSQL?

[Sukkaed 56]

Run this with windows scheduler.

SET BackupDir="C:\path\to\backup\folder\"
SET mysqldir="C:\wamp\bin\mysql\mysql5.6.17\bin\"
SET mysqlschema=yourdatabasename
SET mysqluser=yourdatabaseuser
SET mysqlpassword=userpassword

for /F "usebackq tokens=1,2 delims==" %%i in (`wmic os get LocalDateTime /VALUE 2^>NUL`) do if '.%%i.'=='.LocalDateTime.' SET ldt=%%j
set datestamp=%ldt:~0,4%-%ldt:~4,2%-%ldt:~6,2%.%ldt:~8,2%-%ldt:~10,2%-%ldt:~12,2%
c:
cd %mysqldir%
mysqldump -u %mysqluser% -p%mysqlpassword% --databases %mysqlschema% --routines --events --triggers --quick >%BackupDir%\%mysqlschema%_backup.%datestamp%.sql

 

[Boxman80 352]

Cheers Sukkaed! Top man!

[TheMeq 26]

Brilliant, using this as well! Thanks