For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Hello
I am trying to upgrade from MYSQL 5.2 to 5.7
Can anyone guide me on Backup and Restore for MySQL.
Appreciate your help
thanks
kp
SQL> truncate table q; SQL> insert into q select * from dba_objects ; Statistics --------------------------------------------------- 62 recursive calls 9017 db block gets 2716 consistent gets 3 physical reads 7636776 redo size 64851 rows processed SQL> delete from q; Statistics --------------------------------------------------- 22 recursive calls 72934 db block gets 1072 consistent gets 0 physical reads 25324064 redo size 64851 rows processed
'Delete' just moves this data into undo