I don't know what your DB errors are, posting them would be helpful.
For creating a new DB on the new site, please see this tutorial.
www.rockettheme.com/forum/index.php?f=60..._v=viewtopic#p315019
In particular, pay attention to #6, & 7.
Ben Lee
6. After clicking "Create User" you will be brought to a confirmation page stating that the user has been created. Click "Go Back" to be brought back to the "MySQL Account Maintenance" page.
7. Now that your Database and your user are created, you need to connect the two. From the main "MySQL Maintenance" page, you will see a section called "Add Users To Your Databases:". In this section, choose the User you just created from the dropdown for user and choose the database you just created from the database dropdown. Under priviledges, make sure the "ALL" box is checked, then click the "Add User to Database" button.
Julian
I have downloaded the backed up site (from my spare server) to my desktop, this was extracted to a new folder on desktop (as I would rar file of Joomla)
Jim
Upload the zipped installer to your new domain.
Extract it in the root (public_html) or a folder.
Run the installer just like a rocket launcher, the first screen will look a little different.
Julian
Now the first question is, Should I be using the name of the new client site here, or my original site name to enter the installer
Jim
During the install, the old DB name, password will be filled in by default, but you can change them if you have created a DB with a new name or password.
For example:
Development site
Database: localhost
Administrator: admin
Password: 12345
DB name: devsite
New site- this is the database you create on the new server before you run the install...
Database: localhost
Administrator: jsmith
Password: abcde
DB name: jsmith_site
(You could create the DB details to match the dev site, but as I said before, they are filled in by default and can be changed to your liking, as long as the match the details for the new DB you created.)
And finally, yes, when you do a full site back up with JoomlaPack, it should create an installation directory.
When doing a fresh install with the Rocket Launcher, a stock Joomla install, or a JoomlaPack back up, pointing to the root, or the folder the files reside in will automatically invoke the install process. Joomla automatically recognizes that the install has not run yet and redirects to the install directory.
So, instead of http://www.site_name.co.uk/installation/index.php...., http://www.site_name.co.uk should start the install process.