Urgent Sql Help!

[Northern Monkey]

All,

Have just exported data from my live system and selected to EXPORT as UPDATE and not INSERT (I know now this was the wrong idea). Problem is I accidentally dropped all my live tables! Anyone know any decent way to reimport the tables with my UPDATE sql backups?

NM.

[CompareStore]

Is it a mySQL database?
How did you do the backup? If you dumped out the data as sql statements you can easily import the data back in. I can tell how to do this if you have access to a command line on your server.

[Northern Monkey]

Yep it's mysql. I've got the dumped file from my ISP but when inserting it back in I just keep getting 1064 errors? But the structure etc looks fine.

NM.

[Northern Monkey]

Arrrgh my brain hurts!

Just trying to import 1 record (see code below) but I get #1064 - error with no details. It can't be a version mismatch as I'm importing into a db it was exported from. If I import with auto select character set I get error #1115 "SET NAMES" error. Any ideas?

NM.




INSERT INTO `villas` (`code`, `name`, `image`, `currency`, `low`, `high`, `address`, `description`, `user_id`, `country_id`, `town_id`, `datecreated`, `lastupdate`, `sleeplow`, `sleephigh`, `votes`, `score`, `website`, `pwpn`, `emailsent`, `image1`, `image2`, `image3`, `image4`, `image5`, `image6`, `status`, `advertiser`, `type`, `calendar`, `advertiser_id`, `reciprocallink`, `notes`) VALUES (1,'36RueDeBlois - Cottage','1.jpg','GBP','200.00','350.00','36 Rue De Blois, Montrichard, Loire Et Cher, France','A beautiful cottage set in the romantic village of Montrichard in the Loire Valley area of France. This quiet property has many attraction\'s and things to do including wine tasting, chateaux visiting etc.<**>The property comprises of an open plan sitting room with feature \'Godin\' solid fuel stove. Small archway to the kitchen and door to the terrace. Fully fitted English style kitchen stone spiral staircase to upper floor.\r\n\r\nUpstairs: 1 Double bedroom, 1 Bathroom comprising bath, shower, toilet.<**> <**> <**> ',78,1,1,'2005-04-02 15:04:28','2006-07-06 22:48:45','2','2',0,0,'http://www.36ruedeblois.com','pw',3,'1_1.jpg',NULL,'1_3.j pg','1_4.jpg','1_5.jpg','1_6.jpg',0,'0','cottage', 0,0,'http://www.webbuyeruk.co.uk',NULL);

[Northern Monkey]

Even weirder, If I just enter the line as an sql statement in the website it runs fine but I obviously can't paste over 5000 records through the website.

NM.

[CompareStore]

I obviously can't paste over 5000 records through the website

You could upload the backup to the server then open the file in a script and loop through running the SQL statments as if they were being entered.

[Northern Monkey]

Yep, sounds like what I'll have to do in the end. I had to enter them in batches of 800 but it took awhile so am now writing a script that will do what you said.

If anyone has any light to shed on my issues let me know.

Regards,

Chris.