Postgres Emport And Export Database

 Remeber logs:-

Play with Postgres Console

Login to Postgress Console:-

$ 1. psql -U pg_user_name

2. psql -h localhost(host) -U pg_user_name

See Database:-

$ \l

Create New Database:-

$ create database Databasename;

To switch databases:

$\connect databasename;

To list all table

$ \d

To Insert records:

INSERT INTO TABLE_NAME (column1, column2, column3,...columnN)
VALUES (value1, value2, value3,...valueN);

$insert into articles(title) values(33);

T0 list record:

$ SELECT * FROM articles;

Play with Mysql Console:

Install mysql:

sudo apt-get install mysql-server mysql-client libmysqlclient-dev

Login to Mysql Console:-

$ mysql -u root -p

See Database:-

$ show databases;

Create New Database:-

$ create database Databasename;

To switch databases:

$ use mydb; or connect dbnae;

To list all table

$ show tables;

To Insert records:

INSERT INTO TABLE_NAME (column1, column2, column3,...columnN)
VALUES (value1, value2, value3,...valueN);

$insert into articles(title) values(33);

T0 list record:

$ SELECT * FROM articles;

================================================================

Dump in Import Postgres:-

Import:

$ psql -U root Database_name < blog_development.sql

Export:

1. pg_dump -U root Database_name > test_runner_development_30_03_2018_2.sql

On server:

2. pg_dump -h localhost -U postgres bookstylist_ror_staging > book_a_stylist_25_nov.sql

================================================================

Dump in Export Mysql:-p -U USERNAME DBNAME >

dbmysqldump -u [username] -p [database name] > [database name].sqlxp

Dump

Export:

$ mysqldump -u root -p blog_development > blog_development.sql

Import:

$ mysql -u root -p blog_production < blog_development.sql

==================================================================

Heroku Pg backup:-

1. git remote add heroku heroku URL
2.  heroku pg:backups:capture

3. heroku pg:backups:download
4.  pg_restore --verbose --clean --no-acl --no-owner -h localhost -U Username -d Databasename latest.dump
==============================================

Video Download Link:

http://dev.exiv2.org/projects/exiv2/wiki/VideoSamples