Error on startup

[Lorenzo Rossi]

Hi.
My system is Slackware 9.1.
MySQL is the default version installed on Slackware cdrom while system 
installation, so I hope all the path are ok :)
Then launched mysqld_install_db... but when I try to startup the server 
an error occured wrote in /usr/local/mysql/ginlemon.err
like this: 3:49:08 /usr/local/libexec/mysqld: Can't find file: 
'./mysql/host.frm' (errno: 13)
This is a tipical error for me, almost everytime I install mysql..:-(
Any one can put me on the right way?

Thanx, Lorenzo

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

Using query file from console

[Lorenzo Rossi]

Hello.
I need to run a query written in a file from inside mysql console, not 
shell prompt.
Anyone can help me?

Thanx

Lorenzo

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

Re: Using query file from console

[Lorenzo Rossi]

Hi,
my help command displays not so many options :(
Thanx a lot, bye.
Lorenzo

Fred van Engen wrote:

Hi,

On Fri, Aug 01, 2003 at 04:55:09PM +0200, Lorenzo Rossi wrote:
 

I need to run a query written in a file from inside mysql console, not 
shell prompt.
Anyone can help me?

   

mysql help

MySQL commands:
Note that all text commands must be first on line and end with ';'
help(\h)Display this help.
?   (\?)Synonym for `help'.
clear   (\c)Clear command.
connect (\r)Reconnect to the server. Optional arguments are db and host.
edit(\e)Edit command with $EDITOR.
ego (\G)Send command to mysql server, display result vertically.
exit(\q)Exit mysql. Same as quit.
go  (\g)Send command to mysql server.
nopager (\n)Disable pager, print to stdout.
notee   (\t)Don't write into outfile.
pager   (\P)Set PAGER [to_pager]. Print the query results via PAGER.
print   (\p)Print current command.
quit(\q)Quit mysql.
rehash  (\#)Rebuild completion hash.
source  (\.)Execute a SQL script file. Takes a file name as an argument.
status  (\s)Get status information from the server.
tee (\T)Set outfile [to_outfile]. Append everything into given outfile.
use (\u)Use another database. Takes database name as argument.
Connection id: 171359  (Can be used with mysqladmin kill)

mysql

So it looks like you could try the 'source' command. Copying the query
through your clipboard is another option.
Regards,

Fred.

 

Query error log

[Lorenzo Rossi]

Hello.
How can I recover query errors done on a mysql server?
Is there a log file?
It's very important to me to know about this.
Thanx so much!!!
Lorenzo

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