failed to open error 2 mysql Grand Bay Alabama

Address Mobile, AL 36608
Phone (251) 751-5378
Website Link

failed to open error 2 mysql Grand Bay, Alabama

most likely you have to run from your dos or command prompt Code: c:/mysql/bin/mysql -uusername -p123456 my_file_name.sql or something similar should work Faq Reply With Quote May 31st, 2004,02:10 PM #3 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. shortcut Have no spaces in your path. Example: with backslashes : source C:\folder1\metropolises.sql with forward slashes : source C:/folder1/metropolises.sql share|improve this answer edited Feb 17 '14 at 16:38 Alan 547416 answered Jun 6 '13 at 7:19 chad 4272612

Can anyone tell me what I'm doing wrong here? And I was getting errors. Adv Reply December 5th, 2011 #4 The Cog View Profile View Forum Posts Private Message Oh go on, throw it. I tried this and it works.

I am far from a MySQL expert, and I probably would never have figured this out without your help. i would sure appreciate some help. 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 How is the Heartbleed exploit even possible?

How do computers remember where they store things? 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 And what about "double-click"? It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.

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 This failed: source E:/jokoni/db/Banking/createTables.sql; This Worked: source E:/jokoni/db/Banking/createTables.sql (without termination, and forward slashes instead of windows' backslashes in path) share|improve this answer answered Nov 25 '15 at 5:22 livepwndz 767 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)       Any suggestions please?

Powered by vBulletin Version 4.2.2Copyright ©2000 - 2016, Jelsoft Enterprises Ltd. Join Date Dec 2007 Location chennai-TN,India Posts 42 Failed to open file 'home/Scripts/Log/42.sql', error: 2 Hi, Can some one tell why the file is failed to open? Otherwise you'll get error 2. 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

Nov 25 '10 #8 reply Message Cancel Changes Post your reply Join Now >> Sign in to post your reply or Sign up for a free account. OK, thanks again. It has been closed. Subscribing...

Can you help me? shell> mysql db_name < text_file Nov 9 '08 #6 reply P: n/a tech usr solution to this is: before logging to mysql, first change directory to the path where your batch/script Thanks. share|improve this answer answered Mar 31 at 23:10 T.

A presto. 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' The mortgage company is trying to force us to make repairs after an insurance claim How many answers does this question have? Log in / Register Sample database with test suite Overview Code Bugs Blueprints Translations Answers Missed file Bug #483154 reported by Wagner Bianchi on 2009-11-15 6 This bug affects 1 person

This gave error 22. 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 a database, the following error Reply With Quote $spacer_open $spacer_close 02-07-2008 #4 Windhan View Profile View Forum Posts Private Message View Articles Just Joined! Now it is possible I am just entering the absolute path incorrect which is where I could use some help.

Hope it works!! Join them; it only takes a minute: Sign up mysql: SOURCE error 2? All rights reserved. mysql sql sql-server netbeans share|improve this question edited Nov 7 '13 at 23:29 Darwind 4,27522137 asked Nov 7 '13 at 22:53 user2966886 1112 add a comment| 3 Answers 3 active oldest

Strange because I read in the manual that the path is supposed to default to /data/Name_of_database folder but that didn't seem to work. What is that the specific meaning of "Everyone, but everyone, will be there."? Powered by vBulletin, Copyright ©2000 - 2016, Jelsoft Enterprises Ltd. share|improve this answer edited Sep 12 '15 at 13:36 answered Jan 30 '14 at 8:00 mandza 168217 what do you mean?

i have also tried adding the full path name to the script file and get the same result. How would you help a snapping turtle cross the road? Near Earth vs Newtonian gravitational potential Sum of neighbours Sed replace specific line in file How to tell why macOS thinks that a certificate is revoked? Game of Life, a shorter story Does chilli get milder with cooking?

My CEO wants permanent access to every employee's emails. I would expect that after CREATE DATABASE XXX it would say USE DATABASE XXX.