failed to open file error 2 mysql source Harwich Massachusetts

Address 160 Rosary Ln, Hyannis, MA 02601
Phone (508) 790-0016
Website Link

failed to open file error 2 mysql source Harwich, Massachusetts

For details and our forum data attribution, retention and privacy policy, see here EQEmulator Home > EQEmulator Forums > Archives > Archive::Support > Archive::Windows Servers mysql 'Failed to open file Including directory. –Lightness Races in Orbit Feb 4 '13 at 10:41 1 As an added note, do not put the full path in quotes. i have read the sql manual and the tutorial and i believe that i am doing exactly as instructed i am running mysql5 on mac osx 10.5. I would expect that after CREATE DATABASE XXX it would say USE DATABASE XXX.

I am far from a MySQL expert, and I probably would never have figured this out without your help. Join Date Dec 2007 Location chennai-TN,India Posts 42 I even checked the permission for that file in that folder Code: myserver:/home # l -lrth drwxrwxrwx 3 root root 4.0K 2008-02-04 09:29 Other names may be trademarks of their respective owners. You where a savior to me this night.

Thread Tools Display Modes #1 12-15-2003, 06:26 AM nadineemu Sarnak Join Date: Apr 2003 Location: UK Posts: 61 mysql 'Failed to open file 'db.sql', error: 2' please help! mysql> use balticktravels; mysql> source balticktravels.sql; ITS working well. Do not quote the file name, even if it has spaces. Go to the directory where your sql file is located and from there start mysql Another way is to give the full path where you located the file.

I guess that your mysql is in an search path so you can type it anywhere you are. You may have to register before you can post: click the register link above to proceed. also if you have space in file or folder name you should use quotes. 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

Try providing an absolute path, as it's not clear what the current working directory will be in the context of your MySQL server. Leave a Reply Cancel reply Your email address will not be published. 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. Or would refer to all tables as 'database.table' rather than just using the table name.

I may not be clear enough, I've updated my question. I tried this and it works. What a headache! –PavoDive Mar 31 at 11:40 add a comment| up vote 3 down vote I first reach to the file c:\windows>cd c:\akura\Db Scripts c:\akura\Db Scripts>mysql -u root -p root Nota: there's only one problem I'm facing: load all the files in the "sql" folder at once.

Browse other questions tagged files batch or ask your own question. OK, thanks again. 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. Why are empty blocks not all the same size?

And I was getting errors. mysql> Thanks for all. thank you. Which day of the week is today? "Rollbacked" or "rolled back" the edit?

It has been closed. more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed I'm not sure we really need to restart mysql after importing an sql dump file... –Félix Gagnon-Grenier Sep 8 '15 at 17:43 @FélixGagnon-Grenier we are not, but sometimes mysql Using quotes caused the error on my occasion.

I was getting both the 22 and 2 errors and found your simple explanation exactly what was holding me up. Ask Ubuntu works best with JavaScript enabled In which case, you might have to copy the sql file to /tmp and tell mysql to source from /tmp/rustic.sql. If Dumbledore is the most powerful wizard (allegedly), why would he work at a glorified boarding school?

I received both the error 22 and the error 2 in Windows. Well youre mysql problem is solved! 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 How to get this substring on bash script?

I could not understand the Issue here? Not the answer you're looking for? Join Date Sep 2011 Beans 51 Re: Mysql and 11.10 Just to let you know Cog that I ran the Create Database 'database' command on the command line, ran Use database Are there any rules or guidelines about designing a flag?

Join Date Sep 2011 Beans 51 Re: Mysql and 11.10 thanks Cog: I think I got the path right this time, also spelled my filename right. /home/jacknet/Downloads/rusticdb.sql and I changed permissions SOURCE "/var/test.sql"; will fail with error code 2, while SOURCE /var/test.sql will work (assuming test.sql exists at that location). –Will Martin Jun 2 '15 at 21:11 yup, just a i have created a sql script file and i am trying to use it with the sql SOURCE command. A better way to evaluate a certain determinant Why is the spacesuit design so strange in Sunshine?

Powered by vBulletin, Copyright ©2000 - 2016, Jelsoft Enterprises Ltd. Vijay says: October 11, 2013 at 11:13 pm Nice Explanation…..Thank you very much….. Developing web applications for long lifespan (20+ years) How would they learn astronomy, those who don't see the stars? Thanks, Adam Faq Reply With Quote May 31st, 2004,01:46 PM #2 Guelphdad View Profile View Forum Posts  Hockey face Devshed Supreme Being (6500+ posts)      

Hope it works!!