There is an import feature in PHPMyAdmin which will import .sql files (which contain sql syntax). Currently text files or csv files or not supported. To import data (from an .sql file) into your MySQL database follow these steps:
Option #1: Using phpMyAdmin
1. Login to the Netfirms Control Panel at https://controlpanel.netfirms.com.
2. Click Site Tools
3. Click Database
4. For the database you wish to adminster, click Admin
5. Click the phpMyadmin button
6. Click the Database name located on the left hand side.
7. Click SQL
7. Click the Browse button and select the .sql file (located in your local machine) that contains the information you wish to import.
8. Click the Open button.
9. Click the Go button.
NOTE: Importing .csv or .txt files:
Since phpMyAdmin is limited to importing only .sql files, you may want
to use a third party script such as the one available here: http://codewalkers.com/codefiles/585 (script is called csv2sql.zip) to convert your .csv to .sql file format.
Option #2: Using SSH (check your hosting plan to see if SSH is supported)
If the .sql file that you are attempting to import is too large, the import via phpMyAdmin may timeout in your browser. An alternative way to import your .sql file is to run the import command via a SSH session. If you currently subscribe to a plan that supports SSH (check the Site Tools section of your Netfirms Control Panel to see if SSH can be enabled), then follow the steps outlined here.
Option #3: Using A Third Party MySQL Client Administration Tool
A freely available mySQL database application is: HeidiSQL available at: http://www.heidisql.com/download.php
You will also need your database credentials which can be found within your
Database Manager in order to connect to the server.
Glossary
Contact Us
- GETTING STARTED -
DATABASE MANAGEMENT
Email
Print
Add Comment
