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


Subject
Views
Written By
Posted
197
November 16, 2020 10:03AM
Re: sqldump with database schema
86
November 16, 2020 12:18PM
85
November 16, 2020 02:46PM


Sorry, only registered users may post in this forum.

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.