How to do Backup and Restore on MySQL

It’s easy to do backup & restore on MySQL.
The simplest way to do it, you can use mysqldump
Here it is
To backup
go to $MYSQL_HOME/bin
#mysqldump -u username -p password -B database_name >> sqlfile.sql
To restore
- enter your mysql database
- create the database
- use the database
- source sqlfile.sql
For example :
I have employee database on mysql
My MySQLusername & password are [...]

Read Full Post »

Forget root password on MySQL

1. Shutdown your mysql database
2. Turn on your mysql db with this comman.
#safe_mysqld –skip-grant-tables &
3. Enter mysql without using password
#mysql -u root
4.Update your root’s password
#update user set password=password(‘passwd_baru’) where
user=’root’;
5. Shutdown your mysql
6. Turn on your mysql daemon
#safe_mysqld &

Read Full Post »