Re: mysqldump file fails to load

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



On Tue, November 27, 2012 3:53 pm, Rob Kampen wrote:
<snip>
> I have a newly developed app that has some 30+ tables, most with few
> records at this time. However, it does contain a streets table with some
> 43K records.
>
> I regularly dump the database using
>  >mysqldump -u rkampen -p databasename >databasenamedatetime.sql
>
> and load it onto other machines via
>
> mysql -u rkampen -p -D databasename <databasenamedatetime.sql
>
<snip>
>
> Now I am needing to load this database file onto a debian host running
> Plesk 9.5.4 via their system admin and it is unreliable - after four
> attempts we have all except the streets table loaded - but this table
> will not load.

Rob,

I have experienced a similar problem a few months back between two different versions of mySQL,
both running on CentOS 5.  The problem was caused by mysqldump writing a bad CREATE TABLE
statement into the dump file for one of the tables.  More specifically, one column had to small of
a size allocated to it (and definitely different than what was in the originating database) so the
import kept failing because UTF-8 characters could not fit into it.  Manually fixing the size in
the dump file took care of the problem.

Marko
_______________________________________________
CentOS mailing list
CentOS@xxxxxxxxxx
http://lists.centos.org/mailman/listinfo/centos


[Index of Archives]     [CentOS]     [CentOS Announce]     [CentOS Development]     [CentOS ARM Devel]     [CentOS Docs]     [CentOS Virtualization]     [Carrier Grade Linux]     [Linux Media]     [Asterisk]     [DCCP]     [Netdev]     [Xorg]     [Linux USB]
  Powered by Linux