Announcement

Collapse
No announcement yet.

Table Truncated upon import

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Table Truncated upon import

    Done a search for this error, but no joy.
    I have just installed a new Linux dev box in my workshop and to save myself a little time I
    1: Did a complete MySQL dump of the forum database
    2: Did a complete backup of the dev installation directory.

    Having copied the directory into the new box, I tried importing the sql dump (I have done this numerous times, successfully) but all I keep getting is
    Code:
     #1265 - Data truncated for column 'datatype' at row 237
    Now, I have no idea if this is an Apache, PHP, MySQL or my error. Does anybody recognise it, and maybe have a (part) solution.

    Oh, and by the way the details are
    vB 3.5.4
    Apache 2.2.2
    PHP 5.1.4
    MySQL 5.0.22
    Mepis Linux

  • #2
    How are you doing the import and which version of MySQL was running on the server where the backup was made?
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment


    • #3
      All version mentioned for the Linux setup are the same as the previous (Windows) setup.
      I'm using the phpMyAdmin 'Import' button. I did play with it further last evening and again this morning, and it is always that table/column that returns the fault. It is beyond me, though I am beginning to wonder whether it could be the configuration of MySQL that could be at fault. I will experiment in that area for a while, though it is not really critical as I only use this method as a fast and dirty shortcut
      Many thanks for your prompt reply.

      Comment


      • #4
        The only consistently reliable method of backing up and restoring a database is with shell access via telnet or ssh. Please see the instructions here:

        Backup:
        http://www.vbulletin.com/docs/html/m...nce_ssh_backup

        Restore:
        http://www.vbulletin.com/docs/html/m...ce_ssh_restore

        This is because backing up with a PHP script like that in the Admin CP or phpMyAdmin can result in PHP timeout errors and an incomplete backup file.

        If you don't have telnet or SSH access, some people have reported success with these scripts:

        MySQLDumper:
        http://www.mysqldumper.de/en/index.php

        MySQLHotxcopy:
        http://www.vbulletin.com/forum/showt...t=mysqlhotcopy

        Bigdump:
        http://www.ozerov.de/bigdump.php
        Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
        Change CKEditor Colors to Match Style (for 4.1.4 and above)

        Steve Machol Photography


        Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


        Comment


        • #5
          That is really great, thankyou very much.

          Comment

          widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
          Working...
          X