Joinutility seperatorLogin utility separator Infobright.com
   
 
What is the right syntax when using mysqldump with a target directory for the output?
Posted: 27 May 2009 03:38 PM   Ignore ]  
Newbie
Rank
Total Posts:  21
Joined  2009-04-10

What is the right syntax for mysql when I want the output file in a specific directory?

Profile
 
Posted: 27 May 2009 04:00 PM   Ignore ]   [ # 1 ]  
Newbie
Rank
Total Posts:  21
Joined  2009-04-10

Do I have to install mysqldump? This is the message i got when I entered mysqldum into the linux prompt.

The program ‘mysqldump’ is currently not installed.  You can install it by typing:
sudo apt-get install mysql-client-5.0
bash: mysqldump: command not found

Profile
 
Posted: 27 May 2009 04:16 PM   Ignore ]   [ # 2 ]  
Member
RankRankRank
Total Posts:  220
Joined  2008-08-18

mysqldump can also be found inside /usr/local/infobright/bin/. You can try that too.

best regards

Signature 

Mahib

Profile
 
Posted: 27 May 2009 04:18 PM   Ignore ]   [ # 3 ]  
Administrator
RankRankRank
Total Posts:  139
Joined  2008-08-18

Answer to your first question: you can specify the absolute path in the export command, like:

select * into outfile ‘/usr/local/export1.txt’ fields terminated by ‘,’ lines terminated by ‘\n’;

Profile
 
Posted: 27 May 2009 04:29 PM   Ignore ]   [ # 4 ]  
Newbie
Rank
Total Posts:  21
Joined  2009-04-10

I did not find mysqldump at /usr/local/infobright/bin/. I have no /usr/local/infobright folder

Profile
 
Posted: 27 May 2009 04:35 PM   Ignore ]   [ # 5 ]  
Member
RankRankRank
Total Posts:  220
Joined  2008-08-18

Where did you install infobright? I mentioned the default path which is /usr/local/infobright

In the infobright/bin folder you will find mysqldump.

Signature 

Mahib

Profile
 
Posted: 27 May 2009 04:40 PM   Ignore ]   [ # 6 ]  
Sr. Member
Avatar
RankRankRankRank
Total Posts:  738
Joined  2008-08-18

Try

# locate mysqldump 

This will show the mysqldump binary in the bin directory where you installed Infobright.

Then use that explicit path when using MySQL utilities.  Or add that <Infobright>/bin directory to your $PATH.

Signature 
Profile