Import mysql database command line, Import MySQL dumpfile, SQL datafile into my database
You can easily restore or import MySQL data with mysql command itself.
For example:
Type the following command at the shell prompt to import sql data file:
$ mysql -u username -p -h localhost data-base-name < data.sql
If you have dedicated database server, replace localhost name with actual server name or IP address:
$ mysql -u username -p -h 210.42.1.12 databasename < data.sql
please go through:
Ads