[LRUG] mysqldump not working

[Riccardo Tacconi]

Kenneth,

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).

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 :-(

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

>  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 listChat at lists.lrug.orghttp://lists.lrug.org/listinfo.cgi/chat-lrug.org
>
>
> _______________________________________________
> 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/08369dc1/attachment-0003.html>