wpmhweb
Forum Replies Created
-
@cageehv thanks for clarification.
And yes, that what I usually do, I clear one item at a time, but this time the orphans had close to 60K items, and it was taking a long time.
@bcworkz Update: I’m still in the process of confirming this, but it would appear that the WordPress importer needs a better explanation so people can understand what’s going going. Also, a better approach to do this would be ideal.
It appears that when you check the “Download and import attachments” option during the import, WordPress actually connects with live site and downloads the images again without checking the Uploads folder content. So, because I originally restored the images from backup, WP was re-downloading the images again causing the images to renamed with additional numbers and dashes.
I think this is not a well thought out approach. If the images already exists, the importer should only update the records so the images appear in Media library and Upload experience.
If I don’t clear the “Download and import attachments” option, all the import will fail.
Solution, appears to be to clear the uploads folder, and let the import download the images again which takes hours. I’m still running this test, so I don’t know if it works 100 percent.
@bcworkz Update: Either WordPress or I is doing something wrong. I checked the Uploads folder, and I found that WordPress is creating a copy of each image during import. So, now in a given month of image, I have three copies, the original, one that ends of -1.jpg and third image that ends with -2.jpg. That’s why now wordpress appended the -2-2.jpg in the images link inside posts. Why?
This is what I did, created a new wordpress server, restored the images from backup to the Uploads folder, imported an xml with the Posts content, and then I imported the xml with the Media content.
@bcworkz I’ll take what I said in the last response back.
I exported the Media option, and the I opened the xml with an coded editor, and no problem were found in the links.However, when I imported the xml with the media elements in the destination site, the import now appended the “-2-2” at the end of the name of the image file. for example: this-is-image-2-2.jpg.
I looked into the the uploads folder and I found the xml file that wordpress used to import the content, and downloaded and I checked it no anomalies were found in the file.
As suggested, I disabled all the plugins and switched to the twentytwenty theme to export the media option from the export import settings in WordPress. In the destination site, I also made sure to disable all the plugin and I didn’t activate any theme.
I’ll try that.
Just a little more info. Only some posts get the image name alteration. Also, 99.9% of posts don’t get their featured image setting, but some do, why? I thought wordpress export import didn’t do featured images…PS: I opened the media xml file with a code editor, and I noticed that some images with the “-1-1”. Perhaps cleaning the bad paths could work.
@spacetime I think you mean the
ad_inserter_extract, because all the custom settings are in thead_inserter. I tried copying only the row that includes all the settings (ad_inserter) too and the plugin doesn’t picked up the settings.However, the only way it works for me was exporting the settings to .sql file. Open the exported file, copying the INSERT INTO statement with the data, and running the sql command in the SQL tab of phpmyadmin.
- This reply was modified 6 years, 2 months ago by wpmhweb.
@spacetime OK, so installed phpmyadmin, copied the content from the
ad_inserterad_inserter_extractto the new rows in the new database, I refreshed the wordpress site, and the no settings show up on Ad Inserter plugin.- This reply was modified 6 years, 2 months ago by wpmhweb.
Forum: Plugins
In reply to: [Taxonomy Images] What db table does Taxonomy Images uses to save images@tobiasbg Thanks for the clarification. Since this is getting more complicated than anticipated, I was wondering if when clicking the uninstall button from within the plugin will actually delete everything, settings and tablets, from the database without leaving anything behind?
I was thinking that I can close the server, use the uninstall button from Tablepress, then backup the tables I need to run WordPress without tablepress, and then restore WordPress table, reinstall tablepress and then restore the tablapress tables from the exported backup.
Second solution:
Also, out of curiosity, in the new site, where currently I can’t see the tablepress tables, if I install the plugin and I click the Uninstall button, will it delete the tables too? Or it needs tablepress_plugin_options and tablepress_tables in order to find and delete the tables from the wp_posts table?Thanks,
- This reply was modified 6 years, 2 months ago by wpmhweb.
It’s a little clear now. However, using the this command:
select option_name from wp_options;I see different values including:tablepress_plugin_optionsandtabletpress_tables.Ok. What’s the actually technical name for tablepress_tables and tablepress_options inside of a table? row, cell, column? I need to know so I can research a solution. Thanks,
@spacetime the server doesn’t have phpmyadmin, how to export and import these settings using mysql command lines.
Thank you so much.
Now I’m thinking that transfering the
tablepress_tablesandtablepress_optionsfrom thewp_optionsby any chance don’t know the mysqldump syntax to export those entries?
thank you so much.@tobiasbg
Ok, so when I transferred thewp_postsandwp_postmetaand downloaded the TablePress plugin, none of the tablets show up in the plugin. So the questions are, if I export a backup from the old site, and import it back to new database where I have already imported thewp_postsandwp_postmetatables from the old site, what’s going to happen to the existing tablepress tables already in the database, which currently the plugin doesn’t see? Are there going to be duplicate tables inside of the database? Will they get overwritten? the backup will look into the able find the tables and show them up in the plugin? What’s going to happen?Also, I see that it’s possible to export all or some of the tables, can I create backups in chucks? I mean can backup 20 tables, restore them, backup the next 20, and then restore and expect that at the end all the tables will show up in the new site?
Thanks,
- This reply was modified 6 years, 2 months ago by wpmhweb.
- This reply was modified 6 years, 2 months ago by wpmhweb.
- This reply was modified 6 years, 2 months ago by wpmhweb.
- This reply was modified 6 years, 2 months ago by wpmhweb.
- This reply was modified 6 years, 2 months ago by wpmhweb.
- This reply was modified 6 years, 2 months ago by wpmhweb.
- This reply was modified 6 years, 2 months ago by wpmhweb.