There is another solution, if you have binary logs active on your server you can use
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.
- ‘IF’ in ‘SELECT’ statement – choose output value based on column values
- Authentication plugin ‘caching_sha2_password’ cannot be loaded
- 1052: Column ‘id’ in field list is ambiguous
- MySQL Error: : ‘Access denied for user ‘root’@’localhost’
- How do I quickly rename a MySQL database (change schema name)?
- Throw an error preventing a table update in a MySQL trigger
- What does character set and collation mean exactly?
- Is there a MySQL option/feature to track history of changes to records?
- How to shrink/purge ibdata1 file in MySQL
- Implementing Comments and Likes in database
- Does MySQL ignore null values on unique constraints?
- Does MySQL index foreign key columns automatically?
- Maximum length for MySQL type text
- Error creating table: You have an error in your SQL syntax near ‘order( order_id INT UNSIGNED NOT NULL AUTO_INCREMENT, user_id ‘ at line 1 [duplicate]
- MySQL Query to select data from last week?
- Using an Alias in SQL Calculations
- Select last N rows from MySQL
- Adding a leading zero to some values in column in MySQL
- mySQL – Create a New Table Using Data and Columns from Three Tables
- How can I modify the size of column in a MySQL table?
- Is there an SQLite equivalent to MySQL’s DESCRIBE [table]?
- MySQL query, MAX() + GROUP BY
- When to use MyISAM and InnoDB? [duplicate]
- MySQL InnoDB foreign key between different databases
- Import SQL file into mysql
- Mysql database sync between two databases
- MySQL: Cloning a MySQL database on the same MySql instance
- How to increase MySQL connections(max_connections)?
- What’s the best database structure to keep multilingual data? [duplicate]
- What’s the best way to migrate a Django DB from SQLite to MySQL?
- How do I rename a MySQL database (change schema name)?
- Export a MySQL Database to SQLite Database
- Calculating a Moving Average MySQL?
- Check for x consecutive days – given timestamps in database
- How to display open transactions in MySQL
- Does mysql have the equivalent of Oracle’s “analytic functions”?
- DOs and DONTs for Indexes [closed]
- How to skip certain database tables with mysqldump?
- “where 1=1” statement [duplicate]
- MySql views performance [closed]
- How to insert a file in MySQL database?
- How to connect to MySQL from the command line
- How to find out the MySQL root password
- What are the differences between the BLOB and TEXT datatypes in MySQL?
- MySQL : ERROR 1215 (HY000): Cannot add foreign key constraint
- How to set a MySQL row to READ-ONLY?
- How does MySQL Auto Increment work?
- What is the difference between SQL and MySQL? [closed]
- Optimistic locking in MySQL
- Strings as Primary Keys in MYSQL Database [closed]