What exactly is dumping MySQL import procedures?

Asked By 0 points N/A Posted on -
qa-featured

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

SHARE
Answered By 10 points N/A #156386

What exactly is dumping MySQL import procedures?

qa-featured

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.

 

Related Questions