MySQL Forums
Forum List  »  MySQL Shell

Re: sqldump with database schema
Posted by: Peter Brawley
Date: November 16, 2020 12:18PM

Your script says --no-data so it does not export data.

Mysqldump docs often fails to write a create database statement. You'll have to edit the script and add it in.

Mysqldump isn't the right tool for exporting privileges---they're row-level in mysql tables. You'll need to write specific scripts for that.

Options: ReplyQuote

Written By
November 16, 2020 10:03AM
Re: sqldump with database schema
November 16, 2020 12:18PM
November 16, 2020 02:46PM

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.