Groups | Search | Server Info | Login | Register

Groups > comp.databases.mysql > #584

Re: Problem importing a database

Show all headers | View raw

On Wed, 20 Apr 2011 18:35:58 -0700, Martin <ironwoodcanyon@gmail.com>
wrote:

>On Wed, 20 Apr 2011 15:24:06 -0700 (PDT), dewed
><duane.lortie@gmail.com> wrote:
>
>>try adding a single line to the top of your file and then import it 
>>
>>USE DATABASENAME;
>>
>>
>>If the user has permissions to the specified database it should process with the import
>
>Thanks.
>
>I just now tried it - didn't work. This time I get error 1049 "Unknown
>database 'cwdb' ".  "cwdb" is, of course, the name I specified in the
>USE statement.
>
>Do I need to create this database before I run the import? I thought
>that the action of importing would create it. And, if I am supposed to
>create the database before running the script, how do I go about doing
>that. I don't see anything in MySQLWorkbench that would enable me to
>do that.
>

NEVERMIND......  I got it working!   :)

I finally figured out how to create a database (or schema as they call
it). After doing that and then using the USE statement as you
suggested, the import worked.

Now I can get on with things.

Thanks again.

Back to comp.databases.mysql | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Re: Problem importing a database dewed <duane.lortie@gmail.com> - 2011-04-20 15:24 -0700
  Re: Problem importing a database Martin <ironwoodcanyon@gmail.com> - 2011-04-20 18:35 -0700
    Re: Problem importing a database Martin <ironwoodcanyon@gmail.com> - 2011-04-20 19:06 -0700
  Re: Problem importing a database "Álvaro G. Vicario" <alvaro.NOSPAMTHANX@demogracia.com.invalid> - 2011-04-25 09:38 +0200

csiph-web