MySQL Error.

Discussion in 'Site & Server Administration' started by Plutonic, May 3, 2009.

  1. #1
    I'm trying to import my blog database to my new server and I keep getting this error:

    Can anyone help ASAP? My old hosting runs out tomorrow so I need to transfer it as fast as I can.
     
    Plutonic, May 3, 2009 IP
  2. Camay123

    Camay123 Well-Known Member

    Messages:
    3,423
    Likes Received:
    86
    Best Answers:
    0
    Trophy Points:
    160
    #2
    Have you try taking another mysql dump and restoring it ?
     
    Camay123, May 3, 2009 IP
  3. SSANZ

    SSANZ Peon

    Messages:
    861
    Likes Received:
    10
    Best Answers:
    0
    Trophy Points:
    0
    #3
    What method of export did you use?
     
    SSANZ, May 4, 2009 IP
  4. Lpe04

    Lpe04 Peon

    Messages:
    579
    Likes Received:
    15
    Best Answers:
    0
    Trophy Points:
    0
    #4
    The datafile may be too large to upload.

    See if there is an option in the control panel to restore a database.
     
    Lpe04, May 4, 2009 IP
  5. pitgo

    pitgo Peon

    Messages:
    4
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    Error
    Database query error


    What is this error

    Database error
    Query:
    SELECT * FROM `Banners` WHERE `Active` 0 AND `campaign_start` = NOW() AND `Position` LIKE '%2%' ORDER BY RAND() LIMIT 1

    Mysql error:
    Can't create/write to file '/tmp/#sql_e06_0.MYI' (Errcode: 13)

    Found error in file /home/hamed/public_html/inc/banners.inc.php
    at line 46. Called db_arr function
    with erroneous argument #0

    Debug backtrace:
    Array
    (
    [1] => Array
    (
    [file] => /home/hamed/public_html/inc/db.inc.php
    [line] => 115
    [function] => db_res
    [args] => Array
    (
    [0] => SELECT * FROM `Banners` WHERE `Active` 0 AND `campaign_start` = NOW() AND `Position` LIKE '%2%' ORDER BY RAND() LIMIT 1
    [1] => 1
    )

    )

    [2] => Array
    (
    [file] => /home/hamed/public_html/inc/banners.inc.php
    [line] => 46
    [function] => db_arr
    [args] => Array
    (
    [0] => SELECT * FROM `Banners` WHERE `Active` 0 AND `campaign_start` = NOW() AND `Position` LIKE '%2%' ORDER BY RAND() LIMIT 1
    )

    )

    [3] => Array
    (
    [file] => /home/hamed/public_html/inc/design.inc.php
    [line] => 365
    [function] => banner_put_nv
    [args] => Array
    (
    [0] => 2
    )

    )

    [4] => Array
    (
    [function] => TmplKeysReplace
    [args] => Array
    (
    [0] => Array
    (
    [0] => __banner_left__
    [1] => banner_left
    )

    )

    )

    [5] => Array
    (
    [file] => /home/hamed/public_html/inc/design.inc.php(493) : runtime-created function
    [line] => 27
    [function] => preg_replace_callback
    [args] => Array
    (
    [0] => /__([a-zA-Z0-9_-]+)__/
    [1] => TmplKeysReplace
    [2] =>



    __page_header__









    __styles__
    __java_script__

    var urlIconLoading = '__images__loading.gif';





    $(document).ready( function() { //onload
    //apply top menu functionality
    $( 'table.topMenu' ).dolTopMenu();

    //apply rss aggregator
    sClockIcon = '__images__icons/clock.gif';
    $( 'div.RSSAggrCont' ).dolRSSFeed();
    } );





    __ray_invite_js__

    __extra_js__

    __extra_css__











    __ray_invite_swf__

    __banner_left__
    __banner_right__





    __TOP_Links__
    __TOP_News__
    __TOP_ContactUs__
    __TOP_About__
    __TOP_Privacy__
    __TOP_Termsofuse__
    __TOP_FAQ__
    __TOP_Feedback__
    __TOP_Aff__
    __TOP_Invitefriend__
    __TOP_Bookmark__
    __switch_lang_block__




    __main_logo__
    __hello_member__

    __banner_top__

    __top_menu__




    __page_header_text__





    __page_header_text__


    __page_main_code__








    __banner_bottom__





    __BMI_Links__
    __BMI_News__
    __BMI_ContactUs__
    __BMI_About__
    __BMI_Privacy__
    __BMI_Termsofuse__
    __BMI_FAQ__
    __BMI_Feedback__
    __BMI_Aff__
    __BMI_Invitefriend__
    __BMI_Bookmark__

    __copyright__







    )

    )

    [6] => Array
    (
    [file] => /home/hamed/public_html/inc/design.inc.php
    [line] => 489
    [function] => __lambda_func
    [args] => Array
    (
    [0] =>



    __page_header__









    __styles__
    __java_script__

    var urlIconLoading = '__images__loading.gif';





    $(document).ready( function() { //onload
    //apply top menu functionality
    $( 'table.topMenu' ).dolTopMenu();

    //apply rss aggregator
    sClockIcon = '__images__icons/clock.gif';
    $( 'div.RSSAggrCont' ).dolRSSFeed();
    } );





    __ray_invite_js__

    __extra_js__

    __extra_css__











    __ray_invite_swf__

    __banner_left__
    __banner_right__





    __TOP_Links__
    __TOP_News__
    __TOP_ContactUs__
    __TOP_About__
    __TOP_Privacy__
    __TOP_Termsofuse__
    __TOP_FAQ__
    __TOP_Feedback__
    __TOP_Aff__
    __TOP_Invitefriend__
    __TOP_Bookmark__
    __switch_lang_block__




    __main_logo__
    __hello_member__

    __banner_top__

    __top_menu__




    __page_header_text__





    __page_header_text__


    __page_main_code__








    __banner_bottom__

    __boonex_footers__



    __BMI_Links__
    __BMI_News__
    __BMI_ContactUs__
    __BMI_About__
    __BMI_Privacy__
    __BMI_Termsofuse__
    __BMI_FAQ__
    __BMI_Feedback__
    __BMI_Aff__
    __BMI_Invitefriend__
    __BMI_Bookmark__

    __copyright__







    )

    )

    [7] => Array
    (
    [file] => /home/hamed/public_html/guestbook.php
    [line] => 60
    [function] => PageCode
    [args] => Array
    (
    )

    )

    )


    Called script: /guestbook.php

    Request parameters:
    Array
    (
    [owner] => 3
    [action] => show_add
    )


    --
    Auto-report system

     
    pitgo, Jun 18, 2009 IP