1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

I have a 35GB SQL backup - and need to view contents of it. How?

Discussion in 'Black Hat SEO' started by rowebil, Apr 2, 2011.

  1. rowebil

    rowebil Regular Member

    Joined:
    Sep 20, 2010
    Messages:
    390
    Likes Received:
    51
    Location:
    Pennsylvania
    I have a 35GB SQL file..

    That is huge - I know.

    It's loaded with accounts, private info, etc.

    But I just need to view the contents of it. Just browse through it - find what I need, then delete it.

    How should I do it?

    It will probably take YEARS to build on a MySQL server.

    How can I make it go faster, if possible?
     
  2. pr0ject

    pr0ject Power Member

    Joined:
    Aug 5, 2010
    Messages:
    596
    Likes Received:
    159
    You can't open it with MySql?

    (i don't know, never used mysql to this)
     
  3. fung1990

    fung1990 Power Member

    Joined:
    Dec 21, 2009
    Messages:
    577
    Likes Received:
    51
    find a computer with high CPU & ram
    and do nothing, open it until it loaded.
     
  4. rowebil

    rowebil Regular Member

    Joined:
    Sep 20, 2010
    Messages:
    390
    Likes Received:
    51
    Location:
    Pennsylvania
    My computer has 4GB 1.6GHz
    Dad's PC has 1.5GB 2.5GHz

    Which computer do I use?

    The netbooks are too slow, I believe.
     
  5. Autumn

    Autumn Elite Member

    Joined:
    Nov 18, 2010
    Messages:
    2,197
    Likes Received:
    3,041
    Occupation:
    I figure out ways to make money online and then au
    Location:
    Spamville
    Just install mysql and use the command line client to look through your stuff. I'd use the high ram machine to install your backup.

    mysql -u username -p password db_name < db_name.sql
     
  6. rowebil

    rowebil Regular Member

    Joined:
    Sep 20, 2010
    Messages:
    390
    Likes Received:
    51
    Location:
    Pennsylvania
    So, use mine - right?

    I don't feel like taking RAM out of machines and shit. My Dad's laptop crashes more than anything, and just turns off.. So I think I'll use mine?

    OR, maybe I'll buy the dedicated server I had - then use that, it was fairly fast - then I can use it for what I want..
     
  7. DarkoOS

    DarkoOS Newbie

    Joined:
    Feb 8, 2010
    Messages:
    19
    Likes Received:
    6
    Occupation:
    IT Manager
    Location:
    Osijek, Croatia
    Home Page:
    Install MySQL, setup my.ini for slover pc ( query cache, temp cache etc set to lower then default settings) that way your sql will work without crashes but much slower.
    Use SQLYog it is fantastic GUI for MySQL (3w . webyog . com/en/ )
    DO NOT browse whole tables in database, i think that is imposibile on 35G database.
    Learn SQL language and write custom query that will give you only data you wont.
    PM me if you need more help.

    Darko,
     
  8. shamster25

    shamster25 Regular Member

    Joined:
    Oct 12, 2008
    Messages:
    230
    Likes Received:
    164
    Private Info, Accounts?

    You got a stealer or RAT? Lol
     
  9. yesrams

    yesrams Regular Member

    Joined:
    Dec 16, 2009
    Messages:
    354
    Likes Received:
    75
    Location:
    @BHW
    Install XAMPP (For Windows OS),
    Create a Blank Database from PHPMyAdmin Area
    Import SQL File into that Database.
    Install MySQL Gui Tools (Available more options than PHPMyadmin)
    you can find here
    Open MySQL Query Browser (MySQL Gui Tools)
    Login to your MYSQL Admin Area (Using with root as a user name, password as blank, schema as type anything)

    Write the Query What you need to view the content.
     
  10. sagarpatil

    sagarpatil Regular Member

    Joined:
    Mar 2, 2009
    Messages:
    458
    Likes Received:
    278
    1. Install Appserv. (Includes Apache, MySQL and PHP)
    2. go to http://localhost
    3. Click on PhpMyAdmin
    4. Import your mysql file.
    5. You might wanna change the php.ini to import a large database.
     
  11. edgematch

    edgematch Elite Member

    Joined:
    May 24, 2010
    Messages:
    2,538
    Likes Received:
    1,949
    Occupation:
    You can never guess!
    Location:
    :noitacoL
    forget everything written here. Just download this software and pray for me.:)
    Code:
    http://navicat.com/en/products/navicat_premium/premium_overview.html
    You should have mysql installed before using your aabase. So, install easyphp.

    Repeating:

    1) download navicat
    2) install easyphp
    3) install navicat
    49 Import your atabse to navicat

    That is it.
     
  12. hackNstuff

    hackNstuff BANNED BANNED Premium Member

    Joined:
    Jun 10, 2010
    Messages:
    136
    Likes Received:
    15
    If it's a file that large I'd recommend against using phpmyadmin to import it, even with modifying the php.ini file you'll have trouble.
    As Autumn said:
    mysql -u username -p password db_name < db_name.sql
    That will import it faster than any other method I know of.
    As for accessing stuff, mysql query browser, mysql workbench, there's a load of others you could try, just learn a bit of sql.
    When dealing with large tables, always rerember to add a LIMIT clause!
    SELECT * FROM table_name WHERE field like "%somevaue%" LIMIT 10;
    If there are a lot of records and you don't limit it you could lock up the system (or just make the query take hours)
     
  13. rowebil

    rowebil Regular Member

    Joined:
    Sep 20, 2010
    Messages:
    390
    Likes Received:
    51
    Location:
    Pennsylvania
    How long do you think this will take?

    I'm using my Linux machine - a big advantage over windows as in speed. Linux doesn't use a lot of resources like windows.
     
  14. hackingxp

    hackingxp Newbie

    Joined:
    Apr 12, 2012
    Messages:
    1
    Likes Received:
    0
    he is asking about MDF database its only works in MSSQL + SMSS but only in developer edition . bcoz in production you only have limite of 10GB
     
  15. MuayThai

    MuayThai Jr. VIP Jr. VIP Premium Member

    Joined:
    Aug 25, 2015
    Messages:
    413
    Likes Received:
    125
    You've got Linux? Great! Then just try and do not be afraid. Remember, that exported SQL file could much bigger than real database. Having 4Gb of RAM could be pretty enough.
     
  16. Dingo66

    Dingo66 Junior Member

    Joined:
    Jan 13, 2015
    Messages:
    109
    Likes Received:
    4
    Gender:
    Male
    Occupation:
    System Administrator
    Are you cPanel user? If yes it is pretty simple to export your database.Just go into /var/lib/mysql and do db_username < dbname.sql After that if you need to send it to another server you can use scp -22 dbname.sql root@IP:the directory you need.Let me know if you still need further assistance on this.You can write me private message.I will be happy to assist you
     
  17. XxUnivaxX

    XxUnivaxX Jr. VIP Jr. VIP

    Joined:
    Jan 15, 2013
    Messages:
    2,057
    Likes Received:
    887
    Gender:
    Male
    Location:
    Basement