Quote:
Originally Posted by HuginnNavarita
On a side note...
Every week I dump the whole DB to a .SQL file
Everytime I want to work with something I back up the table I work with, let's say I wanna mess with settings in the table variable....then I start with dumping only that table to...
Variable_30.07.sql
I rename the file to have the date in it, that way when I have 20 or 30 SQL files in my backup location, it will be easy for me to backtrack tables with dates and timestamp if I need to go back.
Cause restoring the whole 330 MB is a bish!
|
I'm still learning Heidi, and I'm probably learning the PEQ database faster than the nuances of Heidi. I have not learned how to back up only portions of the DB. I have been just running the t_database_backup.bat every so often.