import fisier.sql

[fabby]

am phpmyadmin si am exportat o baza de date .sql
cum o import?..

[Pirahna]

go to SQL

click Load SQL from file ...

click ok

[fabby]

am dat de drak cu ceva..am exportat ..insa la import imi da eroare:

There is a chance that you may have found a bug in the SQL parser. Please examine your query closely, and check that the quotes are correct and not mis-matched. Other possible failure causes may be that you are uploading a file with binary outside of a quoted text area. You can also try your query on the MySQL command line interface. The MySQL server error output below, if there is any, may also help you in diagnosing the problem. If you still have problems or if the parser fails where the command line interface succeeds, please reduce your SQL query input to the single query that causes problems, and submit a bug report with the data chunk in the CUT section below:
----BEGIN CUT----
eNo1Vgk0VP0bthuXYydZxjj0EWMww2Q5HdmyzBiyhBQGY8lk7NnFWCIaSxiSJUqy5MueqMbSKFuk
fJaQrSmGpEHI33+cOeeec9/7vs/veZ73d+97ftfMzs7GTh9iogUxgUPQZhh9CByCgMA14XDA3uG4
wAkAJpft9SFKlt76kNBgfBA2JBQXAsP7e8KC/IKgERA4DIE8xmvqaGjqHl/HoT4crq+lBcHjbuhB
zCKDIEqAdZT9JbQ+RBumBdPSVg8NwwZ6Y0O81fEEX8DR3g5iYw+FGJmbYRygkMtmx5pO/oEQSzMI
EqYJ2FobHTuCIWHa6kF4OGBrYft/CNTG/v9sCNixDNo/MDwSQBthzPUhuED18DAfdV2AKWeL4uQS
Z2NjA7Gdqrmp3c9TlyArysZmqsvGJnmc9QkPDCHcCCO4
etc...multe d-easta la greu?

exista vreo zexzolvare? (

[Pirahna]

pai , mai exporta odata sub format SQL (nu conteaza cum se numeste fisierul)

si deschide cu notepad , copy tot ce e acolo , paste in casuta de SQL din phpmyadmin si Run it

[IceBlast]

am si eu o problema....asemanatoare.....de fapt....eu nu pot sa fac import la un fisier SQL....cu phpmyadmin....este pus pe un server cu win98.... e ok totul.... cand dau import la tot fisierul....nu merge....daca iau pe rand....din acel fisier...merge....
as vrea sa stiu cu ce alt program as putea sa incerc....sau comanda pt command line.....

[fabby]

mi se pare ca din ca din cauza ca ai facut export din alta versiune de phpmyadmin decat cea in care vrei sa introduci tu exportu..

[IceBlast]

nu este din cauza asta....pt ca aceeasi versiune de phpmyadmin o am si pe calcu meu....si merge....nu este nici o problema....
am incercat sa fac import direct de pe server cu phpmyadmin....da nu mi`l deschide....

[smorosanu]

[sc]

try next command
mysql -u root -p < sursa.sql
introdu parola de root si
sper sa nu ai erori de sintaxa in fisierul .sql

By.