How to read a .sql file?

[Enrico Maria Giordano]

Anybody knows how to extract data from a .sql file?

Thank you in advance for any information about the subject.

EMG

[hmpaquito]

Hi,

Open HeidiSql app. Connect to server and

[Enrico Maria Giordano]

Hi,

Open HeidiSql app. Connect to server and

Which server? I have no server, only a .sql file. Could it still be open?

EMG

[Enrico Maria Giordano]

I just tried HeidiSql and it starts asking of a SQL server, that I don't have.

EMG

[hmpaquito]

Enrico,

Download and install xampp packet from https://www.apachefriends.org/download.html

After start his Mysql server.

Regards

[Enrico Maria Giordano]

Thank you, but I'm searching for a way to extract data from the .sql file programmatically. I can't install anything on the customer's PC.

EMG

[Rick Lipkin]

Enrico

I believe .sql files are just text .. try to open your file with notepad ..

Rick Lipkin

[Enrico Maria Giordano]

Enrico

I believe .sql files are just text .. try to open your file with notepad ..

Mine is not text, it's a binary file. I have to ask my customer if that file is encoded or corrupted…

EMG

[cnavarro]

Enrico, is a file of Microsoft SQL Management Studio ?

[Enrico Maria Giordano]

My customer said that it's a MySQL file, but I'm not sure at all...

EMG

[Antonio Linares]

Enrico,

phpMyAdmin lets you import a SQL file and process it

The file can be inside a ZIP (gzip, bzip2, zip) file

In example, all these forums (MySQL, over ten years) are exported into a single SQL file

[Enrico Maria Giordano]

Already tried with phpMyAdmin: no luck.

EMG

[Antonio Linares]

Enrico,

HeidySQL is also processing it nicely, have you tried it ?

[Enrico Maria Giordano]

Yes, please read the first messages of this thread.

EMG

[ShumingWang]

Some table fields might be binnary data type, restore data to mysql server
mysql.exe -h xxxip -u root -p -C databasename < xxx.sql

Then with anytools like mysql.exe -h xxxip -u root -p can login and browse.