mysqldump file fails to load

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



Hi List,
This is a request for your experiences with mysqldump - or more specifically loading the dump file.

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

This has always served me well on different versions of CentOS and MySql. The file is over 3,000,000 characters in just over 1,000 lines (2.7M).

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.

Thus my questions are
1. Anyone ever have this kind of problem - i.e. failure to load a mysqldump file?

2. Are there alternative methods or formats I could use?

I do not want to code something specific to dump this one record at a time and then load it one record at a time......:-(
TIA for your insights
Rob
_______________________________________________
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