Wuu Posted March 17, 2009 Report Share Posted March 17, 2009 Vajag dump 33mb ,bet windows neņem pretī ,palaižu dumpu un konsole izmet codu un apstājas! C:\Program Files\MySQL\MySQL Server 5.1\bin\mysql.exe Ver 14.14 Distrib 5.1.32 for Win32 (ia32) Connection id: 290 Current database: conterstrike Current user: root@localhost SSL: Not in use Using delimiter: ; Server version: 5.1.32-community MySQL Community Server (GPL) Protocol version: 10 Connection: localhost via TCP/IP Server characterset: latin1 Db characterset: latin1 Client characterset: latin1 Conn. characterset: latin1 TCP port: 3306 Uptime: 21 hours 5 min 11 sec Threads: 1 Questions: 628 Slow queries: 0 Opens: 130 Flush tables: 1 Open ables: 0 Queries per second avg: 0.8 Quote Link to comment Share on other sites More sharing options...
Aleksejs Posted March 17, 2009 Report Share Posted March 17, 2009 Tev ir dump fails, no kura vēlies atjaunot datus windows esošā datu bāzē? Kas ir tas, ko Tu raksti komandrindā? Quote Link to comment Share on other sites More sharing options...
Wuu Posted March 17, 2009 Author Report Share Posted March 17, 2009 Es uztaisiju dumpu no Linuxa ,un vēlos pilnīgi visu datubāzi pārcelt uz Windows Mysql! Windows datubāze ir tukšā dump conterstrike -u conterstrike -p < c:\server\dump.sql; Quote Link to comment Share on other sites More sharing options...
bubu Posted March 17, 2009 Report Share Posted March 17, 2009 Un vai tad tas visu neizdara kā vajag? Quote Link to comment Share on other sites More sharing options...
Wuu Posted March 17, 2009 Author Report Share Posted March 17, 2009 Apstājās izmet to kodu ko es postoju un viss beigās to --> bultinu ka gaida komandu :( Quote Link to comment Share on other sites More sharing options...
bubu Posted March 17, 2009 Report Share Posted March 17, 2009 Un kāpēc tu domā, ka imports nav noticis? Quote Link to comment Share on other sites More sharing options...
Wuu Posted March 17, 2009 Author Report Share Posted March 17, 2009 caur CMD izemt error Table not found: ";" mēģināju vēlreiz dump tas pac! Quote Link to comment Share on other sites More sharing options...
cilveks Posted March 17, 2009 Report Share Posted March 17, 2009 (edited) "dump" vietā izmanto komandu "mysql" un protams palasi manuāli lai uzzinātu precīzāku sintaksi, ja nepieciešams. Pilns internets ar paraugiem ;) http://www.google.lv/search?q=mysql+import+dump Edited March 17, 2009 by cilveks Quote Link to comment Share on other sites More sharing options...
Wuu Posted March 17, 2009 Author Report Share Posted March 17, 2009 Nepalīdz vaina ir kur citur ! Quote Link to comment Share on other sites More sharing options...
bubu Posted March 17, 2009 Report Share Posted March 17, 2009 Kas tieši tev tur nepalīdz? Ieraksti konsolē: mysql.exe -u username -p db_name < dump.sql un viss notiksies. db_name var arī nerakstīt, ja tev tajā dumpā ir datubāzes USE steitments. Quote Link to comment Share on other sites More sharing options...
Wuu Posted March 17, 2009 Author Report Share Posted March 17, 2009 Es pa gabaliem saliku caur phpmyadmin! :( Caurumā gan manas rokas gan WIndowsu... Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.