tables.sql, I'll bet, is a set of SQL instructions that will set up a
database and all its tables. You tell the mysql client program to read the
file and run everything in it.
first, in the MySQL manual read the part about adding users and setting an
admin password.
set up a user that the web server to connect to the database as.
you'll have to get the specifics form the manual but here's my cheat sheet:
log into the mysql client program as 'root':
#mysql mysql -u root -p
grant insert, select, delete, update on adatabase.* to webuser@localhost;
UPDATE user SET password=PASSWORD('yourpassword') where user = 'webuser';
next from the command line cd to the directory that holds tables.sql
then run:
#mysqladmin create tables
#mysql tables < tables.sql -u username --password=userpassword
where "tables" is the name of the database you are creating (I'm guessing
based on the filename)
the first line makes the database, the second tells the mysql client program
to execute the SQL commands in "tables.sql" as a particular user with a
particular password.
hopefully this will get you started.
good luck,
Gavin
on 10/8/00 5:44 PM, Asheesh Laroia wrote:
> I have a server (www.AsheeshEnterprises.com) set up, and I wanted to add a
> logging program to it. I downloaded "bitlog" which I found from
> freshmeat.net, and it requires MySQL. I have it installed, and running.
>
> So, the install instructions say:
>
> "First of all, you have to have PHP installed, and a working MySQL server.
> Create the necessary tables by running tables.sql through mysql."
>
> So, what do I do now? I have the file "tables.sql" in the directory, but
> have no idea how to "run it through mysql". I started MySQL via
> /etc/rc.d/init.d/mysql start, and it started fine.
>
> Help! I feel so inadequate. . . .
>
> ;-).
>
> Thanks in advance.
>
> -- Asheesh Laroia.
Keep in touch with http://mandrakeforum.com:
Subscribe the "[EMAIL PROTECTED]" mailing list.
