hi all

i am transferring database from one website to another.

When ever a database is created, then a prefix is added to the database name.

If my 1st website control panel loginid is vi555 then if i create a database the database name will be "vi555_db1".

If my 2nd website control panel loginid is vi777 then if i create a database the database name will be "vi777_db1".

The problem :
I took backup of 1st website database from phpmyadmin and tried to insert into 2nd website database it shows me error

Code:
Error

SQL query:

--
-- Database: `vi555_db1`
--
CREATE DATABASE IF NOT EXISTS `vi555_db1` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;

MySQL said: Documentation
#1044 - Access denied for user 'vi777'@'localhost' to database 'vi555_db1'
i think the problem is with the prefix. It is not allowing me to insert database into 2nd website.

Can anybody tell me the solution ?

I want to transfer database "db1" with tables and data from 1st website to 2nd website database.

vineet