[GRLUG] sugarcrm/mysql issue

Bill Pribble Bill.Pribble at Haworth.com
Fri Jun 3 16:04:49 EDT 2011


If you are already running mysql, you can execute an SQL script file using the source command or \. command: 
mysql> source file_name
mysql> \. file_name

-----Original Message-----
From: grlug-bounces at grlug.org [mailto:grlug-bounces at grlug.org] On Behalf Of Bill Pribble
Sent: Friday, June 03, 2011 4:01 PM
To: Mailing List for LUG in greater Grand Rapids, MI area.
Subject: Re: [GRLUG] sugarcrm/mysql issue

In Oracle you have to put a '@' in front of a script you want to run from a file

Example

> @/home/eric/Desktop/sugar_mysql_backup.sql

Maybe same in mysql

-----Original Message-----
From: grlug-bounces at grlug.org [mailto:grlug-bounces at grlug.org] On Behalf Of Ben Rousch
Sent: Friday, June 03, 2011 3:48 PM
To: Mailing List for LUG in greater Grand Rapids, MI area.
Subject: Re: [GRLUG] sugarcrm/mysql issue

Assuming you have execute rights, try ./mysql and ./mysqldump

On Fri, Jun 3, 2011 at 3:37 PM, Eric Beversluis
<ebever at researchintegration.org> wrote:
> We've got Sugarcrm running on a SLES box. I"m trying to do a backup of
> the mysql DB and running into this problem:
>
> As root, I navigate to /opt/<sugarfolder>/mysql/bin, where I see the
> list of all the mysql commands, including 'mysql' and 'mysqldump'. But
> when I try either of these, I get the 'command unknown' response.
>
> mysql -u root -p
> or
> mysqldump -u root -p sugarcrm
>> /home/eric/Desktop/sugar_mysql_backup.sql
>
> I think I've used both of those commands successfully with other mysql
> settings.
>
> Any ideas or insights?
>
> Thanks.
>
>
>
>
> --
> This message has been scanned for viruses and
> dangerous content by MailScanner, and is
> believed to be clean.
>
> _______________________________________________
> grlug mailing list
> grlug at grlug.org
> http://shinobu.grlug.org/cgi-bin/mailman/listinfo/grlug
>



-- 
 Ben Rousch
   brousch at gmail.com
   http://clusterbleep.net/

-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

_______________________________________________
grlug mailing list
grlug at grlug.org
http://shinobu.grlug.org/cgi-bin/mailman/listinfo/grlug

-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

_______________________________________________
grlug mailing list
grlug at grlug.org
http://shinobu.grlug.org/cgi-bin/mailman/listinfo/grlug

-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.



More information about the grlug mailing list