neugi Posted September 21, 2006 Share Posted September 21, 2006 Hi, till now i haven't workd with the mySQL Shell, an now i've to import a 400 MB sql file to my database. Is there a way to execute it in the mysql shell?this one don't worked : LOAD DATA INFILE 'ARTIKEL_akt.sql' INTO TABLE cd1_gmunden.artikel;thx Quote Link to comment Share on other sites More sharing options...
neugi Posted September 21, 2006 Author Share Posted September 21, 2006 Hi, i found out that there are 2 ways:in the mysql Tool type: SORUCE file.sqlormysql -u USER -p PASWWORD DATABASE < file.sqlmy problem is now that after a few secounds i get this error:[code]ERROR 2006 (HY000): MySQL server has gone awayNo connection. Trying to reconnect...Connection id: 155Current database: cd1_gmunden[/code]only the structure of the table is created, but no data in it.sql file is generated with phpmyadminbest Quote Link to comment Share on other sites More sharing options...
fenway Posted September 21, 2006 Share Posted September 21, 2006 Strange... and you're doing this locally? Quote Link to comment Share on other sites More sharing options...
neugi Posted September 21, 2006 Author Share Posted September 21, 2006 yes, all files are on the serverbest Quote Link to comment Share on other sites More sharing options...
fenway Posted September 22, 2006 Share Posted September 22, 2006 Then I don't see how you can be losing the connection... unless you're sending huge amounts of data all at once, or the server died. 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.