+ 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
    3,035
    Thank Post
    305
    Thanked 293 Times in 203 Posts
    Rep Power
    120

    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,408
    Thank Post
    640
    Thanked 961 Times in 661 Posts
    Blog Entries
    2
    Rep Power
    326

    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
    3,035
    Thank Post
    305
    Thanked 293 Times in 203 Posts
    Rep Power
    120

    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,987
    Thank Post
    120
    Thanked 283 Times in 261 Posts
    Rep Power
    107

    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,408
    Thank Post
    640
    Thanked 961 Times in 661 Posts
    Blog Entries
    2
    Rep Power
    326

    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,249
    Thank Post
    671
    Thanked 1,643 Times in 1,466 Posts
    Rep Power
    424

    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
    3,035
    Thank Post
    305
    Thanked 293 Times in 203 Posts
    Rep Power
    120

    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,592
    Thank Post
    109
    Thanked 769 Times in 598 Posts
    Rep Power
    181

    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,628
    Thank Post
    920
    Thanked 1,336 Times in 816 Posts
    Blog Entries
    1
    Rep Power
    448

    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,832
    Thank Post
    918
    Thanked 423 Times in 356 Posts
    Blog Entries
    12
    Rep Power
    88

    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,249
    Thank Post
    671
    Thanked 1,643 Times in 1,466 Posts
    Rep Power
    424

    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,628
    Thank Post
    920
    Thanked 1,336 Times in 816 Posts
    Blog Entries
    1
    Rep Power
    448

    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,408
    Thank Post
    640
    Thanked 961 Times in 661 Posts
    Blog Entries
    2
    Rep Power
    326

    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
  •