SQL failed to open file error 22

David Bainbridge

If you're receiving the following error on command line trying to import a SQL file, this post provides a list for likely causes...

"SQL failed to open file error 22"

  • Check you have provided the full path to your file, not a shortcut
  • Ensure the path doesn't contain spaces
  • Remove quotes from your file name

    e.g. the following will produce the 22 error:
     
    SOURCE `C:\database.sql`

    This is correct:

    SOURCE C:\database.sql

Check out this post for more information about setting up SQL on command line.

Sign Up
comments powered by Disqus

Categories

Popular Tags

Need a web developer?

If you'd like to work with code synthesis on your next project get in touch via the contact page.

Social

Projects

Active Lab Web Development

Need a developer? Get in touch.

About

Activelab.io is a web development blog for open-source technologies. Here you will find code-snippets, tutorials and posts on useful developer tools and resources.

Activelab is written by web developer David Bainbridge.

© Copyright David Bainbridge 2018. All rights reserved.