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
-
Manage Your Business7 hours ago
TOP 10 VoIP providers for Small Business in 2024
-
Cyber Risk Management4 days ago
How Much Does a Hosting Server Cost Per User for an App?
-
Outsourcing Development4 days ago
All you need to know about Offshore Staff Augmentation
-
Software Development4 days ago
Things to consider before starting a Retail Software Development
-
Edtech7 hours ago
How to fix PII_EMAIL_788859F71F6238F53EA2 Error
-
Grow Your Business4 days ago
The Average Size of Home Office: A Perfect Workspace
-
Solution Review4 days ago
Top 10 Best Fake ID Websites [OnlyFake?]
-
Business Imprint4 days ago
How Gaming Technologies are Transforming the Entertainment Industry