Hi, See http://www.h2database.com/html/grammar.html#runscript - fileNameString is a quoted string. Example: RUNSCRIPT FROM 'backup'
Regards, Thomas On Fri, Mar 13, 2009 at 7:29 PM, Alex <[email protected]> wrote: > > I am running the command line H2 shell and trying to script the DB > into a file. > ============================================================================== > Welcome to H2 Shell 1.1.108 (2009-02-28) > Exit with Ctrl+C > Commands are case insensitive; SQL statements end with ';' > help or ? Display this help > list Toggle result list mode > maxwidth Set maximum column width (default is 100) > show List all tables > describe Describe a table > quit or exit Close the connection and exit > > sql> script to myfile; > Error: org.h2.jdbc.JdbcSQLException: Column MYFILE not found; SQL > statement: > script to myfile [42122-108] > ============================================================================== > Welcome to H2 Shell 1.1.108 (2009-02-28) > Exit with Ctrl+C > Commands are case insensitive; SQL statements end with ';' > help or ? Display this help > list Toggle result list mode > maxwidth Set maximum column width (default is 100) > show List all tables > describe Describe a table > quit or exit Close the connection and exit > > sql> script simple to myfile; > Error: org.h2.jdbc.JdbcSQLException: Column MYFILE not found; SQL > statement: > script simple to myfile [42122-108] > ============================================================================== > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/h2-database?hl=en -~----------~----~----~----~------~----~------~--~---
