0

I'm trying to connect to an SQL database, but am having a lot of trouble with it. Any and all help would be greatly appreciated.

As you can see below, the location of the sql file is /Users/agoodkind/mockup/test-database.sql:
Finder window

In DbVisualizer, I have the following settings:
Dbvisualizer screenshot

The entirety of the Connection Message says:

An error occurred while establishing the connection:

Long Message: Unknown database '/users/agoodkind/mockup/test-database.sql'

Details:
Type: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException
Error Code: 1049
SQL State: 42000

If someone could point me in the right direction, I would really appreciate it.

Adam_G
  • 7,337
  • 20
  • 86
  • 148

1 Answers1

0

test-database.sql is not an actual database it's most likely a text file of SQL statements to build a database.

James Allman
  • 40,573
  • 11
  • 57
  • 70
  • Got it. So what should I do with it? – Adam_G Jul 18 '12 at 20:40
  • @Adam_G You should probably create a database and execute the SQL statements against that database. The details of what exactly needs to be done would depend entirely on the source code you are working with. I'm afraid you haven't provided enough information to be more specific. – James Allman Jul 18 '12 at 20:54