Database Backup Manager - MySQL

[tonkali]

Quick question and might seem stoopid but is Dr. Bytes Database Backup Manager utility compatible with zc 1.3.6?

(I ask b/c getting inconsistent answer to this:
Readme states: Designed for: Zen Cart v1.2.x series and 1.3.0
Download states: Compatible with Zen Cart v1.2.x and v1.3.x (but updated 5/06)

Thanks a bunch!
T.

[DrByte]

Yes, it's compatible with v1.3.6

[tonkali]

Thank U Dr. for the reply. I just wanted to be sure before I did anything. Thanks again.

T.

[yaby]

i decided to try this out! i'm transfering my database from one site to another, original site is running 1.3.5 and new site is running 1.3.6

i tried doing the phpmyadmin, but wasn't able to import the database:

................................................................................ ..........................................................
Error

SQL query:

-- phpMyAdmin SQL Dump
-- version 2.9.0.2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Dec 23, 2006 at 08:02 PM
-- Server version: 4.1.21
-- PHP Version: 4.4.2
--
-- Database: `yaby_zc1`
--
CREATE DATABASE `yaby_zc1` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;

MySQL said: Documentation
#1044 - Access denied for user 'yabycosm'@'localhost' to database 'yaby_zc1'
................................................................................ ............................................................


so i thought i would give this a try. after backing up the database using the backup manager from the download area, i use the same thing on the new site to try and restore the database, here is what i got:

................................................................................ ..........................................................
Success: File upload saved successfully db_yaby_zc1-20061225042811.sql.gz
Warning Result code: 1
Error Failure: The database may NOT have been restored properly. Please check it carefully.
................................................................................ ..........................................................

is there something i'm doing wrong?

if it helps, the original site is www.yabydesigns.com and the new site is www.yabycosmetics.com

btw, this is what i'm supposed to be doing so i can transfer all the client and products from one site to another right? or am i just totally retarded?

thx~

[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.