[LRUG] mysqldump not working

Riccardo Tacconi rtacconi at gmail.com
Wed Feb 3 03:51:03 PST 2010


On Wed, Feb 3, 2010 at 11:28 AM, Kenneth Lee <kenfodder at gmail.com> wrote:

> I do not get any error with mysqldump, but I had two about a trigger and
>> two foreign keys with phpMyAdmin (even though I disabled the referential
>> integrity).
>>
> Sorry, I meant do you get errors in the restore command? E.g. in a shell
> command...
>
> $ mysql some_empty_database < production_dump.sql
>

That is what I tried in the dev server, my PC, in production I cannot since
I can't even create a DB.


>
> Foreign keys shouldn't cause an issue. I don't use triggers in MySql, so
> I'm not sure of the issues surrounding that currently.


When I have removed the only trigger and two foreign keys the script worked.
So it is an issue for me.


>
>  I am root of any dev or production server, the sys admin is talking about
>> scheduling an update of Mysql in developemnt, It will takes day so I get my
>> data in some ways :-(
>>
> If you're at the whim of your sys-admin, maybe they can help your
> situation. Your data should be safe in a mysqldump albeit you can't restore
> it.
>
>
sys-admins are useless and they are hiding behind helpdesk tickets. I guess
in the end they will have to do thier job. The only way to restore the db is
from the backup files :-(


> When I mean a dev machine, I mean on your local development machine try
> doing a test backup and see if you can restore it, it may just be something
> on the machine you are restoring to.
>

I get the same error with a little different version of MySql machine,
5.0.85 instead of 5.0.19.

Thanks for your help.


>
> Ken
>
> _______________________________________________
> Chat mailing list
> Chat at lists.lrug.org
> http://lists.lrug.org/listinfo.cgi/chat-lrug.org
>



-- 
Riccardo Tacconi
Web developer at Wolseley UK
VIRTUELOGIC LIMITED (Director)

http://www.linkedin.com/in/riccardotacconi
http://riccardotacconi.blogspot.com/
http://twitter.com/rtacconi
Linux user: #400461
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.lrug.org/pipermail/chat-lrug.org/attachments/20100203/94f4e2b5/attachment-0003.html>


More information about the Chat mailing list