Export and Import Oracle Schemas and Tables with Data Pump
Use expdb and impdb to export and import Oracle database tables, schemas etc. to/from a set of files in binary format.
00110022 Tutorials
Tutorials for Web Developers and more. Easy and fun!
00110022 Tutorials
Tutorials for Web Developers and more. Easy and fun!
Category Database
Short tutorials for installing and using MySQL / MariaDB, Oracle Database, SQL Server, and others
How to install Oracle Database 19c on Rocky Linux 8
This tutorial provides all the steps required to install Oracle Database 19c on Rocky Linux 8 (or Oracle Linux 8) including scripts to start the server automatically, create tnsnames.ora and listener.ora, create a user and connect to the server from SQL Developer.
Connect Remotely to MySQL / MariaDB
Learn how to configure MySQL / MariaDB database server to accept remote connections, how to configure the firewall to allow these connections and how to create a MySQL user that can connect remotely.
Backup & Restore MySQL / MariaDB Databases with mysqldump
mysqldump generates logical backups of MySQL/MariaDB databases. A logical backup is a set of SQL statements that can be used to restore the data, such as CREATE DATABASE, CREATE TABLE and INSERT.
Manage Databases and Users in MySQL
You create users and databases with the CREATE command and delete them with the DROP command. Delete databases and users: Create databases and users: Change the user’s password: Add permisions to the user for the database: Keep in mind that…
Install MySQL 8 on Ubuntu 20.04
This is really easy. 1. Update UbuntuAn update is always a good thing 2. Install MySQL 3. Secure it (remove some test users, etc.) 4. And test it That’s it.