[SOLVED] How to - Backup the database

[PrestonParsons]

Hello.

How to do back up the database from Hedisql ?

 

[Rochet2]

http://prntscr.com/4rdobe
http://prntscr.com/4rdo57

Unsure if there are other methods with heidi

 

[PrestonParsons]

What clipboard anyway?
i have done single .sql file lol

 

[kolakocide]

Or you can make it replace. If it's just the Creatures table or Item.

 

[PrestonParsons]

I had done with backup now, i am doing it every wednesday or do it every day ?

 

[lillecarl]

1. Download cygwin and install mysql client package
2. Start cygwin
3. mysqldump -h ipadddress -u username -p password databasename >> sqlfilename
4. Profit

 

[Tommy]

1. Download cygwin and install mysql client package
2. Start cygwin
3. mysqldump -h ipadddress -u username -p password databasename >> sqlfilename
4. Profit

He asked how to do it from HeidiSql, not a completely different program.

 

[Rochet2]

Also read this:
http://www.heidisql.com/forum.php?t=6293