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 2 reply threads
  • Author
    Posts
    • #9663
      rickbuiten
      Member

      I have a question about SQLyog.

      A few weeks ago, my laptop is crashed but not mine hard disk. Does anybody know where I could find the stored procedures on mine hard disk? The tables are saved in the mysql server 5.0/data/<> directory, but not mine stored procedures :wacko:

      Thank you very much for helping me.

      Bye, Rick

    • #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

    • #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.

Viewing 2 reply threads
  • You must be logged in to reply to this topic.