How to run SQL script in MySQL?

I want to execute a text file containing SQL queries, in MySQL.

I tried to run source /Desktop/test.sql and received the error:

mysql> . \home\sivakumar\Desktop\test.sql ERROR: Failed to open file ‘\home\sivakumar\Desktop\test.sql’, error: 2

Any idea on what I am doing wrong?

Related Posts:

  1. What does cmd /C mean?
  2. What does cmd /C mean?
  3. Using multiple delimiters in awk
  4. How do I import an SQL file using the command line in MySQL?
  5. How do I import an SQL file using the command line in MySQL?
  6. Mysql: Setup the format of DATETIME to ‘DD-MM-YYYY HH:MM:SS’ when creating a table
  7. How can I pass an argument to a PowerShell script?
  8. Windows 7 Symbolic Link – Cannot create a file when that file already exists
  9. How do I make a python script executable?
  10. How to edit a py file from terminal?
  11. How do you input command line arguments in IntelliJ IDEA?
  12. How can I find out if I have Xcode commandline tools installed?
  13. What is the reason for the CD /D switch in Windows cmd?
  14. phpmyadmin #1045 Cannot log in to the MySQL server. after installing mysql command line client
  15. git undo all uncommitted or unsaved changes
  16. npm install multiple package names
  17. Install oAuth PECL error: Cannot install, php_dir for channel “pecl.php.net” is not writeable by the current user
  18. How To Export/Import WordPress (MySQL) Database Properly Via Command-Line?
  19. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  20. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  21. “No such file or directory” but it exists
  22. How to use mysqli_query() in PHP?
  23. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  24. Error unable to access jarfile C:\Jar
  25. Node.js version on the command line? (not the REPL)
  26. How to pretty print XML from the command line?
  27. Unknown column in ‘field list’ error on MySQL Update query
  28. Unknown column in ‘field list’ error on MySQL Update query
  29. How to log in to phpMyAdmin with WAMP, what is the username and password?
  30. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  31. ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
  32. Column count doesn’t match value count at row 1
  33. Git is not working after macOS Update (xcrun: error: invalid active developer path (/Library/Developer/CommandLineTools)
  34. Undefined function mysql_connect()
  35. A JNI error has occurred, please check your installation and try again in Eclipse x86 Windows 8.1
  36. ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
  37. MySQL column count doesn’t match value count at row 1 [closed]
  38. MySQL string replace
  39. Git is not working after macOS Update (xcrun: error: invalid active developer path (/Library/Developer/CommandLineTools)
  40. How to find which version of TensorFlow is installed in my system?
  41. Cannot add or update a child row: a foreign key constraint fails
  42. Undefined function mysql_connect()
  43. ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
  44. Fatal error: Call to undefined function mysql_connect()
  45. String concatenation in MySQL
  46. Should I use mysqli_real_escape string() or mysql_real_escape_string() for form data?
  47. ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’
  48. What’s the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN? [duplicate]
  49. MySQL – Operand should contain 1 column(s)
  50. Can’t connect to MySQL server on ‘localhost’ (10061) after Installation
  51. MySQL “CREATE TABLE IF NOT EXISTS” -> Error 1050
  52. Cannot add or update a child row: a foreign key constraint fails
  53. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  54. MySQL Error “Operand should contain 1 column”
  55. MySQL create table if not exists and insert record only if table was created
  56. How do I copy a folder from remote to local using scp?
  57. Rename a table in MySQL
  58. Can’t connect to MySQL server on ‘localhost’ (10061) after Installation
  59. getting error HTTP Status 405 – HTTP method GET is not supported by this URL but not used `get` ever?
  60. How to use MySQL DECIMAL?
  61. Access denied for user ‘root@localhost’ (using password:NO)
  62. How should I tackle –secure-file-priv in MySQL?
  63. How do I use MySQL through XAMPP?
  64. Can’t connect to local MySQL server through socket ‘/var/mysql/mysql.sock’ (38)
  65. How to make MySQL table primary key auto increment with some prefix
  66. Access denied for user ‘root@localhost’ (using password:NO)
  67. MySQL ERROR 1290 (HY000) –secure-file-priv option
  68. How do I use properly CASE..WHEN in MySQL
  69. How do I parse command line arguments in Bash?
  70. com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
  71. Fatal error: Call to undefined function mysql_connect()
  72. error: ‘Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)’ — Missing /var/run/mysqld/mysqld.sock
  73. syntax error when using command line in python
  74. https connection using CURL from command line
  75. MySQL error 2006: mysql server has gone away
  76. Which MySQL data type to use for storing boolean values
  77. How can I do a FULL OUTER JOIN in MySQL?
  78. com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
  79. sql query with multiple where statements
  80. Fatal error: Call to undefined function mysql_connect()
  81. error: ‘Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)’ — Missing /var/run/mysqld/mysqld.sock
  82. syntax error when using command line in python
  83. How to install JQ on Mac on the command line?
  84. ERROR 2003 (HY000): Can’t connect to MySQL server on localhost (10061)
  85. MySQL query String contains
  86. ERROR 1698 (28000): Access denied for user ‘root’@’localhost’
  87. What’s the difference between VARCHAR and CHAR?
  88. Cannot delete or update a parent row: a foreign key constraint fails
  89. Cannot delete or update a parent row: a foreign key constraint fails
  90. What is the error “Every derived table must have its own alias” in MySQL?
  91. ERROR 2003 (HY000): Can’t connect to MySQL server on localhost (10061)
  92. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  93. PDOException SQLSTATE[HY000] [2002] No such file or directory
  94. Case statement in MySQL
  95. http://localhost:80 is not working on running Apache server through UniServer ZeroXIII
  96. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  97. PDOException SQLSTATE[HY000] [2002] No such file or directory
  98. MySQL server startup error ‘The server quit without updating PID file’
  99. Create an empty file on the commandline in windows (like the linux touch command)
  100. Rename a column in MySQL

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)