News
Dump a specific table or few rows in MySQL
The ‘mysqldump’ command is used to dump databases managed by MySQL. Let’s consider three the most useful cases of MySQL database dumping.
1. The simplest case is the whole database dumping:
mysqldump -u username -ppassword database_name > the_whole_database_dump.sql
2. Sometimes, there’s a need to dump a single table from your database. You can do it in the next way:
mysqldump -u username -ppassword database_name table_name > single_table_dump.sql
You can also specify several tables separated by whitespace to dump these tables only.
3. If you want to dump only rows that meet a specific criteria, you can add ‘where’ option to your mysqldump command. For example, dump only rows where date_created is today:
mysqldump -u username -ppassword database_name table_name --where="date_created='2013-06-25'" > few_rows_dump.sql
-
Marketing Tips2 days ago
What is my Instagram URL? How to Find & Copy Address [Guide on Desktop or Mobile]
-
Business Imprint3 days ago
About Apple Employee and Friends&Family Discount in 2024
-
App Development3 days ago
How to Unlist your Phone Number from GetContact
-
News4 days ago
Open-Source GPT-3/4 LLM Alternatives to Try in 2024
-
Crawling and Scraping4 days ago
Comparison of Open Source Web Crawlers for Data Mining and Web Scraping: Pros&Cons
-
Grow Your Business2 days ago
Best Instagram-like Apps and their Features
-
Grow Your Business4 days ago
How to Become a Prompt Engineer in 2024
-
Marketing Tips2 days ago
B2B Instagram Statistics in 2024