trouble post migration

Hi @iwallace001,

Sorry to hear you encountered issues.

When WP Data Access tables are copied from one site to another with an external tool, schema names are not updated. A script to fix this issue can be downloaded here:
https://wpdataaccess.com/docs/data-explorer-problems-and-solutions/transfer-to-other-wordpress-database/

It is also possible to copy/paste the code into the Query Builder and run the code interactively.

Let us know if this helps!

Thanks for the reply. I tried this method and used the syntax

set @old_db_name = ‘db0kfrbxga4kbq’
/
set @new_db_name = ‘dbdadly2ej4uty’
/

I get the error

WordPress database error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ”db0kfrbxga4kbq” at line 1

what should i try next?

thanks

Hi @iwallace001,

Please make sure your database names are enclosed in straight single quotes and not slanted ones. For example:

set @old_db_name = 'db0kfrbxga4kbq'
/
set @new_db_name = 'dbdadly2ej4uty'
/

Let us know how it goes. ??

i copied and pasted your straight quotes and i still get the same error ??

Hi @iwallace001,

Thanks for the response. Could you send us a screenshot of the whole query and the errors you saw when trying to execute it?

You can send it via Contact | WP Data Access if you wish to send it privately.

We’ll wait for your email. ??

Hi – I have uploaded a screenshot here

https://tasmaniawebdesign.com/wp-content/uploads/2024/01/Screenshot-2024-01-15-074645.png

Hi @iwallace001,

Thanks for the screenshot.

The query looks correct. Could you also send us a screenshot of the error you get when you ran that query?

The expected result should be like this if there are no errors.

We’ll wait for your response!

here is the error – same as the first message

https://tasmaniawebdesign.com/wp-content/uploads/2024/01/Screenshot-2024-01-15-222520.png

Hi @iwallace001,

Thanks for that. We might need to take a closer look at your setup.

Could you send us a ticket via Contact | WP Data Access?

We’ll wait for your email. ??

i have sent you and email via the contact form

I have not received any further support, can you confirm that you have received my email please? I’d like to solve this issue

thanks

Hi @iwallace001,

We responded to your ticket two days ago. ??

Could you check if our email has been filtered?

Once you find our email, kindly respond from there so we can track your issue.

We’ll wait for your response!

I can’t find an email from you, can you please resend it?

I checked my spam etc

Hi @@iwallace001,

We just resent our email. Please kindly check. ??

nothing received ??