Dec
24
2009
Backup and Drop
Learn the drop first. But do this only after the backup =)
1- get into you mysql
mysql -u root -p
smash the enter key on your keyboard (if any) and you will prompted for a password. enter your password as long as it is, don’t cheat.
2. drop the database.
drop database <database_name_here>;
Done. take note that you will never found the database in thrash.
Next is the backup.
1- from terminal,
mysqldump -u root -p –database database_name_here > backup.sql
2- you will be prompted for a password.
3- a new file created, with name backup.sql
evertyhing is much easier with (eg: phpmyadmin), am i right?
