What to do with SQL files?

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

 

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

 

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.

 

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

 

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.

 

Awesome, thank you so much. That makes perfect sense, and advances my journey, hehe

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.

 

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.