+ 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,768
    Thank Post
    251
    Thanked 220 Times in 168 Posts
    Rep Power
    87

    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,370
    Thank Post
    624
    Thanked 949 Times in 651 Posts
    Blog Entries
    2
    Rep Power
    317

    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,768
    Thank Post
    251
    Thanked 220 Times in 168 Posts
    Rep Power
    87

    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,936
    Thank Post
    114
    Thanked 272 Times in 250 Posts
    Rep Power
    104

    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,370
    Thank Post
    624
    Thanked 949 Times in 651 Posts
    Blog Entries
    2
    Rep Power
    317

    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
    12,959
    Thank Post
    586
    Thanked 1,493 Times in 1,339 Posts
    Rep Power
    397

    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,768
    Thank Post
    251
    Thanked 220 Times in 168 Posts
    Rep Power
    87

    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,582
    Thank Post
    107
    Thanked 761 Times in 592 Posts
    Rep Power
    179

    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,569
    Thank Post
    868
    Thanked 1,293 Times in 786 Posts
    Blog Entries
    1
    Rep Power
    436

    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,530
    Thank Post
    815
    Thanked 380 Times in 317 Posts
    Blog Entries
    12
    Rep Power
    80

    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
    12,959
    Thank Post
    586
    Thanked 1,493 Times in 1,339 Posts
    Rep Power
    397

    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,569
    Thank Post
    868
    Thanked 1,293 Times in 786 Posts
    Blog Entries
    1
    Rep Power
    436

    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,370
    Thank Post
    624
    Thanked 949 Times in 651 Posts
    Blog Entries
    2
    Rep Power
    317

    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
  •