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:
- What does cmd /C mean?
- What does cmd /C mean?
- Using multiple delimiters in awk
- How do I import an SQL file using the command line in MySQL?
- How do I import an SQL file using the command line in MySQL?
- Mysql: Setup the format of DATETIME to ‘DD-MM-YYYY HH:MM:SS’ when creating a table
- How can I pass an argument to a PowerShell script?
- Windows 7 Symbolic Link – Cannot create a file when that file already exists
- How do I make a python script executable?
- How to edit a py file from terminal?
- How do you input command line arguments in IntelliJ IDEA?
- How can I find out if I have Xcode commandline tools installed?
- What is the reason for the CD /D switch in Windows cmd?
- phpmyadmin #1045 Cannot log in to the MySQL server. after installing mysql command line client
- git undo all uncommitted or unsaved changes
- npm install multiple package names
- Install oAuth PECL error: Cannot install, php_dir for channel “pecl.php.net” is not writeable by the current user
- How To Export/Import WordPress (MySQL) Database Properly Via Command-Line?
- “No such file or directory” but it exists
- #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’
- MySQL syntax for Join Update
- PDO with INSERT INTO through prepared statements
- Simple way to calculate median with MySQL
- Creating a search form in PHP to search a database?
- Error 1046 No database Selected, how to resolve?
- How can I loop through all rows of a table? (MySQL)
- Converting PKCS#12 certificate into PEM using OpenSSL
- Running Command Line in Java
- How to create a MySQL hierarchical recursive query?
- mysql count duplicates
- Warning: mysqli_query() expects parameter 1 to be mysqli, resource given
- Error loading MySQLdb module: No module named ‘MySQLdb’
- How to stop mysqld
- Can I store images in MySQL
- MySQL Daemon Failed to Start – centos 6
- How to remove index.php from WordPress site URL
- Is merge statement available in MySQL
- MySQL LIKE IN()?
- How do I optimize a custom post type admin page with 25,000 posts?
- WordPress MySQL & PHP Performance
- How do I delete all generated images from my server except those currently used in posts
- How to use update and delete query in wordpress
- How can I add a user through SQL?
- Updating User Meta with SQL Query
- AJAX Implementation
- MySQL query performed 4 times inside loop
- Modern Tribe Calendar wp-query with meta query not working at all
- WP database error for comments_popup_link()
- Query WordPress database by registered date and role
- can database and media folder be moved to a different drive?
- Insert all post IDs in new database table
- Is it possible to split database tables using HyperDB?
- Performance on WPMS
- Order by custom table and multiplication
- Get WooCommerce product details and transfer them to a custom DB table
- What is a valid parent for get_terms()?
- Help with WP_Query – Too many mySQL queries
- how would I create a custom query to get all users, and a related post based on a postmeta field?
- Is MariaDB’s Aria storage engine suitable for WordPress?
- Slow queries constantly getting stuck on WordPress database of ~100,000 posts
- How to translate this mySQL query to $wpdb query
- MySql query to get posts with all meta and terms
- $wpdb to insert html form information
- Proper usage of $wpdb->update()?
- Separate DB by yearly archive of WordPress
- WordPress running SQL query to update database from form
- How to fix database error duplicate entry
- What should a WordPress developer know about MySQL? [closed]
- Create a WordPress administrator without access to back-end
- Update MySQL query so that it functions again
- Why this query is not showing any result on wordpresss home page?
- Query posts by custom taxonomy and sort by post_modified
- WordPress $wpdb get posts from category and sort by custom meta
- Ideas how to search & replace post_content when string contains a newline?
- Array Formation Issue
- How to delete duplicate records in wp_postmeta database table?
- Migration problems with mysql: Operation not allowed when innodb_forced_recovery > 0 [closed]
- wp_usermeta – Read from database, but save function broken
- How to get product order by two custom taxonomy in wordpress
- form $_post action value gets truncated after it passes through two forms
- Get author posts count after excluding a category
- $wpdb is queried but results don’t show
- making php value numeric
- WordPress: Using the category slug get the category ID using mysql query
- MySQL: Possible to replace all of wp_posts.post_content(id#) via UPDATE + REPLACE + SELECT?
- how can we migrate wordpress 5.9 website from aws ec2 to new installed wp 5.9 oci compute
- Unknown column ‘wp_posts.ID’ in ‘field list
- Ensure SQL changes carry over
- when using $wpdb sudden connection rejection without changing anything. Access denied, with errors from repair tool
- why is my postmeta table is so heavy
- Error inserting into custom table – Object of class wpdb could not be converted to string [closed]
- Improving performance of SQL sub-queries in WordPress
- use mysql to replace one custom field value with another custom field value
- $wpdb Mysql trigger problem
- MYSQL Join on meta key value?
- Problem with a query in custom posts
- Predefine Magazine Style Layouts
- How to set variable to specific field when querying
- Split Million WordPress Post’s Into Multiple Database Server
- Batch Replace URLs in WordPress Database