Zen Follower
- Join Date:
- Jun 2008
- Posts:
- 170
- Plugin Contributions:
- 0
Trying to transfer SQL dump from one database to another
Trying to import my SQL file from one database to another and I go to PHPmyAdmin and try to import it and get this error instead.
--
-- Current Database: db60293_store
CREATE DATABASE /!32312 IF NOT EXISTS/ db60293_store /*!40100 DEFAULT CHARACTER SET latin1 */;
MySQL said: Documentation
#1044 - Access denied for user 'dbXXXXXX'@'%' to database 'db60293_store'
db60293 is the old database. I don't know how to edit a SQL file. Can I just bring it into Excel and make changes to it? I think this is ZC 1.3.8a although I'm not certain of that. I plan to upgrade to 1.5 once this is completed. But this import needs to be made first.