How to recover just deleted rows in mysql?

by

There is another solution, if you have binary logs active on your server you can use mysqlbinlog

generate a sql file with it

mysqlbinlog binary_log_file > query_log.sql

then search for your missing rows.
If you don’t have it active, no other solution. Make backups next time.

More Related Contents:

  1. Which DB technology is sued to solve the following search issue? [closed]
  2. MyISAM versus InnoDB [closed]
  3. Compare two MySQL databases [closed]
  4. How should I resolve –secure-file-priv in MySQL?
  5. What does character set and collation mean exactly?
  6. What’s faster, SELECT DISTINCT or GROUP BY in MySQL?
  7. Storing image in database directly or as base64 data?
  8. Implementation of Levenshtein distance for mysql/fuzzy search?
  9. Does MySQL index foreign key columns automatically?
  10. What’s the difference between MyISAM and InnoDB? [duplicate]
  11. Is there an ANSI SQL alternative to the MYSQL LIMIT keyword?
  12. In SQL, is it OK for two tables to refer to each other?
  13. Hyphens in column names in MySQL DB
  14. Error Code: 1215. Cannot add foreign key constraint (foreign keys)
  15. Modeling Product Variants
  16. How to increase MySQL connections(max_connections)?
  17. MySql views performance [closed]
  18. MySQL: LAST_INSERT_ID() returns 0
  19. How does MySQL Auto Increment work?
  20. Calculating a Moving Average MySQL?
  21. How to get size of mysql database?
  22. Can I launch a trigger on select statement in mysql?
  23. How do you write a case insensitive query for both MySQL and Postgres?
  24. Strings as Primary Keys in MYSQL Database [closed]
  25. MySQL : ERROR 1215 (HY000): Cannot add foreign key constraint
  26. How do I alter a mysql table column defaults?
  27. Selecting distinct 2 columns combination in mysql
  28. How to store a one to many relation in MySQL database?
  29. MySQL – Complexity of: SELECT COUNT(*) FROM MyTable;
  30. MySQL and PDO: Could PDO::lastInsertId theoretically fail?

Leave a Comment