laeeq khan
How to Import mysql database command line, Import MySQL dumpfile, SQL datafile into my database ?
1 Answer(s)      2 years and 9 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: