On Oct 14, 1:26 pm, "Paul Lautman" <paul.laut...@btinternet.com>
wrote:
> Sysop1...@gmail.com wrote:
> > On Oct 13, 6:40 pm, "Rik Wasmus" <luiheidsgoe...@hotmail.com> wrote:
> >> On Sun, 14 Oct 2007 00:24:32 +0200, <Sysop1...@gmail.com> wrote:
> >>> On Oct 13, 5:06 pm, "Paul Lautman" <paul.laut...@btinternet.com>
> >>> wrote:
> >>>> Sysop1...@gmail.com wrote:
> >>>>> So, to sum up:
>
> >>>>> 1. How do I import the .sql database into MySQL?
>
> >>>>> 2. When I tried to pull the database from the client site (W2K
> >>>>> box) using "mysqldump -u user -p pword database > database.sql"-
> >>>>> when I pushed enter, it just went to another line and gave me a
> >>>>> ">" prompt. Why did it do this? The reason I tried to do the
> >>>>> mysqldump is I thought maybe I pulled it wrong using the MySQL
> >>>>> admin.
>
> >>>>> Thanks.
>
> >>>> When you typed the mysqldump string, were you at the windows
> >>>> command prompt,
> >>>> or had you started the mysql command line client?
>
> >>> I think I tried it both ways. At the regular prompt and the
> >>> 'mysql>' prompt. Which way are you supposed to do it?
>
> >> Just in the shell.
>
> >> Getting a dump into a database I usually do in a mysql client though:
>
> >> mysql> SOURCE /path/to/dump.sql;
>
> >> (possibly with a foreign key check disable/reenable if the dump
> >> doesn't contain it)
> >> --
> >> Rik Wasmus
>
> > I got the .sql exported from the MySQL database (the one we have on
> > W2K). How do I import it into the already existing MySQL database on
> > our Red Hat box?
>
> Have you considered reading the manual?- Hide quoted text -
>
> - Show quoted text -

The manual at Mysql.com? Yes, I looked there. It said to do a "mysql
-u
username -p password datatbase < datatbase.sql" command at the Xterm,
but it didn't work. I got an error message.

Have you ever restored a SQL database to mysql? How did you do it?