| Gleb Paharenko 2005-08-29, 11:23 am |
| Hello.
>Has anyone else had similar problems? Can anyone shed some light on how
>to successfully back up this database?
Have a look here:
http://dev.mysql.com/doc/mysql/en/gone-away.html
>Hello
>
>I am using mysqldump to backup my entire database (about 40GB total)
>each night. I dump each table separetly, so that if mysqldump crashes
>in the middle somewhere, the rest of the database still gets backed up.
>
>Most of the tables are fairly small. About 20GB of the database is
>spread across more than a hundred tables. However, one table is very
>large - it accounts for the other 20GB of the dataset.
>
>When backing up this table, I get this error message every night:
>
>/usr/local/bin/mysqldump: Error 2013: Lost connection to MySQL server
>during query when dumping table `DocumentVariants` at row: 13456
>
>The table actually has 94,916 rows in it. There are no entries in the
>mySQL server log and nothing in /var/log/messages. There is plenty of
>disk space available on the backup drive. The file is about 4.5GB when
>this happens, which is about 1/5 of the total table size. The table
>itself contains a lot of binary data in a longblob field, in case that
>makes any difference. wait_timeout on my server is set to 86400, and
>the whole backup takes less than an hour, so the timeout is not the
>problem.
>
>Has anyone else had similar problems? Can anyone shed some light on how
>to successfully back up this database?
>
>Thanks!
"Gustafson, Tim" <tjg@meitech.com> wrote:
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenko@ensita.net
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.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
|