Getting error when adding sql

~~riderz~~

Senior Member

Join Date: Mar 2009
Posts: 975

Getting error when adding sql

14.02.10, 08:13

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.

Tags: None