What are the common Import / Export problems

ORA – 00001: Unique constraint (...) violated
You are importing duplicate rows.
Use IGNORE=NO to skip tables that already exist
(Imp will give an error if the object is re – created)

ORA – 01555: Snapshot too old 

Ask your users to STOP working while you are exporting or use parameter CONSISTENT=NO

ORA – 01562: Failed to extend rollback segment
Create bigger rollback segments or set parameter 
COMMIT = Y while importing

IMP – 00015: Statement failed ... object already exists...
Use IGNORE = Y import parameter to ignore these errors, but be careful as you might end up with duplicate rows

How to fix: ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)

Open your terminal and type mysql -u root -p Enter your password. Hopefully your MySQL is logged in now.