Welcome Guest. Please Login or Register  


You are here: Index > AMPPS > General Support > Topic : Mysqldump and running a shell command on Mac



Threaded Mode | Print  

 Mysqldump and running a shell command on Mac (1 Replies, Read 8209 times)
Sarak
Group: Member
Post Group: Newbie
Posts: 1
Status:
Hi,
I use AMPPS on a Mac OSX 10.9.2. I want to run the below command in the terminal in order to get the backup of a few tables where id is greater than 500. However, it's not working and I'm getting the -bash: mysqldump: command not found error. Could you please let me know how to add the full pathname to mysqldump command or if your other solutions for this problem. Here is the command:

mysqldump -u username -p password database1 table1 table3 table4 --where='`id`>=500'  | gzip > /tmp/dumptables.sql.gz


Your help is highly appreciated.
IP: --   

Mysqldump and running a shell command on Mac
tidus
Group: Member
Post Group: Super Member
Posts: 1121
Status:
Hi,

Full path to mysqldump:

/Applications/AMPPS/mysql/bin/mysqldump


-----------------------
Follow AMPPS on,
Twitter : https://twitter.com/AMPPS_Stack
Facebook :  http://www.facebook.com/softaculousampps
Google+ : https://plus.google.com/+AmppsStack
IP: --   

« Previous    Next »

Threaded Mode | Print  



Jump To :


Users viewing this topic
1 guests, 0 users.


All times are GMT. The time now is April 28, 2024, 5:05 pm.

  Powered By AEF 1.0.8 © 2007-2008 Electron Inc.Queries: 11  |  Page Created In:0.039