[LRUG] mysqldump not working

[Kenneth Lee]

Definitely not normal, I use it everyday to restore 100MB+ dump files 
for staging environments and metrics environments.

Do you have any error messages at all?

If not I recommend testing mysqldump of a local dev database filled with 
some dummy data and check there isn't anything wrong with your local 
build/setup of MySql. You just need eliminate the obvious first, it's a 
troubleshooting game I'm afraid as I haven't had this problem before.

Ken

Riccardo Tacconi wrote:
> Hi,
>
> I know that this is not a MySql user group, but it should be the most 
> used DBMS with Rails and Ruby. I asked a question in 
> Stackoverflow.com: 
> http://stackoverflow.com/questions/2191200/mysqldump-not-restoring-data-in-mysql-5-0-19 
>
>
> The problem is that mysqldump is not restoring the database. I tried 
> to get a dump of schema and data but any table was restored. I removed 
> a trigger and two foreign keys, than, it worked. So in the end I have 
> to rebuild a database, not in one shot but in several steps, manually. 
> I have not experienced something similar with Oracle and I think 
> that's not normal.
>
> What do you think? Do you have similar problems?
>
> Regards,
>
> -- 
> 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
> ------------------------------------------------------------------------
>
> _______________________________________________
> Chat mailing list
> Chat at lists.lrug.org
> http://lists.lrug.org/listinfo.cgi/chat-lrug.org
>    
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.lrug.org/pipermail/chat-lrug.org/attachments/20100203/84b6f9d8/attachment.html>