Title: XML to SQL (import failed)
Last modified: August 19, 2016

---

# XML to SQL (import failed)

 *  Resolved [alyas2022](https://wordpress.org/support/users/alyas2022/)
 * (@alyas2022)
 * [18 years, 2 months ago](https://wordpress.org/support/topic/xml-to-sql-import-failed/)
 * hello
    I have a blog hosted on wordpress.com , I want to export the data and 
   import it into an other hosting service..
 * My file XML exported is 1mo, I need it to be less than 500ko so my new hoster
   can accept it..
 * I zip it, but the new web hoster dosn’t accept sip files..
 * I think I can just export the database in SQL format so I can import directly
   in the new Database..
 * but in the wordpress hosting, we don’t have access to plugins..
 * How can I export my data from myblog.wordpress.com in SQL format ?

Viewing 2 replies - 1 through 2 (of 2 total)

 *  [MichaelH](https://wordpress.org/support/users/michaelh/)
 * (@michaelh)
 * [18 years, 2 months ago](https://wordpress.org/support/topic/xml-to-sql-import-failed/#post-716570)
 * You could always edit the file and delete any junk.
 * Or edit the file and break it into parts.
 * Or install Xampp on your local machine, install WordPress on your local machine,
   import the XML then export the MySQL database.
 *  Thread Starter [alyas2022](https://wordpress.org/support/users/alyas2022/)
 * (@alyas2022)
 * [18 years, 2 months ago](https://wordpress.org/support/topic/xml-to-sql-import-failed/#post-716576)
 * > Or install Xampp on your local machine, install WordPress on your local machine,
   > import the XML then export the MySQL database.
 * this is brilliant !
    why didn’t I think about it !! thx for your time

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘XML to SQL (import failed)’ is closed to new replies.

## Tags

 * [import export](https://wordpress.org/support/topic-tag/import-export/)
 * [sql](https://wordpress.org/support/topic-tag/sql/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 2 replies
 * 2 participants
 * Last reply from: [alyas2022](https://wordpress.org/support/users/alyas2022/)
 * Last activity: [18 years, 2 months ago](https://wordpress.org/support/topic/xml-to-sql-import-failed/#post-716576)
 * Status: resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics