Skip navigation links

MySQL Forums :: Backup :: create dump without output console


Advanced Search

Re: create dump without output console
Posted by: Rick James ()
Date: February 03, 2012 04:18AM

Do not do any of these for restoring!

mysqldump -h 192.168.50.191 -u *** -p*** baseName < baseRestore.sql &>/dev/null
-->
mysqldump -h 192.168.50.191 -u *** -p*** baseName < baseRestore.sql >/dev/null

The former will put it in the background, but still spew STDOUT to the terminal. The latter will throw away all of STDOUT, while showing you anything written to STDERR
mysqldump -h 192.168.50.191 -u *** -p*** baseName < baseRestore.sql >/dev/null 2>&1
Will throw away both.

mysqldump -h 192.168.50.191 -u *** -p*** baseName < baseRestore.sql >x.x 2>x.x
will write both to the file x.x for later investigation.

BUT BUT BUT !!!
You do not want mysqldump to reload !!! You want mysql.

Options: ReplyQuote


Subject Views Written By Posted
create dump without output console 1518 ENNAJIHI Rachid 02/01/2012 07:29AM
Re: create dump without output console 684 Scott Nemes 02/01/2012 10:18AM
Re: create dump without output console 697 ENNAJIHI Rachid 02/01/2012 11:24AM
Re: create dump without output console 1299 Rick James 02/03/2012 04:18AM
Re: create dump without output console 746 Scott Nemes 02/03/2012 10:58AM
Re: create dump without output console 780 ENNAJIHI Rachid 02/07/2012 11:43PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.