|
Home > Archive > MySQL ODBC Connector > February 2006 > mysqldump command
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Reynier Perez Mira 2006-02-21, 3:23 am |
| I try to create a cron in Linux (Debian Sarge) and the content for this =
cron is a mysql database backup. I read documentation about mysqldump =
command and use, but I forgot something because it not works for me. I =
put this in bash:
# mysqldump --opt -c -C dp > /var/tmp_save/dproject.sql
But when I open .sql file none INSERT statement was added. Is wrong my =
command or ...
Regards,=20
--=20
ReynierPM=20
4to. Ing. Inform=E1tica=20
Linux User: #310201
El programador superh=E9roe aprende de compartir sus conocimientos. Es =
el referente de sus compa=F1eros. Todo el mundo va a preguntarle y =E9l, =
secretamente, lo fomenta porque es as=ED como adquiere su legendaria =
sabidur=EDa: escuchando ayudando a los dem=E1s...=20
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw
| |
| sheeri kritzer 2006-02-25, 9:43 am |
| I'm assuming you're doing this as root (hence the # sign).
The way to debug this, as with any script, is to run it manually on
the command line and see what errors you get. So if you run the
following, what happens?
mysqldump --opt -c -C dp > /var/tmp_save/dproject.sql
(not sure if you ran that on the command line, or through cron).
mysqldump --opt -c -C dp
One of these should give you an error. I'd guess that you need to
specify a username and password, since you haven't specifically said
you'd set them in a .my.cnf.
-Sheeri
On 2/20/06, Reynier Perez Mira <rperezm@estudiantes.uci.cu> wrote:
> I try to create a cron in Linux (Debian Sarge) and the content for this c=
ron is a mysql database backup. I read documentation about mysqldump comman=
d and use, but I forgot something because it not works for me. I put this i=
n bash:
> # mysqldump --opt -c -C dp > /var/tmp_save/dproject.sql
> But when I open .sql file none INSERT statement was added. Is wrong my co=
mmand or ...
> Regards,
> --
> ReynierPM
> 4to. Ing. Inform=E1tica
> Linux User: #310201
> El programador superh=E9roe aprende de compartir sus conocimientos. Es el=
referente de sus compa=F1eros. Todo el mundo va a preguntarle y =E9l, secr=
etamente, lo fomenta porque es as=ED como adquiere su legendaria sabidur=ED=
a: escuchando ayudando a los dem=E1s...
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql? unsub...mail
.com
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw
|
|
|
|
|