Importing the SQL files into MySQL could be added to the Wiki, but I think most people feel that is not an "emulator task", but something someone should know how to do anyway. I knew how to run SQL scripts, but I did not know the "source" command in the mysql> prompt until coming to the Emulator (I am an MSSQL guy). I found what I needed by Googling, and discovering many helpful MySQL hints on the MySQL site itself.
But, in short, run "mysql -u root -p", if you have a password on your root, otherwise no -p. Type "use peq" if peq is the name of your database (if you do not have a peq database, I suggest using Cavedudes 352 installer, which does a sh*t-ton of this work for you). Last thing, at the mysql> prompt, just type "source load_system.sql". Be sure put the load_system.sql in the current dir, or you'll need the full path "C:\Temp\load_system.sql" etc... do the same for load_empty_users.sql, and you are then ready to add your first user (which is in the Wiki and all over this forum).
|