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
-- 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.
open the dumped .sql file in a text editor, change the prefix on the CREATE DATABASE statement, save, and then run it again