Hi have to dump my mysql database with sights and sp's. However I have no need for data. How do i write mysqldump command for your?


  -R, --routines      Dump stored routines (functions and procedures).


--no-data, -d

       Do not write any table row information (that is, do not dump table contents). This is useful if you want to dump only the CREATE TABLE statement for
       the table (for example, to create an empty copy of the table by loading the dump file).

Source: man mysqldump and mysqldump --help