naveen3733
Member
Posted 4 years ago #
Hi,
This's Naveen. I'm a lover of wordpress. I hosted a music site using wordpress. But presently i lost the site due to bandwidth problem. But i forgot to export XML for that site.
Presently i'm having SQL of that website.
Can u please tell me how to convert that SQL file to XML file and use it in my new wordpress blog. Please help me..
Thanks,
Naveen
If you have the .sql file (if that means the database backup) you don't need to convert it to xml. You can directly import it into the DB using phpMyadmin.
naveen3733
Member
Posted 4 years ago #
When i imported the old sql into new database. and when i opened the site most of the links are referring to oldsite address. its even loading very slow. can u please tell me wht to do
1. You can import a sql file ONLY into the same WP version that old one was.
After that, when it's working, you can upgrade. Not before!
2. If you have phpMyadmin access (I presume you do, if you did an import) - you need to change the home and site_url in the wp_options table.
See the tutorial:
http://www.tamba2.org.uk/wordpress/site-url/