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

Why “no projects found to import”?

Eclipse is looking for eclipse projects, meaning its is searching for eclipse-specific files in the root directory, namely .project and .classpath. You either gave Eclipse the wrong directory (if you are importing a eclipse project) or you actually want to create a new project from existing source(new->java project->create project from existing source). I think you probably want the … Read more

PG COPY error: invalid input syntax for integer

ERROR: invalid input syntax for integer: “” “” isn’t a valid integer. PostgreSQL accepts unquoted blank fields as null by default in CSV, but “” would be like writing: and fail for the same reason. If you want to deal with CSV that has things like quoted empty strings for null integers, you’ll need to feed it to PostgreSQL via … Read more

How to import a JSON file in ECMAScript 6?

Importing JSON using ES modules was submitted as feature to TC39 in mid 2020, and is (at the time of this edit) in stage 3, which is the last stage before being accepted in to the spec (see https://github.com/tc39/proposal-json-modules for more details). Once landed, you will be able to use it as: Where someName is effectively the name of … Read more