So, my site got messed up due to DDoS attack due to which I had to uninstall and install MYSQL again. I found that it isn’t wordpress database and the backup which I have is corrupted one and another backup which I have is from March’22. But now my backup is in .sql while it needs .ibd format so I can’t transfer these backup directly from SFTP.
I tried doing it from CLI using following statement:
mysql -u your_database_user -p wordpress -h localhost < your_backup_file.sql
and this was the output:
$ mysql -u root -p wordpress -h localhost < db.sql -bash: db.sql: No such file or directory $ mysql -u root -p wordpress < db.sql -bash: db.sql: No such file or directory $ mysql -u root -p wordpress -h localhost < /var/lib/mysql/db.sql Enter password:
So, after entering the password isn’t showing any output. I’m using droplet’s root password. Or do I need to use the db_password from wp-config file?
I also did this in a new droplet but I’m getting same error for the transferring database.
In 1 case I the data was transferred but I got this on homepage
There has been a critical error on this website.
Please help me out
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.