I have a site called www.site1.com. I want to transfer site1 database to another site www.site2.com I am using the same host I exported the site1 database to my desktop. then I made a new database, I called newsite database. i imported site1 database into newsite database using phpMyAdmin. i didn't do any thing to the SQL tab. i change the site2 wp_config.php file (db_name and db_user) to point at newsite database. But the www.site2.com shows me error in database. What am I doing wrong? Do I have to include mysql username ppassword database < file.sql??
I think it would be easier to export the database from site one using the export option in the wp-admin page and them importing it into site 2 using the wp-admin page. A lot less can go wrong this way since you arent merging the wp-options, just the content.