Import WordPress xml file larger than 8mb

OPTION 1: If a WordPress WXR file, an XML file exported from WordPress, is too large to import, there are several things you might try to overcome that limit. Increase the amount of memory a PHP script may consume. Note: If using a shared hosting service, you may need to ask your host to increase … Read more

Failed to import Media

I had a very similar problem when I moved a WordPress Blog from a single WordPress installation to a Multisite installation with different domain names but same IP. I found out that the problem is the wp_http_validate_url function which drops the URL if the source IP is the same as the destination IP. You can … Read more

Where does the Media Library live in the database?

Select * from wp_posts where post_type=”attachment”; Will return all the entries in the Media Library. After the execution, you can export the result table as SQL, or CSV, or any other portable data format you like. Remember, if you are not sure if the entries already exist in your database, use the INSERT IGNORE statement … Read more

Why is my database import losing text widget data?

This is where your problem is: I then edited the resulting .sql file to update all of the file paths and URL references to point to our production site. You can’t do that. WordPress stores many options as “serialized data”, which contains both the string content of things and their length. So when you modify … Read more

WordPress WXR Specification

I posed this question to John O’Nolan, a WordPress core developer, who forwarded my question to core committer Aaron Jorbin. O’Nolan responded by saying (I’m paraphrasing) that there isn’t any official documentation on the WXR standard, but that reverse engineering a WXR export should give me all the information I need. O’Nolan also noted that … Read more

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)