"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.
mysql -u -p DBNAME > [Path of .sql file]
mysqldump -u -p DBNAME >pathof.sql
#and then:
mysql -u -p DBNAME <pathof.sql
From novice to tech pro — start learning today.
You redirected the output of MySQL over the SQL file.
Looks like you should have used "<" instead of ">". If you didn't create a backup of the .sql file before running that MySQL command then I'm afraid it is gone. Check with your System Administrator to see if they are running some form of file versioning on that folder that might save copies of older versions in the background for you.
Confirm that is the command you executed.