FC2Video

6. Drag-n-drop import files to Navicat To start an Import Wizard in Navicat, you can just drag your import files over and then drop them into the target database. 7. Set variable - Server Monitor You can edit values for the variables in MySQL and Oracle servers directly in Navicat. To do so, select “Server Monitor” for your target server from the “Tools” menu. Under the “Variables” tab, click the button next to the value or press Ctrl+Enter to open it for editing. 8. Table shortcut Simply right-click the table and choose “Create Open Table Shortcut”. You can then open the table without starting Navicat. 9. Drag-n-drop query icon between Navicat and OS (right and left drop) If you right-drop a query from Navicat to a Windows location, you can choose to copy, move, or create query shortcuts. If you left-drop a query, Navicat will move the query to that location.

Windows (FileZilla) In this tutorial, we will employ FileZilla to upload the php script file and establish a connection to a MySQL server using HTTP tunnel in Navicat. First, startup FileZilla, then enter the FTP server information and connect to the server. The php script file is available in the Navicat installation folder. Right-click the ntunnel_mysql.php on the local system and choose Upload. Then, check to see whether or not the file was uploaded successfully.

Mailing labels, name labels, and other useful labels can be created easily with Navicat. In this tutorial, we will create mailing labels with data from a MySQL server. In Navicat, click “New Report” to begin a report. The first step is to add a data pipeline in the “Data” tab. Click “New” in “File” from the main menu and choose “Query Designer”. Under the “Tables and Fields” tab, select the desired tables and fields. Then, select the “Calcs” tab and enter the expression to concatenate the address. Double-click a field and select “Expression” under “Function”. Then, enter the concat function in the “Expression” text box. Also, you can change the “Field Alias” to some meaningful words. The next step is to design the layout. Go to the “Design” tab and choose “New” in “File” from the main menu. Choose a layout format for the labels and click OK. Then, you can drag and drop the fields into the layout, adjust their positions, and also the size of the label. Finally, click “Preview” to view the result and save the report.

Navicat supports HTTP connection while your internet service providers do not allow direct connections to their server, but allows the establishment of HTTP connections. In this tutorial, we will employ FileZilla to upload the php script file and establish a connection to a MySQL server using HTTP tunnel in Navicat. First, startup FileZilla, then enter the FTP server information and connect to the server. The php script file is available in the Navicat installation folder. Right-click the ntunnel_mysql.php on the local system and choose Upload. Then, check to see whether or not the file was uploaded successfully. After uploading the script file, the next step is setting up the HTTP Tunnel in Navicat. Click the ‘Connection’ icon to start a new connection. In the Connection General tab, enter the server connection information; such as host IP address, port, username and password. Select the HTTP tab and enable the ‘Use HTTP Tunnel’ option, then enter the URL of the tunneling script. If the script is hosted in a password protected server or you have to access internet over a proxy server, you can provide the required authentication details. Finally, click ‘Test Connection’ to check the connection and click ‘OK’ to save the connection settings.