How to change database name in sql without deleting the database

Answer 1

in t-sql

ALTER DATABASE dbname MODIFY NAME = newdbname

Answer 2

I'm afraid that is not possible.

You can use "mysqldump" to dump the data and then create a schema with your new name and then dump the data into that new database.

See: https://dev.mysql.com/doc/refman/5.7/en/mysqldump-sql-format.html