Unable to transfer database from one site to another

Databases
1

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


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

2

open the dumped .sql file in a text editor, change the prefix on the CREATE DATABASE statement, save, and then run it again

3

Thanks r937

Its now working fine.

vineet