SQL file to DB file

[bishmedia]

ive seen many sql scripts on here but they all call from a file ending .db

How can i convert my .SQL file to a .DB file ??

Ive tried exporting from PHPMYADMIN but the option to save as .DB file isnt there.

Anyone know how i can convert??

 

[Brad]

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

 

[Erel]

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

 

[bishmedia]

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

 

[Erel]

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.