Questions tagged [import.sql]

4 questions
1
vote
3 answers

Spring Boot import.sql encoding issue

I am using Spring Boot 1.5.2.RELEASE, and when trying to use the import.sql file to add demo data with Arabic letters as follows: INSERT INTO city (active, name_arabic,name_english) VALUES (b'1', 'الرياض','Riyadh'); The value is inserted in the…
Mahmoud Saleh
  • 33,303
  • 119
  • 337
  • 498
0
votes
0 answers

How to continue a .sql database import in MySQL after the server has gone away

This is how the error happened - I was using MySQL shell to import a 16G .sql file that contains multiple tables using the source command and optimizations (as the first solution in this question, with maximum values indicated in MySQL…
lyra
  • 1
  • 1
0
votes
1 answer

generate sequilize models from sql file

I am building a nodejs API with PostgreSQL & Sequilize. My client gave me a .sql file which has been exported from dbdiagram.io. Is it possible to generate all my models base on .sql file ? or do I have to do it all manually ?
Nicks
  • 724
  • 3
  • 14
  • 31
0
votes
0 answers

How to import the full ITIS database (.sql) to PGADMIN 4

So I need to import the ITIS database into pdadmin4 1.5 (postgresql) The read.me file gives me these information: 1. Open a terminal or command prompt and navigate to the folder where you unzipped the ITIS download file. 2. Enter the…
Kostas Daglis
  • 39
  • 1
  • 1
  • 5