To import the database's dump file written by mysqldump,use mysql command. Learn to export database using mysqldump.

If the dump file was created using mysqldump command with –all-databases or –databases option, it contains CREATE DATABASE and USE statement.

# mysql < dump.sql

If the dump file is created as a single-database and not containing –all-databases or –databases, create the database first(if neccessary):

# mysqladmin create sqldb

Now, import the database in newly create database:

# mysql sqldb < dump.sql

Import database with username and password:

# mysql -u [USERNAME] -p < dump.sql // dump file created using –all-databases or –databases.
# mysql -u [USERNAME] -p sqldb < dump.sql // dump file not created using –all-databases or –databases.

Was this answer helpful? 0 Users Found This Useful (0 Votes)

Powered by WHMCompleteSolution