Yes, there are multiple solutions. One is to run the [SCRIPT SQL statement][1]:

    SCRIPT TO &#39;fileName&#39;

Another is to use the [Script tool][2]:

    java org.h2.tools.Script -url &lt;url&gt; -user &lt;user&gt; -password &lt;password&gt;

Then, there are also the [RUNSCRIPT statement][3] and RunScript tool.

By the way, you should consider upgrading to a more recent version of H2. With newer versions, the two files .data.db and .index.db are combined in to a .h2.db file.


  [1]: http://www.h2database.com/html/commands.html#script
  [2]: http://h2database.com/javadoc/org/h2/tools/Script.html#main_String...
  [3]: http://www.h2database.com/html/commands.html#runscript

If you want to get **schema** and **data,** you can use 

    SCRIPT TO &#39;dump.sql&#39;;

If you want to get only **schema**, you can use 

    SCRIPT SIMPLE TO &#39;dump.txt&#39;;




Your shortcut:

```
$ ls
foo.mv.db

$ wget -O h2.jar https://search.maven.org/remotecontent?filepath=com/h2database/h2/1.4.200/h2-1.4.200.jar

$ ls
foo.mv.db
h2.jar

$ java -cp h2.jar org.h2.tools.Script -url &quot;jdbc:h2:file:./foo&quot; -user sa -password &quot;&quot;

$ ls
backup.sql
foo.mv.db
h2.jar

$ cat backup.sql | head -n 20
;
CREATE USER IF NOT EXISTS &quot;SA&quot; SALT &#39;bbe17...redacted...&#39; HASH &#39;a24b84f1fe898...redacted...&#39; ADMIN;
CREATE SEQUENCE &quot;PUBLIC&quot;.&quot;HIBERNATE_SEQUENCE&quot; START WITH 145;
CREATE CACHED TABLE &quot;PUBLIC&quot;.&quot;...redacted...&quot;(
    &quot;ID&quot; INTEGER NOT NULL SELECTIVITY 100,
    [...redacted...]
    &quot;...redacted...&quot; VARCHAR(255) SELECTIVITY 100
);
ALTER TABLE &quot;PUBLIC&quot;.&quot;...redacted...&quot; ADD CONSTRAINT &quot;PUBLIC&quot;.&quot;CONSTRAINT_8&quot; PRIMARY KEY(&quot;ID&quot;);
-- 102 +/- SELECT COUNT(*) FROM PUBLIC.[...redacted...];
INSERT INTO &quot;PUBLIC&quot;.&quot;...redacted...&quot; VALUES
([...redacted...]),
```

This method:

    boolean containsSmiley(String s) {
        if (s == null) {
            return false;
        }
        else {
            return s.contains(&quot;:)&quot;);
        }
    }

can equivalently be written:

    boolean containsSmiley(String s) {
        if (s == null) {
            return false;
        }
    
        return s.contains(&quot;:)&quot;);
    }

In my experience, the second form is seen more often, especially in more complex methods (where there may be several such exit points), and the same is true for &quot;throw&quot; as well as &quot;return&quot;. Yet the first form arguably makes the conditional structure of the code more explicit. Are there any reasons to prefer one over the other?

(Related: [Should a function have only one return statement?][1])


  [1]: https://stackoverflow.com/questions/36707/should-a-function-have-only-one-return-statement

Why is &quot;else&quot; rarely used after &quot;if x then return&quot;?

I am using Bash on RedHat. I need to schedule a cron job to run at at 9:00 AM on first Sunday of every month. How can I do this?

How to schedule to run first Sunday of every month

I have H2DB database which stores data in files. I have 3 files: `test.18.log.db`, `test.data.db`, and `test.index.db`.

I want get SQL dump file like when I use `mysqldump`. Is it possible?


How in H2DB get sql dump like in MySql?

<p>I have H2DB database which stores data in files. I have 3 files: <code>test.18.log.db</code>, <code>test.data.db</code>, and <code>test.index.db</code>.</p>
<p>I want get SQL dump file like when I use <code>mysqldump</code>. Is it possible?</p>


I&#39;m playing around with a little web app in web.py, and am setting up a url to return a JSON object. What&#39;s the best way to convert a SQL table to JSON using python? 

return SQL table as JSON in python

How to convert a column value from `varbinary(max)` to `varchar` in human-readable form?

varbinary to string on SQL Server

I have a SQL Server 2008 DB with many tables filled with data and I used SQL Server Management Studio to generate a SQL dump by using the Script Wizard : Tasks -&gt; Generate Scripts -&gt; Script All objects in the selected database and also selecting the option to Script Data. I made sure to change the value of &quot;Script for Server Version&quot; to &quot;SQL Server 2008&quot;. Then I created a new DB and ran the SQL dump on the new DB to generate an identical copy of the old DB. Then I assigned permissions to my default user to the new DB. Then I changed the connection string on my ASP.NET application to use the new DB. But when I run it, it throws the following exception - 

				Server Error in &#39;/myapp&#39; Application.
				The &#39;System.Web.Security.SqlMembershipProvider&#39; requires a database schema compatible with schema version &#39;1&#39;.  However, the current database schema is not compatible with this version.  You may need to either install a compatible schema with aspnet_regsql.exe (available in the framework installation directory), or upgrade the provider to a newer version.
				Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

				Exception Details: System.Configuration.Provider.ProviderException: The &#39;System.Web.Security.SqlMembershipProvider&#39; requires a database schema compatible with schema version &#39;1&#39;.  However, the current database schema is not compatible with this version.  You may need to either install a compatible schema with aspnet_regsql.exe (available in the framework installation directory), or upgrade the provider to a newer version.

				Source Error:

				An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

				Stack Trace:

				[ProviderException: The &#39;System.Web.Security.SqlMembershipProvider&#39; requires a database schema compatible with schema version &#39;1&#39;.  However, the current database schema is not compatible with this version.  You may need to either install a compatible schema with aspnet_regsql.exe (available in the framework installation directory), or upgrade the provider to a newer version.]
				   System.Web.Util.SecUtility.CheckSchemaVersion(ProviderBase provider, SqlConnection connection, String[] features, String version, Int32&amp; schemaVersionCheck) +1977772
				   System.Web.Security.SqlMembershipProvider.CheckSchemaVersion(SqlConnection connection) +89
				   System.Web.Security.SqlMembershipProvider.GetPasswordWithFormat(String username, Boolean updateLastLoginActivityDate, Int32&amp; status, String&amp; password, Int32&amp; passwordFormat, String&amp; passwordSalt, Int32&amp; failedPasswordAttemptCount, Int32&amp; failedPasswordAnswerAttemptCount, Boolean&amp; isApproved, DateTime&amp; lastLoginDate, DateTime&amp; lastActivityDate) +815
				   System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved, String&amp; salt, Int32&amp; passwordFormat) +105
				   System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved) +42
				   System.Web.Security.SqlMembershipProvider.ValidateUser(String username, String password) +78
				   System.Web.UI.WebControls.Login.AuthenticateUsingMembershipProvider(AuthenticateEventArgs e) +60
				   System.Web.UI.WebControls.Login.OnAuthenticate(AuthenticateEventArgs e) +119
				   System.Web.UI.WebControls.Login.AttemptLogin() +115
				   System.Web.UI.WebControls.Login.OnBubbleEvent(Object source, EventArgs e) +101
				   System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +37
				   System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +118
				   System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +166
				   System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
				   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
				   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36
				   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1565



The &#39;System.Web.Security.SqlMembershipProvider&#39; requires a database schema compatible with schema version &#39;1&#39;

    db = sqlite.connect(&quot;test.sqlite&quot;)
    res = db.execute(&quot;select * from table&quot;)

With iteration I get lists coresponding to the rows.

    for row in res:
        print row

I can get name of the columns

    col_name_list = [tuple[0] for tuple in res.description]

But is there some function or setting to get dictionaries instead of list?

    {&#39;col1&#39;: &#39;value&#39;, &#39;col2&#39;: &#39;value&#39;}

or I have to do myself?

How can I get dict from sqlite query?

I&#39;m adding this table:


    CREATE TABLE contenttype (
            contenttypeid INT UNSIGNED NOT NULL AUTO_INCREMENT,
            class VARBINARY(50) NOT NULL,
            packageid INT UNSIGNED NOT NULL,
            canplace ENUM(&#39;0&#39;,&#39;1&#39;) NOT NULL DEFAULT &#39;0&#39;,
            cansearch ENUM(&#39;0&#39;,&#39;1&#39;) NOT NULL DEFAULT &#39;0&#39;,
            cantag ENUM(&#39;0&#39;,&#39;1&#39;) DEFAULT &#39;0&#39;,
            canattach ENUM(&#39;0&#39;,&#39;1&#39;) DEFAULT &#39;0&#39;,
            isaggregator ENUM(&#39;0&#39;, &#39;1&#39;) NOT NULL DEFAULT &#39;0&#39;,
            PRIMARY KEY (contenttypeid),
            UNIQUE KEY packageclass (packageid, class)
    );

And I get a 1050 &quot;table already exists&quot;

But the table does NOT exist. Any ideas?

EDIT: more details because everyone seems to not believe me :)

    DESCRIBE contenttype

yields:

&gt; 1146 - Table &#39;gunzfact_vbforumdb.contenttype&#39; doesn&#39;t exist

and


    CREATE TABLE gunzfact_vbforumdb.contenttype(
    contenttypeid INT UNSIGNED NOT NULL AUTO_INCREMENT ,
    class VARBINARY( 50 ) NOT NULL ,
    packageid INT UNSIGNED NOT NULL ,
    canplace ENUM( &#39;0&#39;, &#39;1&#39; ) NOT NULL DEFAULT &#39;0&#39;,
    cansearch ENUM( &#39;0&#39;, &#39;1&#39; ) NOT NULL DEFAULT &#39;0&#39;,
    cantag ENUM( &#39;0&#39;, &#39;1&#39; ) DEFAULT &#39;0&#39;,
    canattach ENUM( &#39;0&#39;, &#39;1&#39; ) DEFAULT &#39;0&#39;,
    isaggregator ENUM( &#39;0&#39;, &#39;1&#39; ) NOT NULL DEFAULT &#39;0&#39;,
    PRIMARY KEY ( contenttypeid ) ,


Yields:


&gt; 1050 - Table &#39;contenttype&#39; already exists

Mysql 1050 Error &quot;Table already exists&quot; when in fact, it does not

I use maven conventions for source paths (src/main src/test) and i have my sql scripts in src/main/resources/scripts.

I want to run my app with H2 memory and i&#39;d like to use the jdbc url to initialize my db :

    database.url=jdbc:h2:mem:;INIT=RUNSCRIPT FROM &#39;src/main/resources/scripts/create.sql&#39;;

My problem is that this relative path (src/main/... ) does not work, and that H2 won&#39;t crash if the init=runscript command targets nothing.

Does someone know what is the path i should use to make this work ?

Thanks

problem with INIT=RUNSCRIPT and relative paths

(I&#39;ve already seen the [H2 database In memory - Init schema via Spring/Hibernate][1] question; it is not applicable here.)

I&#39;d like to know if there&#39;s a setting in H2 that will allow me to auto-create a schema upon connecting to it.  If it helps, I&#39;m only interested in the in-memory case.

H2 supports various semicolon-separated modifiers at the end of the URL, but I didn&#39;t find one for automatically creating a schema.  Is there such a feature?

  [1]: https://stackoverflow.com/questions/1945175/h2-database-in-memory-init-schema-via-spring-hibernate

Can I have H2 autocreate a schema in an in-memory database?

I&#39;ve got a H2 database with URL `&quot;jdbc:h2:test&quot;`. I create a table using `CREATE TABLE PERSON (ID INT PRIMARY KEY, FIRSTNAME VARCHAR(64), LASTNAME VARCHAR(64));`. I then select everything from this (empty) table using `SELECT * FROM PERSON`. So far, so good.

However, if I change the URL to `&quot;jdbc:h2:mem:test&quot;`, the only difference being the database is now in memory only, this gives me an `org.h2.jdbc.JdbcSQLException: Table &quot;PERSON&quot; not found; SQL statement: SELECT * FROM PERSON [42102-154]`. I&#39;m probably missing something simple here, but any help would be appreciated.

H2 in-memory database. Table not found

Is there a way to browse the content of an H2 or an HSQLDB in-memory database for viewing? For example, during a debugging session with Hibernate in order to check when the flush is executed; or to make sure the script that instantiates the DB gives the expected result.

Does it exist an addon or a library that you can embed with your code in order to allow this?

Please, mention which one you&#39;re talking about (H2 or HSQLDB) in case you have an answer specific to one of them.

View content of H2 or HSQLDB in-memory database

I am trying to use the H2 database from a Java application. 

I created the database and its tables through the H2 Console and then I try to connect from Java using 

    Connection con = DriverManager.getConnection(&quot;jdbc:h2:~/dbname&quot;, &quot;username&quot;, &quot;password&quot;);

However I receive the following error:

&gt; Exception in thread &quot;main&quot; org.h2.jdbc.JdbcSQLException: Database may be already in use: &quot;Locked by another process&quot;. Possible solutions: close all other connection(s); use the server mode [90020-161]

I  tried to delete the `dbname.lock.db` file but it is automatically re-created.

How can I unlock the database to use it from my Java program?

H2 database error: Database may be already in use: &quot;Locked by another process&quot;

I am using `kill -3` command to see the JVM&#39;s thread dump in unix. But where can I find the output of this `kill` command? I am lost!!

kill -3 to get java thread dump

I have used `mongodump` to dump my database of mongodb, it created some bson files under `dump/mydb`

But I don&#39;t know how to use them. I tried `mongoimport`, but seems it can&#39;t import bson data. Then how to use these bson files? How to import them to another mongodb?

How to use the dumped data by mongodump?

Is it possible to create a Dump of SQL commands from a Microsoft Access database? I hope to convert this MDB file into a MySQL database for importing so I don&#39;t have to go through the CSV step.

I would expect even an MSSQL dump file to still contain workable SQL commands, but I know nothing of MSSQL, please let me know.

How can I convert an MDB (Access) file to MySQL (or plain SQL file)?

I am getting the following exception when trying to open HPROF file (created by `Debug.dumpHprofData`) with Memory Analyzer:

    java.io.IOException: Unknown HPROF Version (JAVA PROFILE 1.0.3)
    at org.eclipse.mat.hprof.AbstractParser.readVersion(AbstractParser.java:124)
    at org.eclipse.mat.hprof.Pass1Parser.read(Pass1Parser.java:69)
    at org.eclipse.mat.hprof.HprofIndexBuilder.fill(HprofIndexBuilder.java:65)
    at org.eclipse.mat.parser.internal.SnapshotFactoryImpl.parse(SnapshotFactoryImpl.java:203)
    at org.eclipse.mat.parser.internal.SnapshotFactoryImpl.openSnapshot(SnapshotFactoryImpl.java:114)
    at org.eclipse.mat.snapshot.SnapshotFactory.openSnapshot(SnapshotFactory.java:143)
    at org.eclipse.mat.snapshot.SnapshotFactory.openSnapshot(SnapshotFactory.java:123)
    at org.eclipse.mat.ui.snapshot.ParseHeapDumpJob.run(ParseHeapDumpJob.java:56)
    at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)

How do I resolve this?


error opening HPROF file: IOException: Unknown HPROF Version

I just recently started looking at dump files to help me analyze crashes of the w3wp process on our production environment at work...

And I would like to know, what are the differences between a minidump and a fulldump file ?

Content Type	Original Author	Original Content on Stackoverflow
Question	palych063	View Question on Stackoverflow
Solution 1 - Sql	Thomas Mueller	View Answer on Stackoverflow
Solution 2 - Sql	ahmeticat	View Answer on Stackoverflow
Solution 3 - Sql	debuglevel	View Answer on Stackoverflow

How in H2DB get sql dump like in MySql?

Sql Problem Overview

Sql Solutions

Solution 1 - Sql

Solution 2 - Sql

Solution 3 - Sql

How to schedule to run first Sunday of every month

Why is "else" rarely used after "if x then return"?

Attributions