MySQL Forums
Forum List  »  General

restore database
Posted by: mmmm mmmm
Date: April 23, 2020 03:31PM

I stop the mysql service.
Renamed the directory of the database called mydb to mydb_old.
I started the mysql service.
Trying to use mysql to restore from a dump file called mydb.sql But i get the following msg.

ERROR 1050 (42S01) at line 25: Table '`mydb`.`tableclass`' already exists

Anyone has any ideas what is going on?

Options: ReplyQuote


Subject
Written By
Posted
restore database
April 23, 2020 03:31PM
April 23, 2020 05:00PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.