What to do with SQL files?

Scorpion Ghost · Feb 1, 2015

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

divok · Feb 1, 2015

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

Scorpion Ghost · Feb 1, 2015

divok said:
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.

Scorpion Ghost · Feb 1, 2015

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

Xp3r7 · Feb 1, 2015

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.

Scorpion Ghost · Feb 1, 2015

Xp3r7 said:
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.

Xp3r7 · Feb 1, 2015

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.

What to do with SQL files?

Scorpion Ghost

Elite Member

divok

Senior Member

Scorpion Ghost

Elite Member

Scorpion Ghost

Elite Member

Xp3r7

Regular Member

Scorpion Ghost

Elite Member

Xp3r7

Regular Member

Main Menu

Marketplace

Making Money

BlackHatWorld

Other