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. “No such file or directory” but it exists
  20. #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’
  21. MySQL syntax for Join Update
  22. PDO with INSERT INTO through prepared statements
  23. Simple way to calculate median with MySQL
  24. Creating a search form in PHP to search a database?
  25. Error 1046 No database Selected, how to resolve?
  26. How can I loop through all rows of a table? (MySQL)
  27. Converting PKCS#12 certificate into PEM using OpenSSL
  28. Running Command Line in Java
  29. How to create a MySQL hierarchical recursive query?
  30. mysql count duplicates
  31. Warning: mysqli_query() expects parameter 1 to be mysqli, resource given
  32. Error loading MySQLdb module: No module named ‘MySQLdb’
  33. How to stop mysqld
  34. Can I store images in MySQL 
  35. MySQL Daemon Failed to Start – centos 6
  36. How to remove index.php from WordPress site URL
  37. Is merge statement available in MySQL
  38. MySQL LIKE IN()?
  39. How do I optimize a custom post type admin page with 25,000 posts?
  40. WordPress MySQL & PHP Performance
  41. How do I delete all generated images from my server except those currently used in posts
  42. How to use update and delete query in wordpress
  43. How can I add a user through SQL?
  44. Updating User Meta with SQL Query
  45. AJAX Implementation
  46. MySQL query performed 4 times inside loop
  47. Modern Tribe Calendar wp-query with meta query not working at all
  48. WP database error for comments_popup_link()
  49. Query WordPress database by registered date and role
  50. can database and media folder be moved to a different drive?
  51. Insert all post IDs in new database table
  52. Is it possible to split database tables using HyperDB?
  53. Performance on WPMS
  54. Order by custom table and multiplication
  55. Get WooCommerce product details and transfer them to a custom DB table
  56. What is a valid parent for get_terms()?
  57. Help with WP_Query – Too many mySQL queries
  58. how would I create a custom query to get all users, and a related post based on a postmeta field?
  59. Is MariaDB’s Aria storage engine suitable for WordPress?
  60. Slow queries constantly getting stuck on WordPress database of ~100,000 posts
  61. How to translate this mySQL query to $wpdb query
  62. MySql query to get posts with all meta and terms
  63. $wpdb to insert html form information
  64. Proper usage of $wpdb->update()?
  65. Separate DB by yearly archive of WordPress
  66. WordPress running SQL query to update database from form
  67. How to fix database error duplicate entry
  68. What should a WordPress developer know about MySQL? [closed]
  69. Create a WordPress administrator without access to back-end
  70. Update MySQL query so that it functions again
  71. Why this query is not showing any result on wordpresss home page?
  72. Query posts by custom taxonomy and sort by post_modified
  73. WordPress $wpdb get posts from category and sort by custom meta
  74. Ideas how to search & replace post_content when string contains a newline?
  75. Array Formation Issue
  76. How to delete duplicate records in wp_postmeta database table?
  77. Migration problems with mysql: Operation not allowed when innodb_forced_recovery > 0 [closed]
  78. wp_usermeta – Read from database, but save function broken
  79. How to get product order by two custom taxonomy in wordpress
  80. form $_post action value gets truncated after it passes through two forms
  81. Get author posts count after excluding a category
  82. $wpdb is queried but results don’t show
  83. making php value numeric
  84. WordPress: Using the category slug get the category ID using mysql query
  85. MySQL: Possible to replace all of wp_posts.post_content(id#) via UPDATE + REPLACE + SELECT?
  86. how can we migrate wordpress 5.9 website from aws ec2 to new installed wp 5.9 oci compute
  87. Unknown column ‘wp_posts.ID’ in ‘field list
  88. Ensure SQL changes carry over
  89. when using $wpdb sudden connection rejection without changing anything. Access denied, with errors from repair tool
  90. why is my postmeta table is so heavy
  91. Error inserting into custom table – Object of class wpdb could not be converted to string [closed]
  92. Improving performance of SQL sub-queries in WordPress
  93. use mysql to replace one custom field value with another custom field value
  94. $wpdb Mysql trigger problem
  95. MYSQL Join on meta key value?
  96. Problem with a query in custom posts
  97. Predefine Magazine Style Layouts
  98. How to set variable to specific field when querying
  99. Split Million WordPress Post’s Into Multiple Database Server
  100. Batch Replace URLs in WordPress Database

Leave a Comment