Skip to Main Content

MySQL Database

Announcement

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!

Dumps export issue

3825553Nov 2 2018 — edited Nov 3 2018

Dear all this is my first post in oracle community (Apology in advance for any mistake)

i have dumps of around 250 GB which i export from Live production server (assume 1.1.1.1)  after that i copied (scp) to its relevant server (assume 1.1.1.2) which is used for only reporting and after  scp on server B i restored these dumps on that server for update .The whole 250 GB export took around 70-80 mints ( minimum) .

default path for dumps export is u /back (which space is around 1TB) but some time i forgot to move old dumps so i faced "export failed due to space issue". then what i do

1: kill the current process

2: make some space on relevant directory

3: Then restart same from process from step one.

So my questions are:

1: can i export dumps in chunks (  83 GB + 83 GB + 83 GB) if yes then its possible to to restore my server B (1.1.1.2) where i do scp and then restoring ? if yes how?

2: if in current senior , where i have 250 GB and its exporting failed around 200GB due to space issue on that directory , can i resume that from where it stop (if incase i killed that export ), if yes how

3: how to speed up this dumps export and after scp (restoration on server B ) because restoration takes around 2 hrs + .

This post has been answered by Dave Stokes-MySQL Community Team-Oracle on Nov 3 2018
Jump to Answer

Comments

Post Details

Added on Nov 2 2018
1 comment
135 views