Page 1 of 2 12 LastLast
Results 1 to 10 of 11

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

  1. #1

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

    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

  2. #2
    Join Date
    Feb 2009
    Location
    Spain
    Posts
    25,547

    Default Re: very large SQL-file [1,7 MB] cannot be opened - computer breaksdown

    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)

  3. #3
    Join Date
    Feb 2010
    Location
    Germany
    Posts
    4,654

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

    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?

    --
    PC: oS 11.3 64 bit | Intel Core2 Quad Q8300@2.50GHz | KDE 4.6.3 | GeForce
    9600 GT | 4GB Ram
    Eee PC 1201n: oS 11.4 64 bit | Intel Atom 330@1.60GHz | KDE 4.6.0 | nVidia
    ION | 3GB Ram

  4. #4

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

    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?

  5. #5

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

    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

  6. #6

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

    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.

  7. #7
    Join Date
    Feb 2010
    Location
    Germany
    Posts
    4,654

    Default Re: very large SQL-file [1,7 MB] cannot be opened - computer breaksdown

    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)

    --
    PC: oS 11.4 (dual boot 12.1) 64 bit | Intel Core i7-2600@3.40GHz | KDE
    4.6.0 | GeForce GT 420 | 16GB Ram
    Eee PC 1201n: oS 11.4 64 bit | Intel Atom 330@1.60GHz | KDE 4.7.4 |
    nVidia ION | 3GB Ram

  8. #8

    Default Re: very large SQL-file [1,7 MB] cannot be opened - computer breaksdown

    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 (

  9. #9
    Join Date
    Feb 2009
    Location
    Spain
    Posts
    25,547

    Default Re: very large SQL-file [1,7 MB] cannot be opened - computer breaksdown

    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)

  10. #10
    Join Date
    Feb 2010
    Location
    Germany
    Posts
    4,654

    Default Re: very large SQL-file [1,7 MB] cannot be opened - computer breaksdown

    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 (
    >
    >

    Code:
    less filename
    where you replace filename with the real name of the file.

    --
    PC: oS 11.4 (dual boot 12.1) 64 bit | Intel Core i7-2600@3.40GHz | KDE
    4.6.0 | GeForce GT 420 | 16GB Ram
    Eee PC 1201n: oS 11.4 64 bit | Intel Atom 330@1.60GHz | KDE 4.7.4 |
    nVidia ION | 3GB Ram

Page 1 of 2 12 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •