Failed To Open Mysql File Error 2
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about mysql failed to open file error 22 hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges mysql create database Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. mysql failed to start Join them; it only takes a minute: Sign up mysql: SOURCE error 2? up vote 30 down vote favorite 2 When I tried to source for a particular .sql file, namely 'metropolises.sql' that I created and saved previously from
Mysql Source Command
a database, the following error is displayed: Failed to open file 'metropolises.sql', error: 2 Any idea what went wrong? mysql share|improve this question edited Feb 4 '13 at 9:48 asked Feb 4 '13 at 9:46 Clueless Gorilla 3192511 1 What does it mean to "try to source for a particuar .sql file"? –Lightness Races in Orbit Feb 4 '13 at 9:51 1 Did you mean "search"? –veljasije Feb 4 '13 at 9:54 I created mysql execute sql file a table in a database. Now, in order to get the data created, I typed SOURCE metropolises.sql; into the terminal, however the error message as described above showed up. Pretty sure there's no error in the table created. –Clueless Gorilla Feb 4 '13 at 10:22 add a comment| 12 Answers 12 active oldest votes up vote 49 down vote Assuming you mean that you are trying to use the source command in order to execute SQL statements from a text file, the error number given appears to be passed through from the POSIX layer. Therefore, using this resource, we can deduce that the error value of 2 means "no such file or directory". In short, you got the path wrong. Try providing an absolute path, as it's not clear what the current working directory will be in the context of your MySQL server. You may be assuming that it's the working directory of your shell, but it's not obvious that we should expect this to be true. share|improve this answer answered Feb 4 '13 at 9:59 Lightness Races in Orbit 217k35337583 Thanks. I know this is stupid, but how to find the file I created under within a database? –Clueless Gorilla Feb 4 '13 at 10:29 Provide an absolute path. The full path. Including directory. –Lightness Races in Orbit Feb 4 '13 at 10:41 1 As
a while since I used MySQL, having switched to Postgresql sometime back. First thing I noticed was the lack of a GUI admin tool that PG spoils you with. Making failed to open file error 2 mysql linux matters worse, the command line tool isn't even added to your path; you can't just
Mysql Failed To Open File Error 13
run "mysql" like you can in a Unix shell, much less use the redirect shortcut. And I was getting errors. Here's what
Open Mysql File In Excel
you need to do to restore a MySQL backup on Windows: Run the command line tool from the start menu Open your backup file in a text editor. Does it start with a command to create http://stackoverflow.com/questions/14684063/mysql-source-error-2 or "use" the database? If not Create it, if necessary Type "use database" filling in your DB name Type "source path-to-SQL-file". BUT, you must follow these rules: Use the full source command, not the \. shortcut Have no spaces in your path. I copied mine to a root of a drive. Note that spaces in theĀ file name is OK, just not the path. Do not quote the file name, even if it http://philip.yurchuk.com/software/mysql-failed-to-open-file-error-2-and-22-on-windows/ has spaces. This gave error 22. Use forward slashes in the path, e.g., C:/path/to/filename.sql. Otherwise you'll get error 2. Do not end with a semicolon. Follow all those rules and it should work fine. Share this:TwitterFacebookGoogleLinkedIn mysqlwindows Post navigation Previous PostCompanies Using GrailsNext PostBasically, I'm just gonna walk the earth. 20 thoughts on “MySQL Failed to open file - error 2 and 22 on Windows” Ademu Anthony says: November 14, 2012 at 3:11 pm Thanks so much for this info. You where a savior to me this night. In my work for a project for this my site,Code Messiah, I run into an issue when I have to migrate some project in .net to MySQL. Thanks you for this guide. Its short but henvy abc says: December 18, 2012 at 4:34 am Thank you so much Hen Asraf says: April 17, 2013 at 4:46 am Hi, just a heads up; You can use backslashes but you'll have to escape them ("\\"); and you can use semicolons, it worked as well. However I wouldn't have figured out that the problem was the spaces in the path, that's the main issue! So thanks for the article! Andrew says: August 1, 2013 at 10:43 am Thank you very much, it works! Caesar Olima says: August 13, 2013 at 9:56
Archive::Windows Servers Archive area for Windows Servers's posts that were moved here after an inactivity period of 90 days. Search Forums Show Threads Show Posts Advanced Search Go to Page... Thread Tools Display Modes #1 12-15-2003, http://www.eqemulator.org/forums/showthread.php?t=10812 06:26 AM nadineemu Sarnak Join Date: Apr 2003 Location: UK Posts: 61 mysql 'Failed https://ubuntuforums.org/showthread.php?t=1890853 to open file 'db.sql', error: 2' please help! in the post HOWTO: Setup a server with EQEmu 5.X its says to type in 'source db.sql;' when i do this i get ... 'Failed to open file 'db.sql', error: 2' i have moved the db.sql file from my eqserver dir to C:\mysql\bin as the guide also says. Any ideas anyone, im failed to sure its something simple enough. just a bit thick i guess :( __________________ me version 1.2 ~ No place like home Server Controller~ nadineemu View Public Profile Send a private message to nadineemu Find all posts by nadineemu #2 12-15-2003, 06:31 AM Conan Hill Giant Join Date: Oct 2003 Posts: 145 When you are sourceing a file into mysql you must be in the directory that the file resides in. cd\mysql\bin failed to open mysql -u root mysql use databasenamehere; source db.sql Conan View Public Profile Send a private message to Conan Find all posts by Conan #3 12-15-2003, 06:39 AM nadineemu Sarnak Join Date: Apr 2003 Location: UK Posts: 61 ok that fixed it, thanks ) __________________ me version 1.2 ~ No place like home Server Controller~ nadineemu View Public Profile Send a private message to nadineemu Find all posts by nadineemu « Previous Thread | Next Thread » Thread Tools Show Printable Version Display Modes Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Forum Rules Forum Jump User Control Panel Private Messages Subscriptions Who's Online Search Forums Forums Home General General::General Discussion General::Server Discussion General::News General::News::Polls Support Support::General Support Idiot Posters Spell Support Support::Windows Servers Support::Linux Servers Support::Packetcollector Support::MiniLogin Quests Quests::Q&A Quests::Custom Quests::Completed Quests::Submissions Quests::Plugins & Mods Quests::need work Ques
Get Kubuntu Get Xubuntu Get Lubuntu Get UbuntuStudio Get Mythbuntu Get Edubuntu Get Ubuntu-GNOME Get UbuntuKylin Ubuntu Code of Conduct Ubuntu Wiki Community Wiki Other Support Launchpad Answers Ubuntu IRC Support AskUbuntu Official Documentation User Documentation Social Media Facebook Twitter Useful Links Distrowatch Bugs: Ubuntu PPAs: Ubuntu Web Upd8: Ubuntu OMG! Ubuntu Ubuntu Insights Planet Ubuntu Activity Page Please read before SSO login Advanced Search Forum The Ubuntu Forum Community Ubuntu Official Flavours Support General Help [SOLVED] Mysql and 11.10 Having an Issue With Posting ? Do you want to help us debug the posting issues ? < is the place to report it, thanks ! Results 1 to 5 of 5 Thread: Mysql and 11.10 Thread Tools Show Printable Version Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode December 4th, 2011 #1 jacknet52 View Profile View Forum Posts Private Message Just Give Me the Beans! Join Date Sep 2011 Beans 51 Mysql and 11.10 I downloaded a dump from my host site and the file looks like a source file with all the commands for setting up the database and all the data. however when I try to run it in Mysql to put it on my localhost I get this: mysql> source /home/downloads/rustic.sql; ERROR: Failed to open file '/home/downloads/rustic.sql', error: 2 Someone on another site suggested I drop the ; terminator but it didn't matter. I've tried various combinations to my home/download/file.sql and none work. I'm using Ubuntu 11.10 as localhost. Any suggestions please? Thanks Adv Reply December 4th, 2011 #2 The Cog View Profile View Forum Posts Private Message Oh go on, throw it. Join Date Nov 2007 Location London, England Beans 6,033 DistroXubuntu 15.10 Wily Werewolf Re: Mysql and 11.10 Firstly, I think you probably have the file path wrong - I would expect it to have your username in it, e.g. '/home/jacknet52/downloads/rustic.sql'. Secondly, I think that the sql process might not have read access to your home directory anyway. In which case, you might have to copy the sql file to /tmp and tell