Hi, I am upgrading from 1.3.8a to 1.3.9h
I follow the steps on the upgrading guide. Now I come to the export and import database step. I followed the guide here:
https://www.zen-cart.com/tutorials/i...hp?article=103
I have successfully export the backup file. However, when I create a new database and try to import the backup, error occurred:
Error
SQL query:
--
-- Database: `MY_DATABASE`
--
CREATE DATABASE `MY_DATABASE` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
MySQL said: Documentation
#1044 - Access denied for user 'MY_USERNAME'@'%' to database 'MY_DATABASE'
The original Database is using mysql version 4.1. I tried to create new database with both 4.1 and 5.0, but both failed importing.
Then I tried not to export and import from the phpmyadmin. Instead, I chose 'backup' from the hosting control centre. A database backup is created in my FTP dirctory '_db_backup'. I downloaded it and saved it in my pc. Then I create a new database. Again, I did not goto phpmyadmin, I click 'restore from backup' from thr hosting control centre. Everything seems alright.
I want to know if I backup and restore the database in this way, is there any difference with the former method? I just worried it will not be a proper way to do the migrate and there will be bugs in the new database.
Please give me some advice.
Thanks!


Reply With Quote
