[Koha] Mysqldump and Ubuntu

[David Nind]

Hi Clint.

Both ways of entering the mysqldump command are valid and should work (at
least they do on Debian, I don't have mysql installed on my Ubuntu desktop
so can't check).

If you type man mysqldump from the command line you will get a list of
options, which will also show the shortcut way to enter the same command
e.g. instead of --user=myuser you can just go -u myuser.  This is very
convenient if you need to run the command a lot.  Most people, and lots of
tutorials, tend to use the shortcut format.

For an even quicker way you don't have to enter the space between the
shortcut command and the value e.g. -u myuser can be entered as -umyuser

In addition, you don't need to end the filename you are saving the data to
with .sql, but a lot of people do to help identify what is in the file. You
can open these files with any text editor.

There are many good MySql tutorials on the web. A couple of good tutorials
from a quick search are:
- This one looks okay:
http://www.mysqltutorial.org/how-to-backup-database-using-mysqldump.aspx
- A good basic SQL general tutorial doesn't go astray either:
http://w3schools.com/sql/default.asp


David Nind | david.nind at gmail.com
PO Box 12367, Thorndon, Wellington, New Zealand 6144
h. +64 4 9720 600 | m. +64 21 0537 847 | w. +64 4 8906 098

On 24 June 2012 13:55, clint.deckard <clint.deckard at frontiers.co.nz> wrote:

> Kia ora,
> I have spent a good deal of time getting mysqldump to work for me, partly
> because I am not an expert. Finally, I found out that Ubuntu (I installed
> this instance from KohaLiveCD) requires the format
> mysqldump --user=myuser --password=mypassword koha>mysql_backup.sql
>
> this differs from the example in the wiki
> mysqldump -u myuser -p mypassword koha > mydatadump.sql
>
> I thought I'd add this knowledge to the wiki but then thought perhaps I
> should check  on this list first in case I make a fool of myself (again).
>
> Comments anyone?
>
> Clint.
>
>
> --
> This message has been scanned for viruses and dangerous content by
> MailScanner, and is believed to be clean.
>
> ______________________________**_________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/**mailman/listinfo/koha<http://lists.katipo.co.nz/mailman/listinfo/koha>
>