List:General Discussion« Previous MessageNext Message »
From:Sujay Koduri Date:August 11 2005 12:23pm
Subject:RE: Uninstalling the MySQL cleanly.
View as plain text  
Hi gleb,

I am including the packages which I tried to install along with the program
and the error I am getting when I tried running it.

Packages

MySQL-client-4.1.13-0.i386.rpm
MySQL-server-4.1.13-0.i386.rpm
MySQL-devel-4.1.13-0.i386.rpm
MySQL-shared-standard-4.1.13-0.rhel3.i386.rpm

The error I am getting for the below program is 

Binding of columns failed
2036: Using unsupported buffer type: 0  (parameter: 1)

I tried running the program using the following command.
gcc -g prog_name -lmysqlclient

This is the program I am going to test.

#include <stdio.h>
#include <mysql/mysql.h>
#define INSERT "select column_name from information_schema WHERE Table_Name
= ?"
//This table is already existing. All the columns in the table are of type
varchar.

int main()
{
  MYSQL mysql;
  MYSQL_STMT *stmt;
  MYSQL_BIND bind[1];
  MYSQL_BIND bind_result[1];
  char str_in[50], str[2];
  unsigned long length[1];
  unsigned long str_in_len;
  my_bool is_null[1];

  if(!mysql_init(&mysql))
  {
    exit(3);
  }

  if(!mysql_real_connect(&mysql, "localhost","user", "pass", "db", 0, NULL,
0))
  {
    printf("%d: %s \n",mysql_errno(&mysql), mysql_error(&mysql));
    exit();
  }

  stmt = mysql_stmt_init(&mysql);
  if(!stmt)
  {
    printf("Out of memory..\n");
    exit(3);
  }

  if ( mysql_stmt_prepare(stmt, INSERT, strlen(INSERT)) )
  {
    printf("Prepare statement failed for insertion..:( \n");
    exit(3);
  }

  bind[0].buffer_type = MYSQL_TYPE_VAR_STRING;
  bind[0].buffer = (char *)str_in;
  bind[0].buffer_length = 50;
  bind[0].is_null = 0;
  bind[0].length = &str_in_len;

  strncpy(str_in, "information_schema", 50);
  str_in_len = strlen(str_in);

  if ( mysql_stmt_bind_param(stmt,bind) )
  {
    /*****Failing here ******/
    printf("Binding of columns failed\n");
    printf("%d: %s \n",mysql_stmt_errno(stmt), mysql_stmt_error(stmt));
    exit(3);
  }

  if (mysql_stmt_execute(stmt))
  {
    printf("Executing prepared statement failed\n");
    exit(3);
  }

  memset(bind_result, 0, sizeof(bind_result));
  bind_result[0].buffer_type = MYSQL_TYPE_STRING;
  bind_result[0].buffer = (char *)str;
  bind_result[0].buffer_length = 2;
  bind_result[0].is_null = &is_null[0];
  bind_result[0].length = &length[0];

  if (mysql_stmt_bind_result(stmt, bind_result))
  {
    printf(" mysql_stmt_bind_result() failed\n");
    printf(" %s\n", mysql_stmt_error(stmt));
    exit(0);
  }

  /* Now buffer all results to client */
  if (mysql_stmt_store_result(stmt))
  {
    printf(" mysql_stmt_store_result() failed\n");
    printf(" %s\n", mysql_stmt_error(stmt));
    exit(0);
  }

  while (!mysql_stmt_fetch(stmt))
  {

    if (is_null[0])
      printf(" NULL\n");
    else
      printf(" %s(%ld)\n", str, length[0]);

  }

  printf("The no of rows affected are %d\n",mysql_stmt_affected_rows(stmt));
  if (mysql_stmt_close(stmt))
  {
    printf("Error while closing mysql statement\n");
    exit(3);
  }
  mysql_close(&mysql);
  return 0;
}
 

Thank you
sujay

-----Original Message-----
From: Gleb Paharenko [mailto:gleb.paharenko@stripped] 
Sent: Thursday, August 11, 2005 2:58 PM
To: mysql@stripped
Subject: Re: Uninstalling the MySQL cleanly.

Hello.

I guess you have rpm installation, rpm -e should help you in this case.
Find installed mysql packets with `rpm -qa |grep -i mysql` command.
If you have troubles with making a choice, send the list of packets which
you got to the list.


Sujay Koduri <SujayK@stripped> wrote:
> 
> 
> 
>>
>> OS is RH9 and kernel is 2.4.20
> 
> I suggest you send this to the MySQL list :-)
> 
> With regards,
>>
>> > Can any one list the steps or give me any pointers how to cleanly
>> uninstall
>> > an upper version of MySQL,
>> > so that after wards if we install lower version it should not be 
>> > affected
>> by
>> > any left overs of the previous installation.
>>
>> What OS?
>>


--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   Gleb.Paharenko@stripped
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
       <___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
Thread
Uninstalling the MySQL cleanly.Sujay Koduri11 Aug
  • Re: Uninstalling the MySQL cleanly.Martijn Tonies11 Aug
RE: Uninstalling the MySQL cleanly.Sujay Koduri11 Aug
  • Re: Uninstalling the MySQL cleanly.Gleb Paharenko11 Aug
RE: Uninstalling the MySQL cleanly.Sujay Koduri11 Aug
  • Re: Uninstalling the MySQL cleanly.Gleb Paharenko11 Aug
  • Re: Uninstalling the MySQL cleanly.Gleb Paharenko11 Aug