azpage Posted October 27, 2004 Report Share Posted October 27, 2004 Uz win98, win2000 nebija agraak ipashu probleemu ar sql faila ierakstiishanu datubaazee, t.i. backup failu ierakstiit arii uz sava datora servera. Tachu tagad uz xp windows man tas nesanaak, jo izmet kluudu: -------------------------- You have an error in your SQL syntax. Check the manual to halt corresponds to your MySQL server versopm for the right syntax to use near 'DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci' at line -------------------------- komandrindaa rakstiju: mysql -u root -p <local1.sql Idzeesu to kluudu sql skriptaa noraaditajaa rindaa (13), bet taapat, talak atkal pie taa pasha kodeejuma apstaajas, tikai citaa skripta vietaa. MySQL versija 4.0.17 Kaa lai noveershu sho kluudu? Link to comment Share on other sites More sharing options...
bubu Posted October 27, 2004 Report Share Posted October 27, 2004 A no kuras MySQL versijas ir tas SQL skripts ģenerēts. Domāju, ka var pamēģināt izmest vispār ārā to DEFAULT CHARACTER SET ... Link to comment Share on other sites More sharing options...
Venom Posted October 27, 2004 Report Share Posted October 27, 2004 tev tas COLLATE latin1_swedish_ci ļoti vajadzīgs? un arī DEFAULT charsets manuprāt pats par sevīm ir latin1 Replace All par '' Link to comment Share on other sites More sharing options...
azpage Posted October 28, 2004 Author Report Share Posted October 28, 2004 paldies par paliidziibu. Izdzeesu araa tos kodeejumus un viss aizgaaja. Link to comment Share on other sites More sharing options...
Recommended Posts