SQL file to DB file

Brad

Active Member

Licensed User

Longtime User

• Apr 4, 2013

• #2

MySQL doesn't care what you use for the file extension.

 

Upvote 0

Erel

B4X founder

Staff member

Licensed User

Longtime User

• Apr 5, 2013

• #3

I think that you are confusing between SQLite database file and other formats. What is the content of the .SQL file?

 

Upvote 0

B

bishmedia

Member

Licensed User

Longtime User

• Apr 5, 2013

• #4

Hi

Below is a link to view the .sql file, its the whole of the british postcodes.

I wish to add it to my app but all the examples ive found open a .DB file.

Cant seem to find anywhere to convert it??

http://www.rushdenwindmillband.com/pc.sql

Many THanks in advance

 

Upvote 0

Erel

B4X founder

Staff member

Licensed User

Longtime User

• Apr 6, 2013

• #5

Seems like MySQL commands. You will not be able to load it automatically with SQLite.

1. You need to load it to a MySQL database.
2. Export the table as a CSV file.
3. Load the CSV data with StringUtils.
4. Add the data to a SQLite database.

 

Upvote 0