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