How to restore the locally exported. SQL database file to the database (in Linux)

After modifying the template website locally, the database files under phpmyadmin have also changed. When you transfer the website to another place, you need to export the current SQL file and restore it.

 

When restoring data in Linux, do not enter mysql first:

Execute: mysql <database. SQL; otherwise, the system will prompt that the database already exists.

Because the SQL file already exists:

 

The database creation code already exists. If you first enter mysql, create database joomla will prompt that the database already exists.