MySQL Forums
Forum List  »  MySQL Administrator

Import single schema from a full database dump
Posted by: vamsikrishna gorantla
Date: July 12, 2010 11:17PM

Hi,

I have 3 databases mysql, test and employees.

I have taken full database dump.

c:\mysql\bin> mysqldump -u root -p -A -B > c:/dump2.sql


Now i have dropped all the 3 databases.


I would like to import only employees database only from the dump file i have previously taken.

Please let me know how to import only one schema.

Also ,i am unable to use mysqlimport . Please let me know any configurations that needs to done in my.ini file.

Also let me know the syntax to use mysqlimport.

Thanks in Advance

Options: ReplyQuote


Subject
Written By
Posted
Import single schema from a full database dump
July 12, 2010 11:17PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.