On Thu 2006-05-04 (10:04), DongInn Kim wrote: > Hi Bruce, > Can you access the "oscar" database with the "oscar" user? If so, you > can dump the "oscar" database with the following: > mysqldump -u oscar -p --databases oscar > oscar.sql > You need to input the password from your /etc/odapw.
hi, yep we can access oscar as oscar with the password from /etc/odapw > BTW, do you need to restore the other databases with the root account? > MySQL setup on the OSCAR cluster does not have a root password and > also the anonymous access is allowed too unless you have changed the > configuration of MySQL on your OSCAR cluster. the problem is the root account now has a password, and the oscar scripts assume no password. so i imagine either we figure out how to drop this password, or reinstall mysql, while dumping the exisiting 3 databases (accounting, mysql, and oscar) as you say. > So, I believe that mysqldump from the root account (without password) > should work if you have not touched/setup MySQL of OSCAR manually. > But it looks like that you have installed MySQL and setup its root > password before you install OSCAR or you have setup MySQL manually > after OSCAR installation. yeah mysql got installed by oscar. some time afterwards passwords were changed and added. ------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Oscar-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/oscar-users
