So, a couple of things:
1.) Navicat fails to import sql files if there is no database for the sql file. Right clicking and executing the SQL file is met with an almost instant query termination with the following error "Failed to Execute SQL. No Database." So you need to create the database now.
2.) When executing these SQL files, mangos and character will have well over 500+ errors. Even though it says it's unsuccessful, you need to close your connection to the database object then reconnect to the database object and you will see the tables populate. At this time I am unable to determine if this is an issue or not because I am unable to complete the process due to the third issue...
3.) The guide calls for a batch file to run that, well, doesn't exist. Under the "Populating Databases" section, your instructions state to "Run install_Windows.bat" However no directory is mentioned. After searching my C:\ drive for *.bat and sorting by name, I have confirmed that the batch file you're referencing does not exist. Was this step part of the CMangos installation?
Usually these guides are pretty comprehensive however they MUST be followed step by step. When you start referencing files that don't exist or leave out steps, you're going to cause the process to come to a screeching halt. Where is that install_Windows.bat file supposed to be located? What is it for?
I am going to just continue the process. I have bigger fish to fry (like finding a working client) and if I have to blow the entire server away, whatever.
So I am unable to populate the mangos database due to the tables that caused those 500+ errors being missing. Attempting to populate the database ends immediately.
Five tables populated. This cannot be normal. There seems to be an issue with these SQL files however I cannot tell you what it is. I only know how this process is supposed to look when everything works correctly. Executing SQL files are not supposed to throw that many errors.