Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2004
    Posts
    3

    Post Unanswered: Stored procedure

    How can I run stored procedure in Mysql 5.0 ?
    The reference manal says that I have to run the script fix_privilege_tables.sql . But the file is missing.

  2. #2
    Join Date
    Feb 2004
    Location
    Canada
    Posts
    4
    The script is actually called "mysql_fix_privilege_tables.sql", ...if that helps. And it's located in the "scripts" folder of the mysql installation. I've installed MySQL 5.x on a WinXP machine. Accepting the default installation parameters, the scripted files were placed in a directory called c:\mysql\scripts.

    If you're having trouble on a MS-Windows installation, you might want to check the PATH variable and consider any previous installations of MySQL that you might have on the machine. That could be interfering. I had mySQL 4.0.x installed(which installs to c:\mysql-4.0.x) and had some trouble on my system because when I tried to run the "fix" script, Windows kept looking through the 4.0.x installation directories.

    Hope this helps...

  3. #3
    Join Date
    Feb 2004
    Posts
    3

    Talking where it?Is It?

    OK, but I cant find de script .

    I have the follow scripts in directory c:\mysql\scripts:

    fix_privilege_tables (no extension) and
    fix_privilege_tables.sh --> It's same.

    #!/bin/sh
    # This script is a wrapper to pipe the mysql_fix_privilege_tables.sql
    # through the mysql client program to the mysqld server

    # Default values (Can be changed in my.cnf)
    password=""
    host="localhost"
    user="root"
    sql_only=0
    basedir=""
    verbose=0
    args=""

    file=mysql_fix_privilege_tables.sql

    # The following code is almost identical to the code in mysql_install_db.sh
    ...
    ...
    ... continue...


    that´s it? I can´t run it. It is not SQL syntax.
    I think that the script have a:
    " create table proc (colum 1 type,....)"

    thanks for the atention!

    BARBABELA

    excuse for the english errors. I'm Brazilian

  4. #4
    Join Date
    Feb 2004
    Location
    Canada
    Posts
    4
    You're on the right track. I see, in my installation, the two scripts that you do(of course, they're actually named "mysql_fix_privilege..."). But I've also got the "mysql_fix_privilege_tables.sql" file, that you seem to be missing.

    Either your copy of MySQL was flawed and didn't come with the script, or the script was accidentally deleted/renamed/moved on your PC. I'd suggest reinstalling mysql(probably uninstall current copy first). If that doesn't work then, if it's possible, download a fresh copy of mySQL and reinstall. Maybe choose a different mirror to download from?

    Your English is fine...and it's certainly better than my Portuguese!

  5. #5
    Join Date
    Feb 2004
    Posts
    21

    Re: Stored procedure

    Originally posted by williambms
    How can I run stored procedure in Mysql 5.0 ?
    The reference manal says that I have to run the script fix_privilege_tables.sql . But the file is missing.

    Where did u get My SQL 5.0 download. Please mail me
    at joydip_kanjilal@rediffmail.com



Posting Permissions

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