Getting error when adding sql

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

    Getting error when adding sql

    first off all what im going to teach now is when u get an error trying to add a sql
    many ppl have problems saying they cant upload sql there are a error

    1st solution
    -----------------------------------
    problem may be that u didnt change the sql name in the sql u try to upload for example
    Code:
    -- phpMyAdmin SQL Dump
    -- version 2.6.0-pl3
    -- http://www.phpmyadmin.net
    -- 
    -- Darbine stotis: localhost
    -- Atlikimo laikas:  2005 m. Sausio 08 d.  15:14
    -- Serverio versija: 4.0.23
    -- PHP versija: 4.3.10
    -- 
    -- Duombaze: `frm`
    - 
    USE user;
    u must either remove this part before trying to upload ur sql or edit it to match ur sql
    Code:
    -- Duombaze: `frm`  //change to ur database  name
    - 
    USE user; //change to ur database user name

    /////////////////////////////////////////////////////////////////////////////////////////////
    2nd solution
    ------------------------------------------
    u can copy it manually one sql at a time for example with lava

    u can copy ibwf_acc
    etc etc
    seperatly one by one then u know all the sql have being uploaded but keep in mind some of the sql u need to copy the dumping info
    like ibwf_settigns ibwf_avatars ibwf_smilies except if u going to add ur own avatars ans smilies but remember always to copy the ibwf_settings with its dumping info

    //////////////////////////////////////////////////////////////////////////////////////////////

    well this is it or there are a 3rd way create a php mysql upload scripy where u add ur sql in a php file for example install.php then u create ur sql in it then u just run ur install.php and it will install the sql automaticly

    here are an example of the install.php that i have u must just add the whole sql on the page
    Code:
    <?php
    echo "<?xml version=\"1.0\"?>";
    ?>
    <html xmlns="http://www.w3.org/1999/xhtml">
    <?php
    $dbuser = "db_user";
    $dbpass = "dbpass";
    $dbname = "db_name";
    $dbhost = "localhost";
    // Dont change this code
    mysql_connect("$dbhost","$dbuser","$dbpass") or die(mysql_error()); 
    mysql_select_db("$dbname") or die(mysql_error());
    {
    if($_POST['submit'])
        echo "<body>";
        echo "<p align=\"center\">";
        
    mysql_query("CREATE TABLE `ibwf_iconset` (
      `id` int(10) NOT NULL,
      `themedir` varchar(20) NOT NULL
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1; ");
    mysql_query("INSERT INTO `ibwf_iconset` VALUES (1, 'Methos');");
    mysql_query("INSERT INTO `ibwf_iconset` VALUES (2, 'Blue');");
    mysql_query("INSERT INTO `ibwf_iconset` VALUES (3, 'Black to White');");
    mysql_query("INSERT INTO `ibwf_iconset` VALUES (4, 'Red');");
    mysql_query("INSERT INTO `ibwf_iconset` VALUES (5, 'Green');");
    mysql_query("INSERT INTO `ibwf_iconset` VALUES (6, 'Steel');");
    mysql_query("INSERT INTO `ibwf_iconset` VALUES (7, 'Opera WML');");
    mysql_query("INSERT INTO `ibwf_iconset` VALUES (8, 'Error');");
    mysql_query("INSERT INTO `ibwf_iconset` VALUES (9, 'Grey Orange');");
    mysql_query("INSERT INTO `ibwf_iconset` VALUES (10, 'Pinky');");
    mysql_query("INSERT INTO `ibwf_iconset` VALUES (11, 'Matrix');");
    mysql_query("INSERT INTO `ibwf_iconset` VALUES (12, 'Goth');");
    mysql_query("INSERT INTO `ibwf_iconset` VALUES (13, 'Night Pink');");
    
            echo "click install<br/>
            <form action=\"\" method=\"post\">";
            echo "<br/>";
            echo "<input type=\"submit\" value=\"install\"/>";
            echo "</form>";
            echo "</p>";
            echo "</body>";
            echo "</html>";
            exit();
    }
    
    ?>
    </html>
    Last edited by riderz; 14.02.10, 08:19.
    ________________
    Jacques
    jacques@gw-designs.co.za
    http://coding.biz.tm
    Come join and lets make it a place to learn all the noobies how to code
    __________________

    NEVER FORGET TO CLICK THE TANX BUTTON IF U LIKE WHAT IM SHARING OR HELPING WITH
Working...
X