How do I make the database dump and load the dump file into database?
Right-click on the database node and choose “Dump database”. Save-dialog appears, navigate through the folders and choose where to put the dump file. After that, “Choose tables to dump” window appears where you may check/uncheck whitch tables you want to put in the dump file. If you want to dump the triggers, check the “dump triggers!” option too. After clicking “Ok” the dumping is starting. If you want to load the database dump file into database, right-click the desired database and choose “Load dump” option. Open-dialog appears so you can navigate through the folders and point to database dump file. When clicking “Ok”, loading the data from the file begins.
