To clear or reload various internal caches, flush tables, or acquire locks, control-click your connection in the Navigation pane and select Flush and choose the flush option. You must have the reload privilege to use this feature. To open a query using an external editor, control-click it and select Open with External Editor. You can set the file path of an external editor in Preferences. Import Wizard allows you to import data to tables/collections from CSV, TXT, XML, DBF and more. Navicat provides powerful tools for working with queries: Query Editor for editing the query text directly, and Query Builder, Find Builder or Aggregate Builder for building queries visually. If your Internet Service Provider (ISP) does not provide direct access to its server, Secure Tunneling Protocol (SSH) / HTTP is another solution. Sometimes you win, sometimes you learn. To clear or reload various internal caches, flush tables, or acquire locks, control-click your connection in the Navigation pane and s