Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



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

Have Programming Question? Ask it here!
 
 
 


laeeq khan
How to Import mysql database command line, Import MySQL dumpfile, SQL datafile into my database ?
1 Answer(s)      2 years ago
Posted in : SQL


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


Advertisement
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:
Advertisements
 

 

 

DMCA.com