Re: Grails - H2 Database - dbconsole- How to take database backup..?

[Wim Deblauwe]

Looking at the jdbc url, it seems you are using MySQL, not h2. To create a database backup with mysql, have a look at mysqldump command.

regards,

Wim

Op dinsdag 9 oktober 2012 15:12:37 UTC+2 schreef Maazy het volgende:

I am very new to H2 , grails 2.0 comes with h2 database and dbconsole.

it tools section of dbconsole there is a option to take database backup,

it asks 2 things 

Target file name:  ~/backup.zip (by default) Source directory:  ~ (by default) Source database name: opal (my database name) if i press run , system gives following message Command line: java -cp h2*.jar org.h2.tools.Backup -file "~/backup.zip" -dir "~" Result: No database files have been found in directory C:/Documents and Settings/Hussain for the database opal  my sql  url = "jdbc:mysql://localhost/opal" user name : root password :  (none) so, what is the correct way of taking database backup in dbconsole?