Posted 2 years ago #
Recently i backup my database using plugin wp dbmanager from my wp blog http://www.A.com and import it on mysql database of my another wp site http://www.B.com. the database change theme, plugins, structure everthing even when i try to login - http://B.com/wp-login.php they redirect to http://A.com/wp-login.php.
now if i visit - http://B.com, i see eveything same as http://A.com, and when i click any post they redirect too - http://A.com post page.
Posted 2 years ago #
After downloading the database from http://www.A.com you need to edit any text that is http://www.A.com and change it to http://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 http://www.B.com.
Posted 2 years ago #
Thanks for your suggestion, but now i already import database to http://www.B.com, so how can i edit sql database from http://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
Posted 2 years ago #
Hello Michael
so why the theme of my site site http://www.B.com will be changed
you can see here
http://www.A.com = http://www.movieflake.com
http://www.B.com = http://rashnayan.info/
if you visit = http://rashnayan.info/ you see everything is same as http://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 -
Be careful not alter anything else though. You should then be able to log in and set your themes, etc as you wish.
Posted 2 years ago #
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.
Posted 2 years ago #
Hi duck__boy
yaa now im able to login, but http://rashnayan.info/ will be login by using old site username and password (http://www.movieflake.com)
http://rashnayan.info/ did not accept there original username and password.
now what will i do?
Posted 2 years ago #
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?
Posted 2 years ago #
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- http://codex.wordpress.org/FAQ_Working_with_WordPress#Importing_and_Exporting
This topic has been closed to new replies.
