2
You can use:
- phpMyAdmin (select all tables and select the command in the drop-down menu to change prefix)
- Protector (change prefix)
Whatever you feel more comfortable with....
If you do it manually, don't forget to change it in the configuration (mainfile.php or in secure.php in the new versions of XOOPS)