To import MySQL dump file into a database you must have a MySQL command line shell.
Step #1: Make sure your database is already created. If database is not created yet, then you have to create one database. For example:
->mysql -h localhost -u root -p; (enter your password) ->CREATE SCHEMA IF NOT EXISTS 'database_name'; ->exit;
Note
You can replace "localhost" by an IP address (e.g. 192.168.1.88).
Step #2: Type the next command to import MySQL dump file into a database.
->mysql -h localhost -u root -p database_name < file.sql (enter your password)
Voilá! Now you have a database with all data filled.
No comments:
Post a Comment