Stream Read Error

HRR's profile image HRR posted 3 years ago in Import/Export Permalink

I have Maria DB and have a localhost Database Server.

I exported the Heidi SQL Script and have the Data backed.

I have a new Laptop and setup MariaDB and Heidi SQL installed and setup, but everytime I go to import the SQL file I keep getting Stream Read Error on all types UTF, ANSII etc.

And on my old machine the files have gotten corrupted despite the fact all the data is there in the FRM files.

I need serious help!!!

HRR's profile image HRR posted 3 years ago Permalink

Just to add all the "Tables" are displaying as views??

sp all .fr, & .ibd files are in the data folder but in Heidi are only views and not tables.

ansgar's profile image ansgar posted 3 years ago Permalink

Be sure you select UTF-8 in the file-open dialog:

Description

.. unless you are sure the file has a different encoding. Could that be the case? How was the file written?

HRR's profile image HRR posted 3 years ago Permalink

UTF 8 i have tried that still get the stream read error.

Is it version dependent for MariaDB & HeidiSQL?

HRR's profile image HRR posted 3 years ago Permalink

Description

HRR's profile image HRR posted 3 years ago Permalink

Im now sat on an SQL file with 4 years worth of data that I can’t do anything with

HRR's profile image HRR posted 3 years ago Permalink

I also am getting this despite the fact the .frm & ibd files are all there.1.3GB of data

Description

ansgar's profile image ansgar posted 3 years ago Permalink

Are you able to open that HRRtransfer.sql file with some editor like Notepad++?

Please login to leave a reply, or register at first.