[WNYLUG-Users] mysqldump question

Dennis Ruzeski denniruz at gmail.com
Fri Aug 12 09:42:30 EDT 2011


So to be clear- The size of your mysql data directory is 2g and the
mysqldump output is 23g?



On Fri, Aug 12, 2011 at 9:37 AM, Darin Perusich <darin at darins.net> wrote:
> This is a replicated server and the commands running on the master.
> The replication client/slave is currently off line.
>
> mysqldump -uroot -p -A > /mytmp/full-mysqldump.sql
>
> --
> Later,
> Darin
>
>
>
> On Fri, Aug 12, 2011 at 9:32 AM, Dennis Ruzeski <denniruz at gmail.com> wrote:
>> Can you post your mysqldump command line?  Is this on a replicated
>> server? If so, are you running it on the master or the slave?
>>
>> --Dennis
>>
>>
>>
>> On Fri, Aug 12, 2011 at 9:22 AM, Robert Wolfe <rwolfe at fpsoft.net> wrote:
>>> On 08/12/2011 08:37 AM, Darin Perusich wrote:
>>>>
>>>> I know this is a bit off topic but I'm hoping someone might have some
>>>> insight on this.
>>>>
>>>> I'm performing a mysqldump of a database which on disk is about 2G,
>>>> nothing special. When I perform a mysqldump of this same database the
>>>> dump file swells to over 23G is size! I know there are triggers and
>>>> stored proc's associated with this db, and what they do is anyone's
>>>> guess, and I'm thinking they are what's causing this but I really
>>>> don't know. I've never encountered this before.
>>>>
>>>> Any thoughts
>>>>
>>>> Thanks!
>>>>
>>>> --
>>>> Later,
>>>> Darin
>>>>
>>>> _______________________________________________
>>>> Users mailing list
>>>> Users at wnylug.org
>>>> http://wnylug.org/mailman/listinfo/users_wnylug.org
>>>
>>> Have you tried doing this with phpMyAdmin and see if you get the same
>>> results?
>>>
>>> _______________________________________________
>>> Users mailing list
>>> Users at wnylug.org
>>> http://wnylug.org/mailman/listinfo/users_wnylug.org
>>>
>>
>> _______________________________________________
>> Users mailing list
>> Users at wnylug.org
>> http://wnylug.org/mailman/listinfo/users_wnylug.org
>>
>
> _______________________________________________
> Users mailing list
> Users at wnylug.org
> http://wnylug.org/mailman/listinfo/users_wnylug.org
>



More information about the Users mailing list