Use the same database name "db_name" in all the examples;
"SHOW CREATE DATABASE db_name" should be run with \G, otherwise the output is not complete.