[BlueOnyx:13377] Re: Recover MySql drop db

[Chris Gebhardt - VIRTBIZ Internet]

On 7/18/2013 12:36 PM, Richard C. Barker Sr. wrote:
> If I did a mysql drop like on july 14th is there a way to recover it?
> I have been looking here
> http://www.webdevstuff.com/129/mysql-drop-database-recovery.html


Hi RC,
So are you saying that you ran a mysqldump of all the databases, and now 
you're looking for a way to import that?


If you want to copy in ALL of the databases in your mysqldump file, then 
you'd give a command like this after first creating the database in 
phpMyAdmin (or MySQL CLI):
mysql -p < /path/to/dumpfile.sql


If you want to import just ONE of the databases from your alldatabases 
dump file, then you'll give something like this:
mysql -p databasename < /path/to/dumpfile.sql

In the above examples you'll want to replace "databasename" with the 
actual name of the database and "/path/to/dumpfile.sql" with the actual 
path to the location of your dump file.

Of course you want to be VERY CAREFUL because this will overwrite 
anything that already happens to be loaded into the database(s) in question.

HTH!

-- 
Chris Gebhardt
VIRTBIZ Internet Services
Access, Web Hosting, Colocation, Dedicated
www.virtbiz.com | toll-free (866) 4 VIRTBIZ