What exactly is dumping MySQL import procedures?

Asked By Jeo Tolbert 0 points N/A Posted on - 09/16/2012

What exactly is dumping MySQL import procedures? If I am dumping some procedures then how do I import data from them?

• Status: Open
• Question Views: 678
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MySQL Server

Answered By Julinee James 10 points N/A #156386

What exactly is dumping MySQL import procedures?

Hi,

Using MySQL you can dump the import procedures. This means that you do not need to repeat the same functions again and again.

Once you create a function or a set of functions you can just dump them and then use them as import files later on. If there is another program that needs the same functions or set of functions then you can just import the functions. This saves the time to type the code again repeatedly. 

You can also store the procedures and strings. Just type the following code to import the procedures:

mysqldump –routines –no-create-info –no-data –no-create-db –skip-opt <database> > outputfile.sql

Hope this information helps you.

 

About Julinee James

Questions
4

Answers
298

Best Answers
35

• Vote Up 0 Vote Down

• Posted on - 10/01/2012
• Question Category: MySQL Server