Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2008
    Posts
    33
    Plugin Contributions
    0

    Default Trying to restore database

    Hi all,
    need some help with restoring:
    I've used this great tool (Backup MySQL addon) to backup and it has created an sql file, I've tried to restore, it says it has restored successfully, but I don't see any of the information...
    The store I backed up and the new store are both on siteground servers, Safe Mode: Off and open_basedir has no value...
    I've tried to restore manually with phpmyAdmin and got an squl error about the timezone being NULL (?)
    anyone has an idea?
    thanks a lot...
    nils
    Last edited by nilsen; 4 Nov 2008 at 06:03 PM. Reason: forgot to subscribe for answer...

  2. #2
    Join Date
    Jan 2004
    Posts
    66,444
    Plugin Contributions
    279

    Default Re: Trying to restore database

    Quote Originally Posted by nilsen View Post
    The store I backed up and the new store are both on ...
    Um, are you trying to move/copy your store to a new one? If so, it would be advisable to follow the FAQ on doing that?
    https://www.zen-cart.com/tutorials/i...hp?article=100

    You've probably got mismatched DB_PREFIX settings between old and new.

    Quote Originally Posted by nilsen View Post
    ... both on siteground servers ...

    I've tried to restore manually with phpmyAdmin and got an squl error about the timezone being NULL (?)
    I would think that a phpMyAdmin problem would be best directed to your hosting company, since they're the ones providing it for you.
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  3. #3
    Join Date
    Aug 2008
    Posts
    33
    Plugin Contributions
    0

    Default Re: Trying to restore database

    ok, great , I'll try this and hope it works... :)

 

 

Similar Threads

  1. v139h Server Crash trying to restore site strange Customer table problem
    By cshart in forum General Questions
    Replies: 3
    Last Post: 6 Jun 2012, 03:48 AM
  2. Trying to restore zen cart version v1.3.7
    By inspiration100 in forum Installing on a Linux/Unix Server
    Replies: 5
    Last Post: 21 Mar 2011, 10:15 PM
  3. Virus Trashed Files Trying To Restore - Help!
    By gbd in forum Upgrading from 1.3.x to 1.3.9
    Replies: 2
    Last Post: 17 Dec 2009, 11:01 PM
  4. Failure when trying to restore SQL database
    By pdxdoug in forum Installing on a Linux/Unix Server
    Replies: 2
    Last Post: 22 Jul 2008, 11:46 PM
  5. database restore...
    By khopek in forum General Questions
    Replies: 3
    Last Post: 6 Jul 2007, 03:05 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg