very large SQL-file [1,7 MB] cannot be opened - computer breaks down

dilbertone · May 27, 2011, 8:34pm

Hello dear friends, hello community,

Note: i run OpenSuse 11.3

My problem: i have a very very large database-dump that is stored in a sql-file. If i try it to open it either with bluefish-editior or with kwrite then i get errors over errors. What can i do. This File is quite tooo big; it has 1.7 Megabyte.

What can i do. Plz advice… Many many thanks in advance

greetings

robin_listas · May 27, 2011, 10:08pm

On 2011-05-27 20:36, dilbertone wrote:

> This File is quite
> tooo big; it has 1.7 Megabyte.

I don’t know about SQL, but 1.7MB doesn’t look to me a too large file.
Not even large.

–
Cheers / Saludos,

Carlos E. R.
(from 11.2 x86_64 “Emerald” at Telcontar)

martin_helm · May 27, 2011, 10:35pm

Carlos E. R. wrote:

> On 2011-05-27 20:36, dilbertone wrote:
>
>> This File is quite
>> tooo big; it has 1.7 Megabyte.
>
> I don’t know about SQL, but 1.7MB doesn’t look to me a too large file.
> Not even large.
>
kwrite opens for me xml files which are 10 times larger without any problem.
For a database dump this is avery small file.

@dilbertone
What errors do you get exactly. Is this dump a binary dump?

vindevienne · May 27, 2011, 10:51pm

Are you sure that it 1,7MB. This seems quite small for a dump. It would probably help if you stated the name and version of the database. I assume that the SQL file is a file containing a table. Have you tried to unload the data from the table.

Kwrite will normally open just about anything although what is displayed may not make much sense. Have you checked the system log to make sure that you are not running out of memory?

dilbertone · May 28, 2011, 10:34am

hello vindevienne, hello martin_helm, hello robin_listas

[just a quick note]

many many thanks - i will have a closer look at all your good postings and check all things later the weekend. I come back and report all my findings…

greetings
dilbertone

yanith · December 15, 2011, 8:52pm

what about a 549MB SQL file… I tried Notepat++, Dreamwaver, Coda, and TextWrangler.

Can anyone recommend a program that can open such large files, I need to open it and see what is inside i don’t want to delete anything from the server before i know what it is.

martin_helm · December 15, 2011, 9:13pm

Am 15.12.2011 20:56, schrieb yanith:
>
> what about a 549MB SQL file… I tried Notepat++, Dreamwaver, Coda, and
> TextWrangler.
>
> Can anyone recommend a program that can open such large files, I need
> to open it and see what is inside i don’t want to delete anything from
> the server before i know what it is.
>
>
Not sure about an editor, but what about using “less” to page through
the first parts of the file, with a bit of luck that can give enough
information what it is. (Sounds like you have a database dump for backup
here)

yanith · December 15, 2011, 9:28pm

yeah and i found it along with a backdoor php file

how can i use less, the file is already made, i just need to open it somehow

so i’m excited to see what it has, but every program i try crashes (

robin_listas · December 15, 2011, 9:48pm

On 2011-12-15 21:36, yanith wrote:

> how can i use less, the file is already made, i just need to open it
> somehow

“less filename”. Help? Press “h”.

–
Cheers / Saludos,

Carlos E. R.
(from 11.4 x86_64 “Celadon” at Telcontar)

martin_helm · December 15, 2011, 9:51pm

Am 15.12.2011 21:36, schrieb yanith:
>
> yeah and i found it along with a backdoor php file
>
> how can i use less, the file is already made, i just need to open it
> somehow
>
> so i’m excited to see what it has, but every program i try crashes (
>
>


less filename

where you replace filename with the real name of the file.

user · January 2, 2012, 4:07am

On Thu, 15 Dec 2011 20:36:02 GMT, yanith
<yanith@no-mx.forums.opensuse.org> wrote:

>
>yeah and i found it along with a backdoor php file
>
>how can i use less, the file is already made, i just need to open it
>somehow
>
>so i’m excited to see what it has, but every program i try crashes (

Have you tried ghexedit?

?-)