Results 1 to 3 of 3
Aug 17, 2013, 22:58 #1
- Join Date
- Nov 2008
- 1 Post(s)
- 0 Thread(s)
Unable to transfer database from one site to another
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'
Can anybody tell me the solution ?
I want to transfer database "db1" with tables and data from 1st website to 2nd website database.