What to do with SQL files?

Status
Not open for further replies.

Scorpion Ghost

Elite Member
Executive VIP
Jr. VIP
Joined
Mar 22, 2013
Messages
8,741
Reaction score
10,291
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
 
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

1234.jpg
 
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.
 
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 :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.
 
Status
Not open for further replies.
Back
Top