Troubles importing SQL data base

The only file output types are 7z, bh, bza, tar, cab, jar, lha and yzl no WXR (.xml) any suggestions to get my SQL data base imported ?

This would be a common problem for people with SQL files, any help with this please?

Helpful place this is lol ??

Some people do help, but most times if someone doesn’t know an answer, they won’t reply, and I’d think that’s what’s happened to you.

As for your problem, you can’t convert an SQL file to a WordPress XML file for import. You need to generate the XML file from your sites admin area under ‘Tools -> Export’.

Thanks for the explanation, so all ive got is the SQL file, which I cant import “directly” to wordpress, how can I convert it to something that I can then import to wordpress?

I read somewhere here about using php MyAdmin to convert it to another type of file

No. What you’d need to do is import it directly into phpMyAdmin, and that will re-create the database.

Just be aware that even though you’ll have that, you will also need pretty much everything in the sites /wp-content/ folder to create a proper copy of the site. The data is stored in the database, but the theme, plugins, uploads, etc are all stored in the file system.

Thanks for the quick reply, the problem is that I have the wordpress free site so don’t have access to phpMyAdmin for the actual wordpress site, I only have phpMyAdmin installed on my computer. I just need the text from the database not the theme etc

Then you should set up a dummy WordPress site somewhere and use the WXR file to import the site. That will create everything ofr you including the database entries. Then you can export the database to retrieve whatever information you need, then delete the dummy site when you’re done.

ok thanks, sorry, im a bit confused now, so you mean make a dummy site offline or online? and the only data base that I have is SQL not WXR

Where did the SQL file that you’ve got come from? Is it a dump of a current WordPress site, or is it from some other system?

To be clear… If it’s a dump from a WordPress site then you can use that by importing it into phpMyAdmin and linking a dummy site to that database and then you can export the WXR file from that.

If it’s from a different system you won’t be able to just mport it directly into any WordPress system. It will need some sort of import functinality written for it to get the data into the right areas to work with WordPress.

And, seeing as how you’re trying to set up a WordPress.COM Site, you should really be asking on their forums. It’s not quite as obvious as it should be, but there’s a huge difference between .org and .com.

My fail is same you

The sql dump is from the old wordpress site that I had on my own domain (now I want to set it up again), its the SQL file that I downloaded from the CPanel

yes I see its .com now, I will just set up on .org then ??