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 ?
Login         

View Questions and Answers by Category

Advertisements


 
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 and 3 months 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:
 

 

 

DMCA.com