You should be able to do this:
mysql backup.txt
-Original Message-
From: Hathaway, Scott L [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 29, 2002 8:49 AM
To: Mysql (E-mail)
Subject: database restore - please help
I deleted my database today by mistake and I have a backup from
You wrote::
deleted my database today by mistake and I have a backup from yesterday
made as follows:
mysqldump -A backup.txt
How can I restore this database?
Thanks for your help in advance.
Scott
Do get the backup write the command
mysql databasename backup.txt
Regards
Daya Krishan
:14 AM
To: Hathaway, Scott L
Subject: Re: database restore - please help
Hi Scott,
One more simple way..u should have the mysql back ..copy the dir from
\mysql\data (Old dir ) having name of the database. Copy to the new
\mysql\data (current).
Or delete the dir having name as database name cut
