#dbbackup

[thecampcodes]

Tutorial: How to Backup MySQL Database using PHP About How to Backup MySQL Database using PHP To beautify the presentation of this tutorial, I've used Bootstrap which is included in the downloadable of this tutorial, but if you want, you can download Bootstrap using this link. Creating a Backup Function Next, we create the function that backup and download our MySQL database. Please create ... https://bit.ly/3vB7Bcn

[sandeep2363]

Expdp backup for a single table in Oracle

EXPDP or IMPDP backup for tables in Oracle Create a directory in Oracle: Create directory DBBACKUPDIR as 'C:\dbbackup'; GRANT READ, WRITE ON DIRECTORY DBBACKUPDIR TO SCOTT; Expdp backup for the table in Oracle: --For one table expdp system@xepdb1 tables=HR.EMPLOYEES directory=DBBACKUP dumpfile=HR.dmp logfile=EXPDPHR.log -- For two tables expdp system@xepdb1 tables=HR.EMPLOYEES,HR.JOBS…

[outrightsystems-blog]

Importance of #Databackup and recovery process!

So you are into a business!, which runs on Crucial Data, data manipulated the whole day. It does not matter how big you are, data is important.

#SuiteCRMBackup

#DBBackup

#MySqlBackup

[butteryimpossiblemiracle-blog]

Error: Could not authenticate to Oracle Database Cloud Backup Module (#OracleCloud #CloudLift&Shift)

Issue:

While performing the Oracle Database RMAN backup to Oracle Cloud, the connection from OnPrem DB to Oracle Cloud account was not established, when used the below command,

[oracle@OGGBLR OPC]$ java -jar opc_install.jar -serviceName storage-xxxxxx.console.oraclecloud.com  -identityDomain -opcId ‘’ -opcPass ‘’ -libDir /u01/softs/OPC/lib -walletDir /u01/softs/OPC/wallet -container DBBackup

[sandeep2363]

Generate DDL script of Schema with EXPDP/IMPDP in Oracle

Generate DDL script of Schema with EXPDP/IMPDP in Oracle

Get DDL of all objects in one script of Schema in Oracle EXPDP the schema with METADATA_ONLY option C:\Users\ORACLE>expdp directory=dbbackup dumpfile=hr_metadata.dmp content=metadata_only Export: Release 18.0.0.0.0 - Production on Wed Feb 2 22:15:37 2022 Version 18.4.0.0.0 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. Username: hr@pdb1 Password: Connected to:…

[sandeep2363]

Analyze time of expdp datapump by METRICS=Y and LOGTIME=ALL parameters

Analyze time of expdp datapump by METRICS=Y and LOGTIME=ALL parameters

Check which part taking time in EXPDP by Metrics=y and logtime=y parameters Metrics will give the number of times(seconds) spent on each part separate timing in the log file of expdp datapump. By adding a statement like “Completed 10 TABLE_STATISTICS objects in 0 seconds” C:\WINDOWS\system32>expdp hr@pdb1 directory=dbbackup dumpfile=hr.dmp logfile=hr.log metrics=y reuse_dumpfiles=y Export:…

[sandeep2363]

Overwrite existing dumpfile during EXPDP backup

Overwrite existing dumpfile during EXPDP backup

Overwrite dumpfile with reuse_dumpfiles parameter in EXPDP C:\WINDOWS\system32>expdp hr@pdb1 directory=dbbackup dumpfile=hr.dmp logfile=hr.log Export: Release 18.0.0.0.0 - Production on Sun Jan 23 10:39:17 2022 Version 18.4.0.0.0 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. Password: Connected to: Oracle Database 18c Express Edition Release 18.0.0.0.0 -…

[sandeep2363]

Show command output in text box of tkinter in Python

Show command output in text box of tkinter in Python

Example of output shown in text box of tkinter GUI in python language from tkinter import * import subprocess import os from tkinter import * from subprocess import Popen, PIPE root = Tk() text = Text(root) v_complete="EXPDP hjr/hr@pdb1 Directory=dbbackup REUSE_DUMPFILES=Y schemas=hr dumpfile=dbbackuphr.dmp logfile=hr.log" #p1 = subprocess.run(v_complete ,stdout=subprocess.PIPE, text =…

[sandeep2363]

EXPDP metadata(DDLs) and data with content option

EXPDP metadata(DDLs) and data with content option

Export the metadata and data only with CONTENT option in EXPDP datapump For EXPDP Metadata only: It will export the metadata of the schema excluding the data. expdp HR@ORCL directory=DBBACKUP dumpfile=HR.dmp logfile=HR.log content=METADATA_ONLY For EXPDP data only: It will export the data only, it will not create the schema with metadata, it only used for import data which already has similar…

[sandeep2363]

SQLfile option with IMPDP for extracting DDLs from dumpfile

SQLfile option with IMPDP for extracting DDLs from dumpfile

SQLfile option with IMPDP for extracting DDLs from dumpfile SQLFILE option is used with impdp only. This will generate the DDLs command file from the dumpfile. Suppose We have a dump file of table HR schema. If you need the DDL of the table “EMPLOYEES”, then use sqlfile option with IMPDP. Use IMPDP with SQLFILE option: IMPDP directory=dbbackup dumpfile=hr.dmp logfile=hrtrace.log…

[sandeep2363]

ORA-27038: created file already exists in EXPDP datapump

ORA-27038: created file already exists in EXPDP datapump

Error ORA-31641: unable to create dump file “C:\employee.dmp” ORA-27038: created file already exists C:\windows\system32>expdp directory=dbbackup dumpfile=employee.dmp logfile=employee.log Export: Release 18.0.0.0.0 - Production on Mon Apr 13 09:33:27 2020 Version 18.4.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights…