Create DB help

[Tony Martino]

Hello,

I am new with using mySQL.
I have a little problem

I am starting a new web site on which I wanna use the same DB I am using on another 
site (that was created by somebody else).  Instead of starting from scratch, I would 
like to use a copy of the DB we have, since we know it is already good and tested. 

I have an .sql file for the database structure.

I found this:
http://www.jsw4.net/info/list-archives/mysql/02-wk49/msg00049.html

I believe it is exactly what I need.
What I need to knwo now... could you please tell me WHERE I need to try:
 mysql -u{username} -p {databasename}filename.sql

Thank you very much in advance

Tony

Re: Create DB help

[Brian Reichert]

On Mon, Jun 21, 2004 at 12:01:06PM -0400, Tony Martino wrote:
 I believe it is exactly what I need.
 What I need to knwo now... could you please tell me WHERE I need to try:
  mysql -u{username} -p {databasename}filename.sql

This assumes a few things:

- that the database (as opposed to the tables in the database) has
  already been created.

- that '{username}' has the priviledges of writing to said database
  ('create table', and so forth.

As to 'where': from the command line.  'mysql' is the name of the
command-line client for MySQL.

Unless I'm misunderstandig your question...

 Thank you very much in advance
 
 Tony

-- 
Brian Reichert  [EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA BSD admin/developer at large

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]