ludaus

Hmm… I’ve must’ve done something wrong along the way then. Probably it’s the migrating part that I do wrong. In my database I have the original 17 tables for the original site (prefixed wp_), same amount for the staging site (prefixed staging_wp_) and when I try to migrate using WP migrate, I end up with another 17 tables with the new prefix wp_staging_. I guess that what was supposed to happen was that the tables prefixed with wp_ should have been overwritten with the content from the staging_wp_-tables. ??

As you can see, I don’t know what I’m doing, but I’m trying to learn and do have backups of everything (which I’ve already used to restore the site three times, so I’m not afraid of breaking it). ??

Thanks anyway. I’ll keep trying to see if I learn something new. ??

/L

I cannot find an option name called ‘rewrite_rules’, but there is one with the name ‘_transient_rewrite_rules’, is this the one I should change to empty.

Could you please also help me understand the suggested SQL. If I’ve already changed the prefix on the tables from the old staging site prefix “staging_wp_” to wp_ shouldn’t it be those tables that I update? I.e. should I write the SQL like this?

update ‘wp_usermeta’ set field_name = replace(meta_key, ‘staging_wp_’,’wp_’) where meta_key like ‘_%’;

‘update ‘wp_options’ set option_name = replace(option_name, ‘staging_wp_’,’wp_’) where option_name like ‘_%’;

Best regards,
Ludvig