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

What to do with SQL files?

Discussion in 'BlackHat Lounge' started by Scorpion Ghost, Feb 1, 2015.

Thread Status:
Not open for further replies.
  1. Scorpion Ghost

    Scorpion Ghost Senior Member

    Joined:
    Mar 22, 2013
    Messages:
    1,124
    Likes Received:
    265
    Occupation:
    Internet!
    Location:
    On the Interwebz
    I'm not sure where to post this, so I'm posting in the lounge.

    I have some SQL databases I downloaded - jokes, recipes - and I basically have no idea and can't find out how to use them?

    I suspect that these databases can somehow be uploaded on a website easily, instead of having to go through the database and upload things manually, but I'm at a loss as to what to do with them?

    Can anyone give me an idea on how these can be used?

    Each SQL database is basically just 1 txt file.

    Thanks
     
  2. divok

    divok Senior Member

    Joined:
    Jul 21, 2010
    Messages:
    1,067
    Likes Received:
    648
    Location:
    .IN
    most of these jokes and recepies might have already been uploaded several times . so mostly they are useless.

    you can upload them to wordpress via phpmyadmin
     
    • Thanks Thanks x 1
  3. Scorpion Ghost

    Scorpion Ghost Senior Member

    Joined:
    Mar 22, 2013
    Messages:
    1,124
    Likes Received:
    265
    Occupation:
    Internet!
    Location:
    On the Interwebz
    Yes, I know that a lot of people have probably used the same jokes and recipes, but let's set that aside for a moment. I'm at a point now where I just want to learn how to make it work. To make this work:

    "Upload them to wordpress via phpmyadmin." :)

    I'm trying to do it now... will post if I succeed.
     
  4. Scorpion Ghost

    Scorpion Ghost Senior Member

    Joined:
    Mar 22, 2013
    Messages:
    1,124
    Likes Received:
    265
    Occupation:
    Internet!
    Location:
    On the Interwebz
    But of course, how could it ever work or be easy...

    This is the error I got after:

    Creating a MySQL User
    Creating a MySQL Database
    Using phpMyAdmin to Upload an SQL file

    1234.jpg
     
  5. Xp3r7

    Xp3r7 Regular Member

    Joined:
    Sep 9, 2011
    Messages:
    286
    Likes Received:
    386
    Occupation:
    Freelancer
    Location:
    In the middle of nowhere
    First of all, the SQL files should be compatible with Wordpress DB structure. You can't import ANY file just like that. Website != Wordpress.
    If the file is not supported you'll need to get the data into a format that Wordpress can handle.
     
  6. Scorpion Ghost

    Scorpion Ghost Senior Member

    Joined:
    Mar 22, 2013
    Messages:
    1,124
    Likes Received:
    265
    Occupation:
    Internet!
    Location:
    On the Interwebz
    Awesome, thank you so much. That makes perfect sense, and advances my journey, hehe :p

    So I'll go look for guides or something to learn how to make an SQL file so that it's supported by Wordpress DB structure.

    Got any tips for me? A helpful link? A nod in the right direction?

    I'm using Hostgator, and of course the latest version of Wordpress, if that matters.
     
  7. Xp3r7

    Xp3r7 Regular Member

    Joined:
    Sep 9, 2011
    Messages:
    286
    Likes Received:
    386
    Occupation:
    Freelancer
    Location:
    In the middle of nowhere
    You have to understand how the database works. Once you know that, you'll know how to edit your current SQL files to a format that will fit your needs.
    Take a look at this: http://www.elated.com/articles/mysql-for-absolute-beginners/
    and then start watching some tutorials about MySQL/SQL in YouTube. There are plenty of them, especially for beginners.
     
    • Thanks Thanks x 1
Thread Status:
Not open for further replies.