foevah Posted February 17, 2009 Share Posted February 17, 2009 I am having trouble importing a large SQL file into MySQL. I am pasting this into start run cmd: cd M:\MySQL\MySQL Server 5.1\bin mysql -h localhost -u root -p db_name < db_data.sql and I get this message: The system cannot find the file specified. I have one disk drive that is partioned. The CMD window starts on the C drive but MySQL is installed on my M drive. I have tried changing drives by entering: cd M:\ but nothing happens it stays on the C drive. I think is this part of the problem? Can someone help me fix this please? This SQL file is a beast. It is at 7000kb Quote Link to comment https://forums.phpfreaks.com/topic/145623-solved-how-to-import-a-big-sql-file-whys-it-not-working/ Share on other sites More sharing options...
foevah Posted February 17, 2009 Author Share Posted February 17, 2009 fixed in cmd i needed to type M: then paste the sql dump line Quote Link to comment https://forums.phpfreaks.com/topic/145623-solved-how-to-import-a-big-sql-file-whys-it-not-working/#findComment-764570 Share on other sites More sharing options...
Mchl Posted February 17, 2009 Share Posted February 17, 2009 Please mark topic as solved And congratulations on learning basics of MS DOS Quote Link to comment https://forums.phpfreaks.com/topic/145623-solved-how-to-import-a-big-sql-file-whys-it-not-working/#findComment-764572 Share on other sites More sharing options...
corbin Posted February 17, 2009 Share Posted February 17, 2009 You could also have just used \. inside the MySQL CLI. Quote Link to comment https://forums.phpfreaks.com/topic/145623-solved-how-to-import-a-big-sql-file-whys-it-not-working/#findComment-764598 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.