B
B
BonBon Slick2017-10-02 21:56:04
PostgreSQL
BonBon Slick, 2017-10-02 21:56:04

How to import data if PhPPgAdmin hangs and gives errors when importing into the database "The connection was reset."?

I have 20,000+ such requests in .txt file

INSERT INTO public.steam_apps (steam_appid, app_type, price, name, header_image, os, slider_image, cover_image, required_age, detailed_description, pc_requirements, mac_requirements, linux_requirements, developers, publishers, supported_languages, website, genres, categories, metacritic, recommendations, screenshots, achievements, release_date, background_url, created_at, updated_at, full_game) VALUES (46500, 'game', 1299, 'Syberia', 'http://cdn.akamai.steamstatic.com/steam/apps/46500/header.jpg?t=1478599954', '{"windows":true,"mac":true,"linux":false}', ....
'http://cdn.akamai.steamstatic.com/steam/apps/46500/page_bg_generated_v6b.jpg?t=1478599954', '2017-09-22 04:11:28', '2017-09-22 04:11:28', null);

When trying to import the file itself into a table, it first shows Uploading (1% -99%) in the lower left corner, and then PhPPgadmin breaks down without importing anything. Giving an error
The connection was reset.
When trying to execute all requests from a file, it says that the request is too long, or gives a black page, hangs.
So how do you import all records then?

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question