Sorry for such a newbie question.
I would like to write a cron job where it will stop the DB (eg:Test) then dump the DB to a file in a specified location. But I do not know how to. Some checking criterias are that the DB has to be stopped before dumping and that the DB be started up again after the dump.
Also, what is the command line to import the dump to the DB again?
Thanks for your help!
I would like to write a cron job where it will stop the DB (eg:Test) then dump the DB to a file in a specified location. But I do not know how to. Some checking criterias are that the DB has to be stopped before dumping and that the DB be started up again after the dump.
Also, what is the command line to import the dump to the DB again?
Thanks for your help!