I have an SQL Backup that has hundreds of individual databases inside of it. The backup is around 70GB in size and I have spent countless hours attempting to restore it on a new machine due to the previous one becoming corrupted.
I am currently trying to restore this by doing...
mysql -u root -p > E:\CHI.sql
As soon as I run this, the SQL backup goes to 0KB and nothing else happens. What can I do to restore this SQL Backup as this is quite urgent and I have never experienced such issues.
You are redirecting the wrong way. Your command, as written, writes stdout of the mysql process to your .sql file. Give that angle brace a 180 degree spin and give 'er another try.