Query problem "DB Restore"

The_penguin · #1 (**permalink**) 11-12-05, 00:18

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