Need Help With Database Transfer

[ntonline]

Hi there,

I have a website located on the root domain and am in the process of redeveloping the site on a sub-domain. Both sites are running the latest version of Joomla 2.5. Both sites are obviously running on the same server. Both sites are also running the same version of PHP.

I need to copy the following content from the old to the new site:

• Menus
  Categories
  Articles
  Featured Articles
  Media
  Users
  User Groups

My concern is that both sites use a different Database Name and a different Database Tables Prefix. If I copy the information from the old site using phpMyAdmin from the old site to the new site, will the new site still function properly? Or do I need to modify the tables in some way before I migrate the new tables to the new site?

Thanks for the help!

[ntonline]

I figured out how to transfer the data over to the new site. The table names do need to match the table names of the new site.

A new issue has come up, however. I am no longer able to sign in to the front-end or the back-end of the site using the new user table. Does anyone know how to fix this?

[humvee]

Remember that the Joomla Username and Password that you are now going to be using are the same as you used on the old site and not the ones you used on the new site during its creation.
http://docs.joomla.org/How_do_you_recov ... assword%3F