Importing Dump (.dmp) file into mysql
Can I import .dmp file created from oracle (8i) into MySql database? I
tried importing the dump file directly using mysql workbench, but showing
some error which I am mentioning below.
Creating schema newschema
10:49:15 Restoring G:\dmp\pass.dmp
Running: mysql.exe
--defaults-extra-file="c:\users\acer\appdata\local\temp\tmpliqb6y.cnf"
--host=localhost --user=root --port=3306 --default-character-set=utf8
--comments --database=newschema < "G:\dmp\xyz.dmp"
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check
the manual that corresponds to your MySQL server version for the right
syntax to use near '/h2 pPlease help me how to solve this./p pThanks!!
:)/p
No comments:
Post a Comment