Linux Command Line Help

[drizendohs]

Hello,

I have installed Sugar with the rPath appliance on an old box we had here at the office. Everything is working as it should, but I am a newbie when it comes to Linux.

Can anyone offer a little hlep with the actual syntax I type at the bash to make a backup?

For example, I want to make a backup and I have the commands to run a mysqldump at the command line. I can get to a command line in the rPath Linux box with Putty or I can get access to the physical terminal. Where do I go from there? I don't know the actual name of my database which is necessary for the backup to take place. How do I find that from the command line?

Once I get the backup to happen with the command line mysqldump, how do I get a copy of the backup onto another machine?

Is this the type of thing that the support license would give me if I bought Sugar Network?

Thanks!

[nathanbthomas]

The database name is 'sugarcrm'. So, the dump of the db should look like this:

cd ~/
mysqldump sugarcrm > sugarcrm.sql

That will move you to the root user's home directory and produce a file called sugarcrm.sql that is your backup dump.

You can then get the dump off of the system by using scp, or secure copy. Putty should let you do that by browsing the filesystem to /root/ and you should see the sugarcrm.sql file for download.

You may want to save the /usr/share/sugarcrm/config.php file as well just as a reference of your config.

[florenceit]

i also zip the sugar directory structure with my db dump, figure it can't hurt, and its not that large. I am pretty sure that last year sometime i restorted the working copy on another linux machine by restoring these two things and it worked fine.

[drizendohs]

Awesome! This was exactly what I needed. Thanks so much.

One other thing, won't this take a dump of the data AND structure?
mysqldump sugarcrm > sugarcrm.sql

[nathanbthomas]

Yes, that should get everything. When I go to do a fresh install and import an existing sugar db (dumped the way we're talking about) this is what I do:


mysql </root/db_setup.sql
mysql sugarcrm < /root/sugarcrm.sql

db_setup.sql is a file that looks like this:

create database sugarcrm;
grant all on sugarcrm.* to 'sugarcrm'@'localhost' identified by 'changeme' with grant option;

[drizendohs]

Yes, that should get everything. When I go to do a fresh install and import an existing sugar db (dumped the way we're talking about) this is what I do:


mysql </root/db_setup.sql
mysql sugarcrm < /root/sugarcrm.sql

db_setup.sql is a file that looks like this:

create database sugarcrm;
grant all on sugarcrm.* to 'sugarcrm'@'localhost' identified by 'changeme' with grant option;

Pefrect! This was exactly what I was looking for. You're the man Nathan.

The db_setup.sql file, is this a file I create then load to the machine to run? Or is this a file i find online then transfer to the machine?

Thanks again for your help.

[nathanbthomas]

It is just a file that you can create, or of course, you can just type it all in interactively using the mysql command if you would rather.

HOWEVER- since this is an install from the rPath Appliance, there should actually be a copy of that file in /root/ on that machine since this is the script that is used to actually do the installation on the appliances.

Nathan

[drizendohs]

Yup, just checked and the file is in root. Thanks.