If you have already created the database that you wish to import into and you have selected that database in PHPMyAdmin, but the import file is trying to create a new database, then you will see this error message. All you need to do is open up the SQL file in a text editor and … Read more
The steps to take would be: 1 – Extract files 2 – Create DB and import 3 – modify wp-config.php for database name and user credentials if changed Do not modify db tables to change the site url as they are serialized and this will create more issues than you want to deal with. 4 … Read more
I see you posted you found a solution, but just to add for others (and in case you’re interested in another method): You could hook Site A on the post’s status change to Published to POST all relevant post data to an endpoint on Site B’s api you’ve set up to function as a webhook. … Read more
Cold Fusion is a web server that processes CFM files along with HTML files. CFM is a web server ‘language’ similar to the PHP language. A ‘Cold Fusion Server’ is built to process the CFM files (which can contain CSS, HTML, and Cold Fusion language directives). So, by default, an index.cfm file will be processed … Read more
If you just need to change the post content, you can avoid the overhead of get_posts/WP_Query by directly querying the database: global $wpdb; $results = $wpdb->get_results(“SELECT ID, post_content FROM {$wpdb->posts}”); $total = count($results); $changed = 0; foreach($results as $entry){ $new_content = strip_tags($entry->post_content, ‘<img><a>’); if($entry->post_content !== $new_content){ $wpdb->query($wpdb->prepare( “UPDATE {$wpdb->posts} SET post_content = %s WHERE ID … Read more
Have you seen wpshell? It’s a command line tool for wordpress. Basically, it’s a WordPress environment that lets you run arbitrary php – so you could set up a WP_Query that pulls all posts, loop through them, and fire that command on each one. Sort of what I had in mind, untested. Using wp_update_post() as … Read more
When exporting from original database you should choose to create the tables if they dosn’t exist (First error). If you didn’t choose that option (in phpMyAdmin that option exists, not sure in other database tools), the import file can not create the tables for your and you need to create then prior to start importing … Read more
All site content for your WordPress site is stored in the database. The files that query and display the data, store settings, etc, are in the theme and plugin folders. There is the wp-config.php file that stores access credentials for your database. And media files are stored in the wp-content folder, but media files locations … Read more
Very likely your settings are there but during your find and replace in sql you may have corrupted the serialised options. If you are doing a mysql dump from site #1 and importing dump to database for site #2, you might want to use my WordPress migration script. Using the WordPress migration script you can … Read more
You should probably not run preg_replace on the meta data for a _wp_attachment_metadata field as the data is serialized. I would recommend instead you write a small script to loop through the images, unserialize the data, update the value, serialize and store the modified array. Here’s a sample function which does just that: function wpse_135525_fix_imagepaths() … Read more