How to Import mysql database command line, Import MySQL dumpfile, SQL datafile into my database ?

How to Import mysql database command line, Import MySQL dumpfile, SQL datafile into my database ?

Import mysql database command line, Import MySQL dumpfile, SQL datafile into my database

View Answers

August 2, 2012 at 11:15 AM

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:









Related Tutorials/Questions & Answers:

Ads