User Tools

Site Tools


dba:cli_commands

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
dba:cli_commands [2025/12/02 20:10] mlivolsidba:cli_commands [2025/12/02 20:17] (current) – [Dumping and Restoring] mlivolsi
Line 18: Line 18:
  
  
-Privs+==== Privs ====
 ^ Command ^ Oracle ^ MySQL  ^ Postgres ^ ^ Command ^ Oracle ^ MySQL  ^ Postgres ^
 | create user | create user <username> identified by <password>; | Same as Oracle | Create user <username> password <password>; | | create user | create user <username> identified by <password>; | Same as Oracle | Create user <username> password <password>; |
 +
 +
 +==== Dumping and Restoring ==== 
 +^ Command ^ Oracle ^ MySQL  ^ Postgres ^
 +|dumping | expdp | mysqldump | pg_dump |
 +|Restore | impdp | mysql > source <file_name> | psql > \i <file_name>
dba/cli_commands.1764706207.txt.gz · Last modified: by mlivolsi