re-installing/mysql error

[gcampos]

I moved to another server, and am attempting to move all files there, but ran into a problem. I followed these steps to a "T":
https://www.zen-cart.com/tutorials/i...hp?article=100

But when I tried to import the db I got an error that said:

PHP Version: 4.4.4
-- 
-- Database: `bul070...........`
-- 
 CREATE  DATABASE  `bul07....` ;

          MySQL said:  
  #1044 - Access denied for user 'zenbull'@'%' to database 'bul07......'

Not to sure what to do now, except start from scratch. Any ideas what went wrong?

Gerry

[kobra]

Who was the donor host and what or how did you generate the backup

How are you trying to restore it what tool

[gcampos]

Who was the donor host and what or how did you generate the backup

How are you trying to restore it what tool

I followed those steps in the link I posted, I use godaddy as host. not using not a "tool" the article doesnt specify a tool.

What I did, is back up the old db, exactly on how it said to, then installed fresh copy of zencart, created new db, dump the data tables, then try to import old db, and error happened.

I am thinking that perhaps the access denied is part of the problem, so looked at faq and found the same issue. Here it says to give permissions to user:
https://www.zen-cart.com/tutorials/i...hp?article=268 but I didnt see any of that info when I set up new db. so not sure why.

Gerry

[gcampos]

I tried opening the back up db, and change the first line that said:

-- phpMyAdmin SQL Dump
-- version 2.7.0-pl2
-- http://www.phpmyadmin.net
--
-- Host: 10.8.6.89
-- Generation Time: May 29, 2007 at 05:25 PM
-- Server version: 4.0.27
-- PHP Version: 4.4.4
--
-- Database: `bul######xxxxxx`
--
CREATE DATABASE `bul######xxxxxx`;
USE bul######xxxxxx;

to zenbull, which is the new name of db, but still no luck, said zenbull already exists.

[gcampos]

Sidenote: I still have the old store in a dir (subdomain setup) in the other host, so I can still get to the files, if there is another way of backing up the db. I will probably have to change the config around. will try it out see what happens.

[gcampos]

Well that didnt work, I installed the MySQL backup:

http://www.zen-cart.com/index.php?ma...products_id=81

Then made the backup, opened the import on PHPMyAdmin, and go the following error:

Error

SQL query:

-- MySQL dump 8.23
--
-- Host: mysql181.secureserver.net Database: bul070xxxxxxxxxx
------------------------------------------------------- --
-- Server version 4.0.27-max-log
--
-- Table structure for table `zen_address_book`
--
DROP TABLE IF EXISTS zen_address_book;

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '---------------------------------------------------------
-- Server version 4.0.' at line 1

I opened the db file and this is what is at the top:

-- MySQL dump 8.23
--
-- Host: mysql181.secureserver.net Database: bul070xxxxxxxxxx
---------------------------------------------------------
-- Server version 4.0.27-max-log

--
-- Table structure for table `zen_address_book`
--

DROP TABLE IF EXISTS zen_address_book;
CREATE TABLE zen_address_book (

So still stuck.

Gerry

[gcampos]

Ok well I just created a new db and went thru the install with new db, I only had 12 prods but still, better to be able to do it the other way. Now I have doubts.

If there is still a way for a fix here, don't hesitate to say it, I can always go back and create another one.

Gerry

[kobra]

Try editing the top part of a copy of your db back like:

#-- MySQL dump 8.23
#--
#-- Host: mysql181.secureserver.net Database: bul070xxxxxxxxxx
#---------------------------------------------------------
#-- Server version 4.0.27-max-log
#
#--
#-- Table structure for table `zen_address_book`
#--

DROP TABLE IF EXISTS zen_address_book;
CREATE TABLE zen_address_book (

As using this after you have created the DB, this is not required.

Your tool is phpmyadmin, and you should be able to select the DB first and receive a list of all the tables and then select export to produce a bak of selected tables without the "create DB" instruction