Oh…my god, help me please……..

After downloading the database from https://www.A.com you need to edit any text that is https://www.A.com and change it to https://www.B.com. Just open it up in notepad and do a Ctrl+F and Replace with. You may need to carefully scan after this edit to make sure you didn’t miss anything. Sometimes a site may not have the www in the database fields. After this replace upload your new database to https://www.B.com.

Thanks for your suggestion, but now i already import database to https://www.B.com, so how can i edit sql database from https://www.B.com

can you tell me which table i exclude, so the theme and plugins did not come when in back up database.

Themes and plugins are NOT in the database. They are typically in the folder wp-content/themes and wp-content/plugins that reside on your host. Usually you would use FTP to backup those files.

See related articles:
WordPress Backups
Backing_Up_Your_Database
Restoring_Your_Database_From_Backup

Hello Michael

so why the theme of my site site https://www.B.com will be changed

you can see here

https://www.A.com = https://www.movieflake.com
https://www.B.com = https://rashnayan.info/

if you visit = https://rashnayan.info/ you see everything is same as https://www.movieflake.com

The theme a site uses is controlled by Appearances->Themes. All the themes available to a site can be found in that sites wp-content/themes folder.

If I understand you correctly then i gather you have completly copied your MySQL database from one site to another? If that is the case then all of your links will link to the old site, even when you click login from your admin logon page.

To rectify this i would go directly in to your database using PHPMySQL, browse to the wp_options table for the database that needs changing and then change these 2 entries only –

• option_id 2 – siteurl
• option_id 39 – home

Be careful not alter anything else though. You should then be able to log in and set your themes, etc as you wish.

You shouldn’t have used the database backup plugin to do what you want, just the export/import function. My guess is that in the database backup also has your WP settings such as the site url in the general settings, so of course that other blog will look like the first.

Hi duck__boy

yaa now im able to login, but https://rashnayan.info/ will be login by using old site username and password (https://www.movieflake.com)

https://rashnayan.info/ did not accept there original username and password.

now what will i do?

Hi Gangleri

i have some confusion about import/export function

1 – export function have two column ‘All author’ and ‘Administrator’ is i export one by one both ‘All Author’ and ‘Administrator’ to export all posts or ‘All Author’ includes Administrator post

2 – In import function we will import maximum 11 mb file size, if my file is larger than 11 mb what will i do?

1- I always take the default option, but I’m the only author, so it should be correct anyway. But you can check the file, it’ll just be an xml file.

2- https://codex.www.ads-software.com/FAQ_Working_with_WordPress#Importing_and_Exporting