I havent used Navicat for a while so I really can't help you with any specific commands on how to import it. Usually in DB editors such as SqlYog and Navicat it allows you to 'Restore from dump' into one of your databases. Usually you would right click one of your databases and select "restore from SQL dump' to import the stuff. This method allows you to import data quickly and efficiently.
There is another method however, you can always copy all of the data from the sql file (its just a text file) and paste it into your query box in SQLyog or Navicat. Then 'Execute all querys' that will run the commands.
One important thing to remember is compatibility between your database and MaNGOS. Arcane fire uses MaNGOS revision 6399 and UDB rev. 358. A lot of times user content created in previous revisions of mangos will work in the newer ones, as long as the specific tables you are importing into remained the same and was not altered by the mangos revisions. It may be difficult to read the code and understand exactly what it will do. If you are planning on experimenting with your server I HIGHLY recommend creating a replica of it and use it for 'Testing Purposes' before applying it to your running one. Create multiple realms and see if it will work flawlessly, or destroy your content.
Posted 1 year ago » Permalink