I am in the process of developing a new website for a client. Part of the relaunch will be to migrate their website to a new webhost. I've setup the new site on the new web host, but haven't transferred DNS yet (using a mirror site for testing, etc.). I am preparing to migrate the content database from the old site to the new one.
On the new site, I setup a different Table Prefix ($table_prefix) in the wp-config.php file. Is this going to cause a problem when I import the database via phpMyAdmin from their old site to the new one?
If so, what is the best way for me to change the Table Prefix on the new site I am building to match the table prefix of their current site? The old site uses the default "wp_".