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.
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@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@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@lists.katipo.co.nz http://lists.katipo.co.nz/**mailman/listinfo/koha<http://lists.katipo.co.nz/mailman/listinfo/koha>
The wiki version you have here looks almost correct, except there should be no space after the "-p". That space will cause errors. Otherwise, your version means exactly the same thing. -- Sent from my Android phone with K-9 Mail. Please excuse my brevity. "clint.deckard" <clint.deckard@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@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Robin, thank you for your help. The space after the -p was the cause of the problems. Cheers, Clint. Robin Sheat wrote:
The wiki version you have here looks almost correct, except there should be no space after the "-p". That space will cause errors. Otherwise, your version means exactly the same thing. -- Sent from my Android phone with K-9 Mail. Please excuse my brevity.
"clint.deckard" <clint.deckard@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@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- This message has been scanned for viruses and dangerous content by *MailScanner* <http://www.mailscanner.info/>, and is believed to be clean.
-- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.
participants (3)
-
clint.deckard -
David Nind -
Robin Sheat