It's enough to make a backup of the database on the source server, then open the backup in the editor and using the command "Find and replace" to make the following changes:
CREATE TABLE ` changing to CREATE TABLE `myprefix_
INSERT INTO ` changing to INSERT INTO `myprefix_
Where myprefix_ - is the desired table prefix database. Just occasionally you may need to rename these tables here:
REPLACE ` changing to REPLACE `myprefix_
ALTER TABLE ` changing to ALTER TABLE `myprefix_
