+ Post New Thread
Results 1 to 13 of 13
Windows Thread, MySQL Databases in Technical; Heya Im trying to configure MYSQL to create tables. It is to do with the MRBS (the room booking software). ...
  1. #1
    timbo343's Avatar
    Join Date
    Dec 2005
    Location
    Leeds/York area, North Yorkshire
    Posts
    2,976
    Thank Post
    287
    Thanked 268 Times in 192 Posts
    Rep Power
    115

    MySQL Databases

    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

  2. #2

    webman's Avatar
    Join Date
    Nov 2005
    Location
    North East England
    Posts
    8,401
    Thank Post
    637
    Thanked 961 Times in 661 Posts
    Blog Entries
    2
    Rep Power
    319

    Re: MySQL Databases

    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.

  3. #3
    timbo343's Avatar
    Join Date
    Dec 2005
    Location
    Leeds/York area, North Yorkshire
    Posts
    2,976
    Thank Post
    287
    Thanked 268 Times in 192 Posts
    Rep Power
    115

    Re: MySQL Databases

    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

  4. #4
    ChrisH's Avatar
    Join Date
    Jun 2005
    Location
    East Lancs
    Posts
    4,998
    Thank Post
    120
    Thanked 280 Times in 258 Posts
    Rep Power
    106

    Re: MySQL Databases

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

  5. #5

    webman's Avatar
    Join Date
    Nov 2005
    Location
    North East England
    Posts
    8,401
    Thank Post
    637
    Thanked 961 Times in 661 Posts
    Blog Entries
    2
    Rep Power
    319

    Re: MySQL Databases

    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:

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

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

  6. #6

    plexer's Avatar
    Join Date
    Dec 2005
    Location
    Norfolk
    Posts
    13,329
    Thank Post
    622
    Thanked 1,578 Times in 1,415 Posts
    Rep Power
    413

    Re: MySQL Databases

    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

  7. #7
    timbo343's Avatar
    Join Date
    Dec 2005
    Location
    Leeds/York area, North Yorkshire
    Posts
    2,976
    Thank Post
    287
    Thanked 268 Times in 192 Posts
    Rep Power
    115

    Re: MySQL Databases

    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.

  8. #8

    Ric_'s Avatar
    Join Date
    Jun 2005
    Location
    London
    Posts
    7,590
    Thank Post
    109
    Thanked 762 Times in 593 Posts
    Rep Power
    180

    Re: MySQL Databases

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

  9. #9

    ZeroHour's Avatar
    Join Date
    Dec 2005
    Location
    Edinburgh, Scotland
    Posts
    5,641
    Thank Post
    894
    Thanked 1,314 Times in 798 Posts
    Blog Entries
    1
    Rep Power
    441

    Re: MySQL Databases

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

  10. #10
    zag
    zag is offline
    zag's Avatar
    Join Date
    Mar 2007
    Posts
    3,762
    Thank Post
    897
    Thanked 416 Times in 350 Posts
    Blog Entries
    12
    Rep Power
    86

    Re: MySQL Databases

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

  11. #11

    plexer's Avatar
    Join Date
    Dec 2005
    Location
    Norfolk
    Posts
    13,329
    Thank Post
    622
    Thanked 1,578 Times in 1,415 Posts
    Rep Power
    413

    Re: MySQL Databases

    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

  12. #12

    ZeroHour's Avatar
    Join Date
    Dec 2005
    Location
    Edinburgh, Scotland
    Posts
    5,641
    Thank Post
    894
    Thanked 1,314 Times in 798 Posts
    Blog Entries
    1
    Rep Power
    441

    Re: MySQL Databases

    Quote Originally Posted by 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
    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.

  13. #13

    webman's Avatar
    Join Date
    Nov 2005
    Location
    North East England
    Posts
    8,401
    Thank Post
    637
    Thanked 961 Times in 661 Posts
    Blog Entries
    2
    Rep Power
    319

    Re: MySQL Databases

    Quote Originally Posted by ZeroHour
    Yeh I love heidi
    ... jsut don't tell the missus!

SHARE:
+ Post New Thread

Similar Threads

  1. MYSQL Help
    By danIT in forum General Chat
    Replies: 2
    Last Post: 18th December 2007, 09:52 PM
  2. Databases and Visual Basic Express
    By Jobos in forum Coding
    Replies: 2
    Last Post: 1st July 2007, 10:19 AM
  3. Technical Databases
    By RobC in forum Educational Software
    Replies: 15
    Last Post: 21st April 2006, 06:45 PM
  4. Designing Access Databases
    By RobC in forum Windows
    Replies: 2
    Last Post: 20th December 2005, 11:56 AM
  5. php MySql
    By iking in forum Books and Manuals
    Replies: 0
    Last Post: 11th July 2005, 03:35 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •