How do I access the mysql database underneath jasperserver?

[itchytoes]

Hi --

This is probably a silly question, but how do I access the underlying mysql database?

I want to be able to back it up and restore.

I can type mysql --socket=/home..../jasperserver400/mysql/tmp/mysql.sock and get into mysql, but I don't see any jasperserver database there when I type "show databases"

Do I have to be a particular user?

 

Thanks

 

Betty

 

[jgh]

connect to the system running your mysql database with a mysql client, and you should be able to run anything you like to manage the database.

 

[itchytoes]

I have no trouble connecting to the the mysql server just running mysql client, but when I type "show databases" I don't see the jasperserver database.

I'm just wondering what I'm missing as far as any command line options to connect to the mysql database server

Also, what user do I run mysql as?  In other words do I need mysql -u option?  I've tried root and that does not connect.

I'm using the bundled mysql,  and I see that login and password is jasperdb/password, but that does not connect either

If I leave -u out, it connects, but I don't see the databases.

 

I see the database in the 'datadir' folder as specified in the my.conf file

 

Thanks

Betty

Post Edited by itchytoes at 05/31/2011 18:13

Post Edited by itchytoes at 05/31/2011 18:21

[itchytoes]

HURRAY! I sorted it out. I have to use jasperdb/password, but when I type "mysql" I have to type it as -ujasperdb -ppassword I had spaces and it kept doing odd things with prompting me and such