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....
Showing posts with label database. Show all posts
Showing posts with label database. Show all 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...
-
Got to know this is how command line looping is used: while [ 1 ] do ls -al ; sleep 60 done Applying this to stress command...