How To Load A Database That Was Saved As A Text Document File

Chuks — Tue, 28 Jun 2022 11:59:38 +0000

If you were told to work with a given Database and that given Database was saved as a 'text document file format', how would you load the Database for you to begin to work with it?

In this tutorial, I'll show you how to Load a given Database that was saved as a 'text document file format'. I loaded the Database into Postgres using Valentina Studio.

Let's proceed.
First of all, Introduction.

What is a TXT file?
A TXT file is a standard text document that contains plain text. It can be opened and edited in any text-editing or word-processing program.

PostgreSQL is a powerful, open source object-relational database system that uses and extends the SQL language combined with many features that safely store and scale the most complicated data workloads.

Valentina Studio is a database management tool that helps to create, administer, query, and explore Valentina DB, MySQL, MariaDB, PostgreSQL, and SQLite databases for free.

Here, the Database I was given was saved as a 'text document file format'. Below is a screenshot showing it.

Step 1: Create a PostgreSQL Database on your Valentina Studio.
Do that by (a) click 'Create Database'. (b) In the place for 'Name', write the name of the Database you want to create. Then click 'Create'. For example, in my own case, the name of the Database I created is 'parse-and-posey'. Below is a screenshot to guide you.

Step 2: Open and Copy the Database text file document.
(a) To Open the document file 'parch-and-posey.sql', go to where it is saved in your system and double click on it or you click on the file (it will highlight it), then right-click, you will see a list of options, then select 'Open'.
(b) To Copy all the text in our file, Press 'Ctrl A' to copy 'all' (It will highlight everything), then Press 'Ctrl C' to copy everything. This is the screenshot below:

You are going to 'Paste' everything you have 'Copied' next.

Step 3: Paste into the Database
(a) On your Valentina Studio, double click on the Database you created in Step 1 to open the Query SQL editor where you will "Paste" what you just "Copied". It should look like this:

(b) Now "Paste" what you just "Copied" into that Query SQL Editor by using the short-cut "Ctrl V". Below is my screenshot:

After the "Execution" is done running, you will see the "Query has been executed" like this screenshot:

With that, the "Tables" have been created in your Database Schemas. To see the tables in your Database, click on ">" near "Schemas". Then click on ">" near "public". Then click on ">" near "Tables". The list of all the Tables that are in your Database will show. For example, the "Tables" in my Database, there are five (5) tables. They are: (i) accounts (ii) orders (iii) region
(iv) sales_reps (v) web_events

Below is the screenshot:

With these steps you have now learnt "How To Load A Database That Was Saved As A text document file". It's just a simple case of Copying and Pasting.

How To Restore A PostgreSQL Database Using Command Line

Chuks — Sun, 19 Jun 2022 05:17:21 +0000

Introduction
PostgreSQL is a powerful, open source object-relational database system that uses and extends the SQL language combined with many features that safely store and scale the most complicated data workloads.

A database is an organized collection of structured information, or data, typically stored electronically in a computer system. A database is usually controlled by a database management system (DBMS).

Here, in this article, you will learn how to restore a database backup file on postgresql. When working with a new database file, it is more convenient to use the command line to restore the database, especially if the file is large so as to reduce query execution time.

Let's proceed.

Locating the database file
Find the location of the ".sql" file on your computer and change the directory in command line to the folder containing the database. The folder holding my database like "france", "world" and "stote" is located in "databases" folder which is located in "mydatabases" folder which is located in "Downloads" folder. To change the directory you type "cd" followed by the file path then press Enter to switch to the new directory.
Running the postgresql application in command line
After switching to the directory containing the database file, the next step is to run the postgersql executable file "psql.exe" in command line so that the database will be inserted through postgresql. To do this:
(a) Copy the file path that contains the "psql.exe" file
(b) Paste it in the command line wrapped up in quotes, this is to let the command line know that it should be run together.

Create the respective databases in PostgreSQL
The next step is to create a database, this is the database that will house the backup file and this can be done using pgadmin.
Right click on PostgreSQL 14, you will see "create". Click on "create" and you will see "database", then click on it to create and name your database. Then click "save". Do this to create your
respective databases
Upload the backup database file into the created database
Lastly we want to upload the ".sql" file into the database that was created with pgadmin.
To do this, we use the same way we wrote the command line action in step 2 only that here you have to specify the user and the database. To specify the user we write "-U username" and to specify the database, we use "-d database name".
Here our user is "postgres" and let's say the database name is "Store" or "world" or "france", created in the previous step. Once the user and the database have been indicated, you type "<" followed by the file name for example "store.sql" or "world.sql" or "france.sql" then press Enter to upload the database. You will the be prompted to input your user password and after the password has been correctly inputted, the backup file will be uploaded into the database. So for example I will write "-U postgres" for the user and "-d World" for the database

DEV Community: Chuks

How To Load A Database That Was Saved As A Text Document File

How To Restore A PostgreSQL Database Using Command Line