sql表转为mysql,如何将.sql文件转换为mysql db中的表

I have .sql files that I'm guessing is auto-generated. I did not generate this file, but anyway it includes the database name and all tables with fields. I'd like to add the db and tables to my mysql localhost and would like to know how to do this. I have tried uploading the file but keep getting errors about my sql syntax. The syntax looks all correct to me so perhaps the .sql file needs to be changed?

解决方案

From command-line:

mysql -u root -p databaseName < file.sql

Where databaseName is an already created empty database and file.sql is the .sql file you have, you must be in the same folder as the file when you run the command. This also assumes using root as the user and that it is password protected. Modify as needed for your own setup.

Additionally, you can do the reverse by flipping the angled bracket to create a database dump to a file. Like below.

mysql -u root -p databaseName > file.sql