Title: Troubles importing SQL data base Last modified: August 30, 2016 --- # Troubles importing SQL data base * [aquastarr](https://wordpress.org/support/users/aquastarr/) * (@aquastarr) * [10 years, 7 months ago](https://wordpress.org/support/topic/troubles-importing-sql-data-base/) * So I’ve installed php MyAdmin and I’ve clicked on tools / convert and selected the SQL data base but there is no option to convert it to a WXR (.xml) file which is needed for WordPress. What should I do? Viewing 14 replies - 1 through 14 (of 14 total) * Thread Starter [aquastarr](https://wordpress.org/support/users/aquastarr/) * (@aquastarr) * [10 years, 7 months ago](https://wordpress.org/support/topic/troubles-importing-sql-data-base/#post-6588417) * 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 ? * Thread Starter [aquastarr](https://wordpress.org/support/users/aquastarr/) * (@aquastarr) * [10 years, 7 months ago](https://wordpress.org/support/topic/troubles-importing-sql-data-base/#post-6588493) * This would be a common problem for people with SQL files, any help with this please? * Thread Starter [aquastarr](https://wordpress.org/support/users/aquastarr/) * (@aquastarr) * [10 years, 7 months ago](https://wordpress.org/support/topic/troubles-importing-sql-data-base/#post-6588584) * Helpful place this is lol 😀 * [catacaustic](https://wordpress.org/support/users/catacaustic/) * (@catacaustic) * [10 years, 7 months ago](https://wordpress.org/support/topic/troubles-importing-sql-data-base/#post-6588585) * 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’. * Thread Starter [aquastarr](https://wordpress.org/support/users/aquastarr/) * (@aquastarr) * [10 years, 7 months ago](https://wordpress.org/support/topic/troubles-importing-sql-data-base/#post-6588586) * 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? * Thread Starter [aquastarr](https://wordpress.org/support/users/aquastarr/) * (@aquastarr) * [10 years, 7 months ago](https://wordpress.org/support/topic/troubles-importing-sql-data-base/#post-6588587) * I read somewhere here about using php MyAdmin to convert it to another type of file * [catacaustic](https://wordpress.org/support/users/catacaustic/) * (@catacaustic) * [10 years, 7 months ago](https://wordpress.org/support/topic/troubles-importing-sql-data-base/#post-6588588) * 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. * Thread Starter [aquastarr](https://wordpress.org/support/users/aquastarr/) * (@aquastarr) * [10 years, 7 months ago](https://wordpress.org/support/topic/troubles-importing-sql-data-base/#post-6588622) * 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 * [catacaustic](https://wordpress.org/support/users/catacaustic/) * (@catacaustic) * [10 years, 7 months ago](https://wordpress.org/support/topic/troubles-importing-sql-data-base/#post-6588623) * 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. * Thread Starter [aquastarr](https://wordpress.org/support/users/aquastarr/) * (@aquastarr) * [10 years, 7 months ago](https://wordpress.org/support/topic/troubles-importing-sql-data-base/#post-6588624) * 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 * [catacaustic](https://wordpress.org/support/users/catacaustic/) * (@catacaustic) * [10 years, 7 months ago](https://wordpress.org/support/topic/troubles-importing-sql-data-base/#post-6588625) * 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](https://en.support.wordpress.com/). It’s not quite as obvious as it should be, but there’s a [huge difference between .org and .com](https://en.support.wordpress.com/com-vs-org/). * [teambuilding24](https://wordpress.org/support/users/teambuilding24/) * (@teambuilding24) * [10 years, 7 months ago](https://wordpress.org/support/topic/troubles-importing-sql-data-base/#post-6588626) * My fail is same you * Thread Starter [aquastarr](https://wordpress.org/support/users/aquastarr/) * (@aquastarr) * [10 years, 7 months ago](https://wordpress.org/support/topic/troubles-importing-sql-data-base/#post-6588627) * 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 * Thread Starter [aquastarr](https://wordpress.org/support/users/aquastarr/) * (@aquastarr) * [10 years, 7 months ago](https://wordpress.org/support/topic/troubles-importing-sql-data-base/#post-6588628) * yes I see its .com now, I will just set up on .org then 🙂 Viewing 14 replies - 1 through 14 (of 14 total) The topic ‘Troubles importing SQL data base’ is closed to new replies. * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) * 14 replies * 3 participants * Last reply from: [aquastarr](https://wordpress.org/support/users/aquastarr/) * Last activity: [10 years, 7 months ago](https://wordpress.org/support/topic/troubles-importing-sql-data-base/#post-6588628) * Status: not resolved ## Topics ### Topics with no replies ### Non-support topics ### Resolved topics ### Unresolved topics ### All topics