MySQL Databases

[timbo343]

Heya

Im trying to configure MYSQL to create tables. It is to do with the MRBS (the room booking software). So ive created the mrbs folder using "mysqladmin create mrbs" but have a problem running "mysql mrbs < tables.my.sql". Im logged in locally to the machine so ive got all user rights.

Can anyone help?

Tim

[webman]

Regardless of being logged in locally, mysql user rights to create databases and tables are completely separate.

What problems are you having? Are any error messages being shown when you run the commands? Are those instructions direct from the MRBS manual?

Either way, I think you'll need to provide a username and/or password at some point.

[timbo343]

basically, im running mysql mrbs < tables.my.sql and getting an error of the system cannont find the file specified. Ive done a search in windows for *.sql but nothing appears.

and craig, am using MRBS till yours has LDAP in it, hopefully, yours is easier to configure and wont be that long till you get it set up

[ChrisH]

Download the windows admin GUI if your struggling it will make life a little easier. Its on the official MySQL site.

[webman]

Ok, it looks as if it can't find the tables.my.sql file to import.

You'll need to either a) 'cd' to the directory where the tables.my.sql file is then run the mysql command; or b) type the full path to the file.

eg:

C:\www\mrbs\db>mysql mrbs < tables.my.sql

or

C:\>mysql mrbs < c:\www\mrbs\db\tables.my.sql

[plexer]

Tim: Are you running this on doze or nix?

If you struggle with the commandline install phymyadmin to give you a web based gui for all things mysql.

Ben

[timbo343]

i found the problem, i had a senior moment, i forgot to copy the right files over. oops. but now apache will not start on the machine... jpb for 2morrow i think and as for seeing the main home page, that aint happening either.

[Ric_]

@timbo343: I find webmin to be a very easy way of daoing all this stuff.

[ZeroHour]

Try this out:
http://www.heidisql.com/
It will import your SQL.

[zag]

I use phpmyadmin, it even lets you input sql commands directly, command line is far too complicated

[plexer]

wow heidi is indeed a handy lady.

Looks good so I can now update from the commandline on the box, phpmyadmin and now heidi on my doze machine

Ben

[ZeroHour]

wow heidi is indeed a handy lady.

Looks good so I can now update from the commandline on the box, phpmyadmin and now heidi on my doze machine

Ben

Hehe CLI means you are a l33t hax0r
Yeh I love heidi, it used to be called MySQLFront and was commercial (and cheap) but MySQL forced them to stop so they went open source.

[webman]

Yeh I love heidi

... jsut don't tell the missus!