I have a * .sql file. How do I transfer / use a database?
Have the records in the database. (it was sent to me and I do not know how to have the data inside my database, and then use it with php)
I have a * .sql file. How do I transfer / use a database?
Have the records in the database. (it was sent to me and I do not know how to have the data inside my database, and then use it with php)
The * .sql file does not represent the database, it does not contain the records, nor is it a copy of it.
This is a script file, it can contain database creation, queries, table creation, inserts, and other SQL operations.
You can open it using a text editor, but most of them (at least natively) will not be able to run this script.
As you have put the tag mysql-workbench in the question, you can open MySQL Workbench, connect to a MySQL instance, and open the file using CTRL + O in Windows or ⌘O in macOS. p>
If you have no instance of MySQL installed, follow link .