Web Hosting Forums

Results 1 to 6 of 6

This is a discussion on SSH/Telnet in the Hosting Talk & Chit-chat forum
I need to make my Invisionboard create the FULLTEXT indexes and the db is to large to do this automatically so I'll need to do ...

  1. #1
    Loyal Client
    Join Date
    Mar 2003
    Location
    Norway
    Posts
    9

    SSH/Telnet

    I need to make my Invisionboard create the FULLTEXT indexes and the db is to large to do this automatically so I'll need to do it myself.

    I log onto mydomain and uses the mysql username and password.

    Then I need to initiate the mysql :

    mysql -u{your_sql_user_name} -p{your_sql_password}

    when entering this line I get access denied. Is my username/password wrong ?

    Best Regards
    Blackhat
    Best Regards
    R.A:.

  2. #2
    Rogue Developer
    Join Date
    Oct 2002
    Posts
    191
    Also enter your database name, ie:

    mysql {your_database_name} -u {your_sql_user_name} -p {your_sql_password}

  3. #3
    Loyal Client
    Join Date
    Mar 2003
    Location
    Norway
    Posts
    9
    It worked but I still get errors when trying to do the rest of the commands like these:


    use {database_name};
    Error Message: use: command not found

    \g alter table ibf_topics add fulltext(title);
    Error Message: syntax error near unexpected token `fulltext(t'

    \g alter table ibf_posts add fulltext(post);
    Error Message: syntax error near unexpected token `fulltext(p'
    Last edited by Blackhat; 06-27-2003 at 03:09 AM.
    Best Regards
    R.A:.

  4. #4
    Rogue Developer
    Join Date
    Oct 2002
    Posts
    191
    You won't need to do the use statement, as you've opened MySQL directly to your database.

    As for the fulltext problems... well, that's just confusing -- I don't see anything wrong with your statements (although I am somewhat curious regarding the "\g" before each one?). Which server are you on? What version of MySQL does it have? Full-Text search requires 3.23.23, but I can't imagine that'd be the problem...

  5. #5
    Loyal Client
    Join Date
    Mar 2003
    Location
    Norway
    Posts
    9
    MySQL Version is 3.23.56 and the statements are just from the invisionboards help file.
    Best Regards
    R.A:.

  6. #6
    Rogue Developer
    Join Date
    Oct 2002
    Posts
    191
    Can you try using the Create Index statment instead of alter table? It shouldn't make any difference, but who knows...

Bookmarks

Posting Permissions

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