Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2005
    Posts
    1

    Unanswered: Query problem "DB Restore"

    Hi, I see alot of these problems but no answers. My problem
    is that I made a backup of 1 of my DBs through Cpanel. It won't restore
    the complete SQL Dump though. I just went ahead and made the tables and fields, but I keep getting #1064 errors when I try to run a query to fill the fields. A sample of the query im trying to run.

    MySQL 4.0.24
    phpMyAdmin 2.6.4-pl2

    Code:
    INSERT INTO mos_components (id, name, link, menuid, parent, admin_menu_link, admin_menu_alt, option, ordering, admin_menu_img, iscore, params) VALUES (1,'Banners','',0,0,'','Banner Management','com_banners',0,'js/ThemeOffice/component.png',0,'');
    This came from the dump file Cpanel made so I don't get how there could be a prase error Thanks for any help

    Edit - Im running the query from phpMyAdmin in the SQL tab
    Last edited by The_penguin; 11-12-05 at 01:22.

  2. #2
    Join Date
    Aug 2002
    Location
    Germany
    Posts
    17
    Your field name "option" is a reserved word and therfore has to be qouted within `option`.

Posting Permissions

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