Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2006
    Posts
    160
    Plugin Contributions
    0

    Default Can't restore database properly! HELP

    I've made a few posts about the upgrade I am working on. I have been following the upgrade instructions. I made a backup of my sites database and when I went to restore it into the "new sites" (ie: upgrade site) database, it only uploaded 112 out of 116 tables. SO...when I go to run the zcinstall for the upgrade, it tells me that I am missing (used DATABASE name in place of real database name)

    1146 Table 'DATABASENAME.whos_online' doesn't exist
    in:
    [show fields from whos_online]

    When I try to restore it a 2nd time, it simply times out every time and doesn't add the extra files.

    What can I do? I can't get the upgrade to work because of this. It's the first time I am doing this (restore). I am using cpanel but it times out (like I said)


  2. #2
    Join Date
    Nov 2006
    Posts
    160
    Plugin Contributions
    0

    Default Re: Can't restore database properly! HELP

    So I tried again this morning and got this error:
    [FONT=&quot]MySQL said:[/FONT]
    [FONT=&quot]#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 ''/catalog/index.p' at line 201[/FONT]
    [FONT=&quot]How do I fix this? Alternative would be to restore an older database version but it's on the server. Where on the server are those saved? I can't access admin panel
    [/FONT]


  3. #3
    Join Date
    Nov 2006
    Posts
    160
    Plugin Contributions
    0

    Default Re: Can't restore database properly! HELP

    so I finally got 115 of 116 to upload. I got into my admin.

    Now the error I get is:your database appears to need patching at a higher level.

    when I look at server info (as per error), it says:
    Database Patch Level: 1.3.6

    v1.3.6 [2006-11-11 15:35:40] (Fresh Installation)
    v1.3.6 [2006-11-11 15:35:40] (Fresh Installation)

    I am upgrading from 1.3.6

    what to do now?


 

 

Similar Threads

  1. Where can I find someone to help me restore my database?
    By Snaggle in forum General Questions
    Replies: 10
    Last Post: 10 Apr 2012, 01:38 AM
  2. Can't restore my database backup
    By jasonhoward64 in forum General Questions
    Replies: 4
    Last Post: 18 Mar 2011, 05:28 AM
  3. can't restore my database
    By mipavluk in forum General Questions
    Replies: 2
    Last Post: 30 May 2010, 09:42 PM
  4. Database backup mySQL can't restore
    By tvadpro in forum All Other Contributions/Addons
    Replies: 21
    Last Post: 29 Apr 2007, 12:34 AM
  5. Can't restore database
    By KTNaturals in forum General Questions
    Replies: 1
    Last Post: 4 Jan 2007, 05:41 AM

Bookmarks

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
Zen-Cart, Internet Selling Services, Klamath Falls, OR