Eport data to new site

Please watch this video guide about this export: https://youtu.be/EZ4jxJDlTFs

After this process, open that sql file via Notepad and edit table name (if you need).

After this import it into other database.

I followed the instructions herehttps://wpbookingcalendar.com/support/comment-page-22/#comment-21574 to migrate
But i don’t see anything on importing the optons, just exporting and then the video ends.
When i import the options, it creates an option table with the old db prefix.
How can i import the options into the correct options table?

This is not resolved

1) Please open that exported sql file in Notepad or some other text editing application.

2) The find any text like wp_option

3) Replace this text to yourprefix_option
Save this sql file.

4) After this make import of this new sql file by using phpMyAdmin into the new database.

At what step do you have troubles?
Kind Regards.

Thank you for your help.
I went ahead and edited the sql file, removed the create table, and renamed all db table names.
The only error i get now on the import is:

MySQL said: Documentation

#1062 – Duplicate entry ‘1083’ for key ‘PRIMARY’

This is the only reference to 1083 in the sql file
(1083, ‘booking_activation_process’, ‘Off’, ‘yes’),

it seemed to import some or most of the file.

I still get an error on trying to activate the plugin. Maybe due to the sql error?

Hello.
If that one option was skipped, so then it’s fine.

Do you have this error or some other:

Parse error: syntax error, unexpected ”Type your date’ (T_ENCAPSED_AND_WHITESPACE) in /public_html/wp-content/plugins/booking/core/sync/wpbc-gcal.php on line 282

Kind Regards.

I do not know what did it, but it is working now.
Thank you so much for all of your help and responses.

Ok, great to know that it’s works.
Kind Regards.