1. Create backup
$ mysqldump -u root -proot regdb > /home/yumani/Documents/regdb_back.sql
2. Restore
Create a database in mysql and the grant user access
mysql > create database regdb;
mysql > grant all on regdb.* to wso2bam@'%' identified by 'wso2bam';
$ mysql -u root -proot regdb < /home/yumani/Documents/regdb_back.sql
A place where I keep a note of simple but useful technical tips and memorable posts....
Monday, November 1, 2010
Subscribe to:
Posts (Atom)
-
1. Download Derby bin distribution from here . 2. Extract it. 3. Set DERBY_HOME and add it to the path. vi ~/.bashrc Add as below; e...
-
ssh user@host lets you to access a unix machine in command line mode. But if you need to access its UI, you need to access the graphical...