List:General Discussion« Previous MessageNext Message »
From:Quentin Bennett Date:February 6 2001 10:00pm
Subject:RE: creating tables from the shell
View as plain text  
Hi,

mysql -vvv samp_db < create_member.sql

should tell what commands mysql is executing.

Regards

Quentin

-----Original Message-----
From: Michael Tuminello [mailto:mt@stripped]
Sent: Wednesday, 7 February 2001 10:05
To: mysql@stripped
Subject: creating tables from the shell


Hey -

sorry for being too much of a pinhead to figure this out, but the 
server is really not giving me too many clues to work with.

I'm trying to execute commands from the shell to create new tables 
(I'm walking through the new riders book).

the book says % mysql samp_db < create_member.sql

for me, for whatever reason, mysql will not execute except from its 
root directory.  so I'm doing
% ./bin/mysql samp_db < ./var/mysql/create_member.sql
(the book also doesn't tell you where to put the executible scripts, 
so I stuck them in the data directory)

can anyone tell me why this isn't working?  it seems to execute (no 
error), but nothing happens.   Also, can anyone tell me if there is a 
way to get the server to tell you a little more about why things 
don't work?  I could use some help debugging, and the log entries are 
pithy, to say the least.

thanks in advance-

MT

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <mysql-thread64401@stripped>
To unsubscribe, e-mail
<mysql-unsubscribe-quentin.bennett=infinity.co.nz@stripped>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

The information contained in this email is privileged and confidential
and intended for the addressee only. If you are not the intended 
recipient, you are asked to respect that confidentiality and not 
disclose, copy or make use of its contents. If received in error 
you are asked to destroy this email and contact the sender immediately. 
Your assistance is appreciated.
Thread
creating tables from the shellMichael Tuminello6 Feb
  • RE: creating tables from the shellRoger Ramirez6 Feb
    • RE: creating tables from the shellMichael Tuminello6 Feb
RE: creating tables from the shellQuentin Bennett6 Feb