Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Where Sp's Saved On The Hd

forums › forums › SQLyog › Using SQLyog › Where Sp's Saved On The Hd

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • May 2, 2006 at 1:15 pm #21517
      TomBez
      Member

      Hi,

      have a look into your database 'mysql' into table 'proc'

      select * from proc where type='PROCEDURE'

      will filter you all stored procedure on that mysql-server

      regards

    • May 2, 2006 at 7:00 pm #21518
      peterlaursen
      Participant

      @rick

      When using a database server like MySQL you should not bother! Depending on the Storage Engine used there may be one or more files for each database (MyISAM) or just one file (InnoD:cool:. The storage is controlled by the server code, and you should not attempt to access any database object from the file system at all.

      The SPSs are stored 'somewhere inside the database file(s)', there is no other way to access them than using a MySQL client.

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.