Lost root password and. . .

[historicslunk]

Help

I am very embarrassed, I have lost my root password to login to my rpath sugarcrm appliance. Also I managed to delete root@localhost from my mysql permissions table. I have trawled through thousands of posts has anyone any bright ideas.

I need to take a backup of sugarcrm and I can't

[kpit]

Well the quick and safe way is to use the sugarcrm username and password that will allow you to backup the sugarcrm database.

[historicslunk]

Thanks for the quick reply but I am not sure I get the idea?

I have performed a sugar backup (of the files) but how do I backup the db

S

[kpit]

to get the password sugarCRM uses you can look for config.php in the sugar directory. look in the file you will find the database username and password that sugarcrm uses to access your database. then use that username and password to backup the sugarcrm database.

[historicslunk]

Just for anyone else who gets the same problem . . . . .

Ok first reboot (very important - do not allow the server to autostart)

1) hit the e - for edit
2) Highlight line 2 and hit e - for edit again
3) at the end of the line add the word " single" without the quotes but make sure there is a space between quiete and your addition
4) Hit enter
5) Hit b - boot

when the system lands you at the prompt - not much is loaded and the whole "system" is ready to roll!! now find the mysql db files. they end in .MYD .MYI .frm

1) type su
2) type updatedb
3) locate sugarcrm

you are looking for a path similar to below . . . .

4) You can copy the files from /srv/mysql/sugarcrm - with cp -fr <source> <destination>
5) repeat above looking for the php files

We added a second HDD to the server and mounted it to /mnt/backup, copied the files to it - disconnected the main HDD added a new one rebuilt the server from cd and then reversed the above process - it worked like a dream.

6) once the data is back - run all the repairs and you are working

Sharif
The Computer Help Co
http://www.gimmehelp.com

[mycrmspacegunnar]

Hi,

to backup your sugar mysql database use the following line

mysqldump -udbusername -p dbname > backup.sql

Replace "dbusername" with the database username
And replace "dbname" with the databasename
You will be prompted for your database password.

You can find your dbusername, and dbname in your sugar config file.
The config file is called "config.php" the setting are aorund line 30 and will look somewhat liek this:

'db_host_instance' => '',
'db_user_name' => 'dbuser',
'db_password' => 'secretpass',
'db_name' => 'sugarcrm',
'db_type' => 'mysql'


Cheers
Gunnar