Wonderful guide, thanks. I was cruising right along until I got to this part:
Quote:
Originally Posted by kavren
• Open Navicat lite
• double click on local
• right click on local, new database
• name the new database PEQ
• Now open a command prompt and go to the folder that has the peqdb_RevXXXX.sql you just extracted
• run this command
o mysql -uUSERNAME -pPASSWORD PEQ < peqdb_RevXXXX.sql
o mysql -uUSERNAME -pPASSWORD PEQ < load_player.sql
|
When I opened Navicat Lite there's nothing that says "local" to double click on. The Navicat I am using is: "Version 9.0.15 - lite (non-commercial)"
Please advise.
Other Thoughts:
There is a place to make a new connection, and I can choose MySQL (among others) with the following items (some of them pre-populated):
Connection Name:
Host Name/IP Address: localhost
Port: 3306
User Name: root
Password:
I could probably name the connection PEQ and use the password I put in when setting up MySQL. But I am unsure if that's is what
kavren's instructions are trying to accomplish here. I also wonder if it is related to what is supposed to be typed in on the command prompt. Since I don't have a "local" to double-click on to see what happens I cannot speculate as to whether it is supposed to correlate with the command prompt entries.
If anyone can shed any light on this Navicat issue I would greatly appreciate it.