I am kinda new to the whole development side, but I want to be good.
In database creation, I used to do this via PHPMyAdmin --> Wamp Server.
I got to learn how to use MySQL Workbench, and I am liking the experience.
The problem is, when I have the .sql file created via use of Work Bench, e.g. data.sql, I cannot import it to PHPMyAdmin, so as to continue in a my developments (web-related) as there are many errors comming up e.g. #1146.
It is really frustrating since I have to do double work and create what I did in Work Bench in PHP MyAdmin.
Is there a simpler way?
Like can I just connect to a .sql file (as the database) and continue with execution of my projects? (Its a bit stupid, but I have been reduced to that.)
Please help.
Thanks in advance.