wpmhweb

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 the ad_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 4 years, 9 months ago by wpmhweb.

@spacetime OK, so installed phpmyadmin, copied the content from the ad_inserter ad_inserter_extract to 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 4 years, 9 months ago by wpmhweb.

@husobj inside of what row the information is stored? I’m thinking can copy the data and import it over the the database.

Thanks,

• This reply was modified 4 years, 9 months ago by wpmhweb.

@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 4 years, 9 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_options and tabletpress_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_tables and tablepress_options from the wp_options by any chance don’t know the mysqldump syntax to export those entries?
thank you so much.

@tobiasbg I don’t use phpmyadmin, just the mysql console, so how can I delete the tablepress entries from the wp-posts and wp_postmeta? and specific entries I have to delete? Thanks,

• This reply was modified 4 years, 9 months ago by wpmhweb.

@tobiasbg
Ok, so when I transferred the wp_posts and wp_postmeta and 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 the wp_posts and wp_postmeta tables 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 4 years, 9 months ago by wpmhweb.
• This reply was modified 4 years, 9 months ago by wpmhweb.
• This reply was modified 4 years, 9 months ago by wpmhweb.
• This reply was modified 4 years, 9 months ago by wpmhweb.
• This reply was modified 4 years, 9 months ago by wpmhweb.
• This reply was modified 4 years, 9 months ago by wpmhweb.
• This reply was modified 4 years, 9 months ago by wpmhweb.

Thank you for the info. I’ll have to go manual on this one.

Doesn’t the export takes a lot of resource for about 200 tables? I’m asking because I’m transferring the site because of some mysql performance issue, and I’m trying not poke the db too hard.
Thanks,

Thanks,

Thanks.
Due to some of the options, such as featured images not transferring correctly and possible timeouts when exporting a large amount of posts using the WordPress tool, I’m starting with a new new clean installation of WordPress, but I’m importing the some of the tables to the new database, such as:
wp_posts
wp_comments
wp_terms
wp_commentmeta
wp_postmeta
wp_term_relationships
wp_term_taxonomy
wp_termmeta

And then I’m reconfiguring the rest from scratch.

So, I’m bringing these tables to the new database, the only thing left would be configuring the general options with TablePress, correct?

Thanks,