Import single schema from a full database dump
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
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.