sqldump with database schema

[Alain Roger]

Hi,

i would like to build a script that make a backup of my database and user under linux.

for that i know how to do a sqldump of the database, however it does not dump the database name itself... so it does not generate a create database xyz... it's only export tables and data from the database itself.

Moreover how to do an export in command line of the users attached to the specific database ?

to export database, i do a sqldump like (it's on local ubuntu desktop) :
mysqldump -h 127.0.0.1 -u root --no-data --column-statistics=0 wpgdpr > wpgdpr_schema.sql

however, it exports only tables and data... nothing about the schema name and the user attached to this database.

Thx