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
On 11/27/12 12:53 PM, Rob Kampen wrote:> 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?which part of that has ANYthing to do with CentOS ? -- john r pierce N 37, W 122 santa cruz ca mid-left coast
Hello Rob, On Wed, 2012-11-28 at 09:53 +1300, Rob Kampen wrote:> 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.Perhaps a file upload/post size limitation? Maximum execution time limit? You should ask your provider. A workaround could be to cut the dump up using text editor and try doing it in parts. Regards, Leonard. -- mount -t life -o ro /dev/dna /genetic/research
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
On 11/27/2012 10:58 PM, John R Pierce wrote:> On 11/27/12 12:53 PM, Rob Kampen wrote: >> 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? > which part of that has ANYthing to do with CentOS ? > > >Hi, it seems normal, There must be shown you which line is mistake... May you have triggers in your table. mysqldump -u rkampen -p --skip-triggers --databases databasename > databasenamedate_format.sql test without triggers. Regards