Re: MySQL Dump commands fails
You need to log mysqldump in as root to be able to see ALL databases.
Try
mysqldump -uroot -p --routines --no-create-info --no-data --no-create-db --skip-opt <database> > outputfile.sql
Input root's password when prompted.
They way you have it, you will login anonymous (which for security should be removed!) but won't have access to any databases.
Good luck,
Barry.
Subject
Written By
Posted
Re: MySQL Dump commands fails
April 19, 2015 04:50PM
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.