Database Backup Manager - MySQL

[Website Rob]

The error msg. tells us the story.

#1044 - Access denied for user 'yabycosm'@'localhost' to database 'yaby_zc1'

You did not change the db name before importing.

When a db is exported it saves the current db name and access info. If you are uploading to another account you must first make some changes.

As the db is just a text file, open it with a text Editor, do not use a Word Processor, and change this line:
CREATE DATABASE `yaby_zc1`
You need to use the db name of the account you are uploading to.

Also, in your Control Panel mySQL area, you will also need to use the same db Username & Password for access to this db. If not sure what they are you can look in the ZenCart config files.

[yaby]

ooooh ok.. so this is what i did..

i opened the gzip file that drbyte's backup program made from my first site, changed the database name to match my new databse name on the top of the file.

uploaded the file manually to my backup directory

and use drbyte's tool to restore it in the new site.

so now this is what i got:

................................................................................ ........................
Success: The database has been restored.
Warning Your database appears to need patching to a higher level. See Tools->Server Information to review patch levels.
Admin Powered by Zen Cart :: The Art of E-Commerce
................................................................................ ...........................


so i followed this link and ran the database patching .sql file and everything was good!


thanks so much!!! *^##############################___^*

[Website Rob]

Don't you love it when everything comes together?

Your welcome for the help and here's hoping your site makes you a fortune.