mysql: SOURCE error 2?

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.

Related Posts:

  1. MySQL error 2006: mysql server has gone away
  2. “INSERT IGNORE” vs “INSERT … ON DUPLICATE KEY UPDATE”
  3. Cannot delete or update a parent row: a foreign key constraint fails
  4. #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’
  5. PHP Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP
  6. what does “/index.php?admin/admin_dashboard” in my url mean
  7. How to join two tables by multiple columns in SQL?
  8. How to get size of mysql database?
  9. SQL – Update multiple records in one query
  10. MySQL Error 1093 – Can’t specify target table for update in FROM clause
  11. MySQL: Invalid use of group function
  12. mysqladmin: connect to server at ‘localhost’ failed
  13. mysql update multiple columns with same now()
  14. Usage of MySQL’s “IF EXISTS”
  15. Simple Random Samples from a Sql database
  16. What does SQL clause “GROUP BY 1” mean?
  17. LAST_INSERT_ID() MySQL
  18. MySQL foreach loop
  19. SQL select only rows with max value on a column
  20. Trying to perform MINUS operation in MySQL
  21. How do I find which transaction is causing a “Waiting for table metadata lock” state?
  22. mysql count duplicates
  23. phpmyadmin #1045 Cannot log in to the MySQL server. after installing mysql command line client
  24. MySQL config file location – redhat linux server
  25. How to change collation of database, table, column?
  26. Create boolean column in MySQL with false as default value?
  27. Is there a naming convention for MySQL?
  28. How to get the max of two values in MySQL?
  29. Error Code 1292 – Truncated incorrect DOUBLE value – Mysql
  30. MySql – HAVING vs WHERE 
  31. How to stop mysqld
  32. Is merge statement available in MySQL
  33. GROUP_CONCAT comma separator – MySQL
  34. Set page template for all pages?
  35. How to log mysql errors from wordpress core?
  36. Optimize Multiple Taxonomy Term MySQL Query?
  37. WordPress MySQL & PHP Performance
  38. What specific database privileges does WordPress need?
  39. Using source control with WordPress
  40. My WordPress site always displays a cached version of its homepage
  41. wpdb Custom Meta Data with 2 conditions
  42. Updating User Meta with SQL Query
  43. wpdb prepare syntax
  44. How to run this SQL query of wp_terms database
  45. Proper way to work with wpdb to get user’s firstname
  46. How to change post format from Aside to Image for all posts?
  47. Inserting Hundreds of Thousands of Posts at Once
  48. wp_admin edit.php slow with lots of queries
  49. How to add and SQL query of posts only published
  50. Slow Mysql Queries
  51. can database and media folder be moved to a different drive?
  52. Find duplicate posts with same slug and author
  53. How to Create a Admin User for A WordPress Site via MySQL (PHPMyAdmin)?
  54. Rewrite database urls
  55. writing inner join in wpdb
  56. How to get data from WordPress site sql file
  57. Unknown collation when I import a dump from an existing site into a development database?
  58. PHP script can’t connect to Database on port 3307
  59. WordPress with php5-fpm and nginx
  60. Migrating from Existing MySQL Setup to WordPress
  61. When WordPress Default table, Echo Success. When Plugin Table, Echo Blank
  62. How to translate this mySQL query to $wpdb query
  63. $wpdb to insert html form information
  64. Proper usage of $wpdb->update()?
  65. MySQL 5.5 upgrade ‘broke’ WordPress [closed]
  66. Separate DB by yearly archive of WordPress
  67. What should a WordPress developer know about MySQL? [closed]
  68. Copyright: Get first and last date of post type
  69. Update MySQL query so that it functions again
  70. Query posts by custom taxonomy and sort by post_modified
  71. WordPress $wpdb get posts from category and sort by custom meta
  72. Array Formation Issue
  73. How can I write a formal sql query to get data from a custom table
  74. Migration problems with mysql: Operation not allowed when innodb_forced_recovery > 0 [closed]
  75. WordPress $wpdb no result
  76. How can I view my site directly from WordPress dashboard?
  77. Word Press and database from another server sync
  78. when using $wpdb sudden connection rejection without changing anything. Access denied, with errors from repair tool
  79. edit_user_created_user hook – using to update Groups
  80. Changes not being reflected on new server
  81. Mysql Error in querying form entries in Gravity Form plugin
  82. WordPress database error Duplicate entry for key ‘slug’
  83. Improving performance of SQL sub-queries in WordPress
  84. MySQL – How to combine data from two tables into one?
  85. Saving custom term value to the database in new table
  86. Stop my loop to register data twice
  87. MySQL errors after a WordPress clone
  88. How to restore: Database intact but folders deleted
  89. XML RPC post produces immediate revision with odd post_date_gmt
  90. MYSQL Join on meta key value?
  91. Woocommerce: Grab total revenue of a product over all orders
  92. Complicated MySQL Query
  93. problem with quotes on new post
  94. SQL Database Lost
  95. Initialization of table in database using ‘CREATE … IF NOT EXISTS’
  96. mysqldump throws: Unknown table ‘COLUMN_STATISTICS’ in information_schema (1109)
  97. How do I load a sql.gz file to my database? (importing)
  98. How to find source of these strange SQL queries?
  99. Batch Replace URLs in WordPress Database
  100. How to reduce uncached page generation time?

Leave a Comment

tech