Can I restore a single table from a full mysql mysqldump file?

by

You can try to use sed in order to extract only the table you want.

Let say the name of your table is mytable and the file mysql.dump is the file containing your huge dump:

$ sed -n -e '/CREATE TABLE.*`mytable`/,/Table structure for table/p' mysql.dump > mytable.dump

This will copy in the file mytable.dump what is located between CREATE TABLE mytable and the next CREATE TABLE corresponding to the next table.

You can then adjust the file mytable.dump which contains the structure of the table mytable, and the data (a list of INSERT).

More Related Contents:

  1. Restoring MySQL database from physical files
  2. How to take backup of a single table in a MySQL database?
  3. Speeding up mysql dumps and imports [closed]
  4. Dump a mysql database to a plaintext (CSV) backup from the command line
  5. What is the best way to do incremental backups in MySQL?
  6. How to import a SQL Server .bak file into MySQL?
  7. SQL select only rows with max value on a column [duplicate]
  8. What is the error “Every derived table must have its own alias” in MySQL?
  9. Generating Depth based tree from Hierarchical Data in MySQL (no CTEs)
  10. Authentication plugin ‘caching_sha2_password’ cannot be loaded
  11. How to grant remote access permissions to mysql server for user?
  12. mySQL convert varchar to date
  13. Generating a series of dates [duplicate]
  14. MySQL error code: 1175 during UPDATE in MySQL Workbench
  15. Can a table field contain a hyphen?
  16. Select mysql query between date?
  17. MySQL maximum memory usage
  18. MySQL JOIN the most recent row only?
  19. What does SQL clause “GROUP BY 1” mean?
  20. Bogus foreign key constraint fail
  21. INSERT … ON DUPLICATE KEY UPDATE with WHERE?
  22. Syntax error when using except in a query
  23. Easiest way to copy a table from one database to another?
  24. Using index, using temporary, using filesort – how to fix this?
  25. sql like operator on integer
  26. How to make a primary key start from 1000?
  27. MySQL – SELECT * INTO OUTFILE LOCAL ?
  28. The best way to remove value from SET field?
  29. Strip last two characters of a column in MySQL
  30. MySQL cartesian product between two SELECT statements

Leave a Comment