I have the following problem and doubt in Oracle … I am trying to import with impdp a save from my database made in which I export several schemes … the problem comes when I try to import into the same database in another scheme completely empty one and only one of those schemes that are in the export (expdp) …. during the import show several errors of creation, of sequences, of data that already exist and of creation of other objects in general. How is this possible if the scheme where I import this empty? the expdp I execute it in the following way:
expdp \ "/ as sysdba \" DIRECTORY=logic_bakups DUMPFILE=backup%U.dmp FLASHBACK_TIME=timestamp PARALLEL=5 SCHEMAS=SCH1,SCH2,SCH3,SCH4
impdp \ "/ as sysdba \" DIRECTORY=imp_logic_backups DUMPFILE=backup%U.dmp PARALLEL=5 REMAP_SCHEMA=SCH3:SCH3_V2 REMAP_TABLESPACE=source_tablespace:target_tablespace_V2
First, I have a problem in accessing mySQL 8.0.13 using Workbench suddenly where the usual password is not accepted.
I then tried different ways to revive the connection; including using the following ways:
C:\Program Files (x86)\MySQL\mysql-8.0.13-winx64\bin>mysqld –initialize-insecure –console 2019-01-06T13:48:30.472661Z 0 [System] [MY-013169] [Server] C:\Program Files (x86)\MySQL\mysql-8.0.13-winx64\bin\mysqld.exe (mysqld 8.0.13) initializing of server in progress as process 7148 2019-01-06T13:48:30.526721Z 0 [ERROR] [MY-010457] [Server] –initialize specified but the data directory has files in it. Aborting. 2019-01-06T13:48:30.549741Z 0 [ERROR] [MY-013236] [Server] Newly created data directory C:\Program Files (x86)\MySQL\mysql-8.0.13-winx64\data\ is unusable. You can safely remove it. 2019-01-06T13:48:30.566754Z 0 [ERROR] [MY-010119] [Server] Aborting 2019-01-06T13:48:30.575948Z 0 [System] [MY-010910] [Server] C:\Program Files (x86)\MySQL\mysql-8.0.13-winx64\bin\mysqld.exe: Shutdown complete (mysqld 8.0.13) MySQL Community Server – GPL.
Now, even though I have no problem in connecting, the schema just will not show up.
What should I do ?
Another strange thing is that I have used the following :
mysqld FLUSH PRIVILEGES; mysql FLUSH TABLES;
when an error show up :
ERROR 1045 (28000): Access denied for user ‘ODBC’@’localhost’ (using password: NO)
which really stumped me cos I never created user ODBC. All along I am using root @ localhost
Another strange thing is when I log in using WorkBench, it shows me mysql@localhost and not root@localhost
Please help me out how to make MYSQL server work properly again.
OS : Windows 10