`mysqldump` will backup by *default* all the **triggers** but **NOT** the **stored procedures/functions**. There are 2 mysqldump parameters that control this behavior:

* `--routines` – FALSE by default
* `--triggers` – TRUE by default
     

so in `mysqldump` command , add `--routines` like :

&lt;!-- language: lang-none --&gt;

    mysqldump &lt;other mysqldump options&gt; --routines &gt; outputfile.sql

See the [MySQL documentation about mysqldump arguments][1].


  [1]: https://dev.mysql.com/doc/refman/8.0/en/mysqldump.html#option_mysqldump_routines

May be it&#39;s obvious for expert users of MYSQL but I wasted some time while trying to figure out default value would not export functions. So I thought to mention here that **--routines** param needs to be set to true to make it work.

&lt;!-- language: lang-none --&gt;

    mysqldump --routines=true -u &lt;user&gt; my_database &gt; my_database.sql

I&#39;ve created the following script and it worked for me just fine.

&lt;!-- language: lang-sh --&gt;

    #! /bin/sh
    cd $(dirname $0)
    DB=$1
    DBUSER=$2
    DBPASSWD=$3
    FILE=$DB-$(date +%F).sql
    mysqldump --routines &quot;--user=${DBUSER}&quot;  --password=$DBPASSWD $DB &gt; $PWD/$FILE
    gzip $FILE
    echo Created $PWD/$FILE*

and you call the script using command line arguments.

    backupdb.sh my_db dev_user dev_password

We can use -R instead of using --routine flag.

    mysqldump -u mysqluser -R databasename &gt; /tmp/databasename.sql



I am running into the following error with my ASP.NET MVC 3 project:

&gt; Multiple types were found that match
&gt; the controller named &#39;Home&#39;. This can
&gt; happen if the route that services this
&gt; request (&#39;Home/{action}/{id}&#39;) does
&gt; not specify namespaces to search for a
&gt; controller that matches the request.
&gt; If this is the case, register this
&gt; route by calling an overload of the
&gt; &#39;MapRoute&#39; method that takes a
&gt; &#39;namespaces&#39; parameter.
&gt; 
&gt; The request for &#39;Home&#39; has found the
&gt; following matching controllers:
&gt; MyCompany.MyProject.WebMvc.Controllers.HomeController
&gt; MyCompany.MyProject.WebMvc.Areas.Company.Controllers.HomeController

I have a HomeController in my default controller folder, with a class name of MyCompany.MyProject.WebMvc.Controllers.HomeController.  

My RegisterRoutes method, in my global.asax, looks like:


        public static void RegisterRoutes(RouteCollection routes)
        {
            routes.IgnoreRoute(&quot;{resource}.axd/{*pathInfo}&quot;);

            routes.MapRoute(
                &quot;Default&quot;, // Route name
                &quot;{controller}/{action}/{id}&quot;, // URL with parameters
                new { controller = &quot;Home&quot;, action = &quot;Index&quot;, id = UrlParameter.Optional } // Parameter defaults
            );
        }

I then have an area called Company, with a HomeController in the default controller folder for the area, with a class name of MyCompany.MyProject.WebMvc.Areas.Company.Controllers.HomeController.

The RegisterArea method in the CompanyAreaRegistration file looks like:

       public override void RegisterArea(AreaRegistrationContext context)
        {
            context.MapRoute(
                &quot;Company_default&quot;,
                &quot;Company/{controller}/{action}/{id}&quot;,
                new { area = &quot;Company&quot;, action = &quot;Index&quot;, id = UrlParameter.Optional }
            );
        }

This is all leading the error I highlighted at the beginning of this post. I am struggling trying to piece together a solution from various other posts, with **NO LUCK**. 

Is it possible to have a HomeController in the default controllers folder and then one in EACH area? If so, do I need to make (assuming I do) changes to my configuration file to make this work? 

Any help would be much appreciated!



Having issue with multiple controllers of the same name in my project

I have been having trouble while attempting to use the nextLine() method from java.util.Scanner. 

Here is what I tried:

    import java.util.Scanner;

    class TestRevised {
        public void menu() {
            Scanner scanner = new Scanner(System.in);
            
            System.out.print(&quot;Enter a sentence:\t&quot;);
            String sentence = scanner.nextLine();
            
            System.out.print(&quot;Enter an index:\t&quot;);
            int index = scanner.nextInt();
            
            System.out.println(&quot;\nYour sentence:\t&quot; + sentence);
            System.out.println(&quot;Your index:\t&quot; + index);
        }
    }

**Example #1:** This example works as intended. The line `String sentence = scanner.nextLine();` waits for input to be entered before continuing on to `System.out.print(&quot;Enter an index:\t&quot;);`.

This produces the output:

    Enter a sentence:	Hello.
    Enter an index:	0
    
    Your sentence:	Hello.
    Your index:	0



----------








    // Example #2
    import java.util.Scanner;
    
    class Test {
        public void menu() {
            Scanner scanner = new Scanner(System.in);
            
            while (true) {
                System.out.println(&quot;\nMenu Options\n&quot;);
                System.out.println(&quot;(1) - do this&quot;);
                System.out.println(&quot;(2) - quit&quot;);
           
                System.out.print(&quot;Please enter your selection:\t&quot;);
                int selection = scanner.nextInt();
            
                if (selection == 1) {
                    System.out.print(&quot;Enter a sentence:\t&quot;);
                    String sentence = scanner.nextLine();
                    
                    System.out.print(&quot;Enter an index:\t&quot;);
                    int index = scanner.nextInt();
                    
                    System.out.println(&quot;\nYour sentence:\t&quot; + sentence);
                    System.out.println(&quot;Your index:\t&quot; + index);
                }
                else if (selection == 2) {
                    break;
                }
            }
        }
    }

**Example #2:** This example does not work as intended. This example uses a while loop and and if - else structure to allow the user to choose what to do. Once the program gets to `String sentence = scanner.nextLine();`, it does not wait for input but instead executes the line `System.out.print(&quot;Enter an index:\t&quot;);`.

This produces the output:

    Menu Options
    
    (1) - do this
    (2) - quit
    
    Please enter your selection:	1
    Enter a sentence:	Enter an index:	

Which makes it impossible to enter a sentence.

----------



Why does example #2 not work as intended? The only difference between Ex. 1 and 2 is that Ex. 2 has a while loop and an if-else structure. I don&#39;t understand why this affects the behavior of scanner.nextInt(). 


Using scanner.nextLine()

How to create a MySQL database dump (`.sql` file) with all its triggers and procedures?

How to export MySQL database with triggers and procedures?

<p>How to create a MySQL database dump (<code>.sql</code> file) with all its triggers and procedures?</p>


If I run a query with a `between` clause, it seems to exclude the ending value.  
For example:

    select * from person where dob between &#39;2011-01-01&#39; and &#39;2011-01-31&#39;

This gets all results with `dob` from &#39;2011-01-01&#39; till &#39;2011-01-30&#39;; skipping records where `dob` is &#39;2011-01-31&#39;. Can anyone explain why this query behaves this way, and how I could modify it to include records where `dob` is &#39;2011-01-31&#39;? (without adding 1 to the ending date because its been selected by the users.)

MySQL &quot;between&quot; clause not inclusive?

I have a field named `timestamp`. This is the last time a member was logged in.
I am looking to include a where clause in a query for something like

    WHERE timestamp &gt; todays date - 6 weeks

How would I do this?
I am trying to only include users that have logged in in the last 6 weeks.

Thanks

How do I get Timestamp minus 6 weeks in MySQL?

I&#39;m learning SQL and what bothers me, is that I seem unable to find ALL constraints on a table. I created the table with

    create table t2
    (a integer not null primary key,
    b integer not null, constraint c1 check(b&gt;0),
    constraint fk1 foreign key(a) references t1(a));

and added a constraint with

    alter table t2
    add constraint c2 check (b&lt;20);

I then tried to see ALL (four) constraints with

    show table status
    from tenn #--&gt;the name of my database
    like &#39;t2&#39;;

and then

    show create table t2;

and then

    select *
    from information_schema.key_column_usage
    where table_name=&#39;t2&#39;;

and finally

    select *
    from information_schema.table_constraints
    where table_name=&#39;t2&#39;;

But none of these shows all four constraints. Could anyone tell me how to see all of them?

Thanks a lot!

MySQL: how can I see ALL constraints on a table?

I am looking for the syntax for dumping all data in my mysql database. I don&#39;t want any table information.

mysqldump data only

In MySQL, I have this stored procedure with a [`LOOP`][1]:

    DELIMITER $$  
    CREATE PROCEDURE ABC()
    
       BEGIN
          DECLARE a INT Default 0 ;
          simple_loop: LOOP
             SET a=a+1;
             select a;
             IF a=5 THEN
                LEAVE simple_loop;
             END IF;
       END LOOP simple_loop;
    END $$

It always prints `1`.  What is the correct syntax for a MySQL Loop?


  [1]: https://dev.mysql.com/doc/refman/5.7/en/loop.html

Content Type	Original Author	Original Content on Stackoverflow
Question	Yugal	View Question on Stackoverflow
Solution 1 - Mysql	Haim Evgi	View Answer on Stackoverflow
Solution 2 - Mysql	Usman	View Answer on Stackoverflow
Solution 3 - Mysql	Krishna Vedula	View Answer on Stackoverflow
Solution 4 - Mysql	VishnuVS	View Answer on Stackoverflow

How to export MySQL database with triggers and procedures?

Mysql Problem Overview

Mysql Solutions

Solution 1 - Mysql

Solution 2 - Mysql

Solution 3 - Mysql

Solution 4 - Mysql

Using scanner.nextLine()

Having issue with multiple controllers of the same name in my project

Attributions