I want to change my sqldatabase server from one machine to another

the database to another machine. All myscripts should access the database from the new machine and new location. Thanks, Uma-

Re: how to fetch and calculate data from remote database and insert into local database

rce_japan.dbdmp 2) ssh to destination host 3) Check if that folder is shared between remote and local host. else, Step4. 4) scp the dump file from souce host to destination host: $ @::> 5) Import the dumpfile to destination db: $ mysql -u -p -S usa < ./source_japan.dbdmp Regards, U

Re: Best way to convert character set from "latin1 to utf8" for existing database?

Thank was great piece of info Ewen, Thanks! However this approach works for new data. But the existing data in the database does not show us the Japanese characters from application side. Appreciate responses who 'actually' got to work on this conversion. Thanks! Uma On 6/1/09, ew

Re: Finding the creation date of an existing database in MySQL 5?

> > Thanks for the response, Peter. > Yeah, I am aware of this to find it for the tables. However I require to > find the creation time of a database.. > > Thanks, > Uma > > > On 6/3/09, Peter Brawley wrote: >> >> >Is there any method to find

Finding the creation date of an existing database in MySQL 5?

Hi all ! Is there any method to find the CREATION DATE of an EXISTING database and tables in MySQL 5.0 or newer versions? Thanks, Uma

Best way to convert character set from "latin1 to utf8" for existing database?

CHARACTER SET - utf8 DEFAULT COLLATION : utf8_general_ci Note that this has to be done on a database that has *existing data* in it . Hence just by doing a: ALTER DATABASE CHARSET=utf8; would result in unexpected behaviour of the data. Thanks! Uma

Re: Creating / Lookup Users For Database

d'; mysql> GRANT ALL PRIVILEGES ON forums.* TO 'carlos'@'localhost' WITH GRANT OPTION; *OR* ** mysql> GRANT ALL PRIVILEGES ON forums.* TO 'carlos'@'localhost' IDENTIFIED BY 'p...@$$w3rd' WITH GRANT OPTION; Regards, Uma Bhat On 4/2

Re: Re[2]: ERROR 2006 (HY000): MySQL server has gone away

Tried increasing the "wait_timeout" variable and restart the instance? http://dev.mysql.com/doc/refman/5.0/en/gone-away.html Let us know - 1) your my.ini settings. 2) the options you are giving while taking the dump. Regards, Uma On 11/17/08, [EMAIL PROTECTED] <[EMAIL PROT

Re: ERROR 2006 (HY000): MySQL server has gone away

s set bigger in the mysqld server than in the client and that all clients uses the same value for max_allowed_packet. Let us know if this works for you. Thanks, Uma On 11/17/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > Hello & Greetings , > > I got about three bloc

Re: Any easier way to compare mysql schema of 50 databases?!

Thank you all, guys!! i shall try these and respond on which worked best for me. Regards, Uma On 10/6/08, Andy Shellam <[EMAIL PROTECTED]> wrote: > > Hi, > > I was also going to go down this route some time back, but then when I > looked at it, it's pretty simple h

Any easier way to compare mysql schema of 50 databases?!

rry out this process for 50 databases!!! *Are there any tools available* to accomplish this task? Many Thanks! Uma

mysqldump: Error 5: Out of memory

k response ! Much Thanks, Uma

Running mysql on XP

Hello! I am trying to run mysql on XP. I have started the net start mysql. This service started without any error. My.ini file was there in c:\windows only. But i couldn't able to connect mysql. Can anyone please tell me where is the problem? regards uma -- MySQL General Mailing

storage of values in mysql

Hello, I need to store the charater value as well as some float value in the varchar defined field..is there any other way of decalaration of the field that i can store the character as well as float value ? Regards, Uma -- MySQL General Mailing List For list archives: http

Abt mysqldatabase

Hello , I need to copy the database contents from one operating system to another operating system..if i copy the entire database folder it is coping only the table structure..contents is not getting copied..can anyone please tell me how do i go do this ?? Regards, Uma -- MySQL

Abt Mysqldump

ror.. Regards, Uma -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Removal of Primary Key in Mysql

Hello, I have set one of my field in the mysql table as primary key..no i want to remove that primary key setting in mysql..Can anyone please tell me how to do that ??? Regards, Uma - Before posting, please check: http

Re: Insert dates with PHP

you have to enter ur date as in this format -MM-DD for example: 2002-04-04 Hope this will work Uma On Thu, 16 May 2002, Defryn, Guy wrote: DG> DG> DG>I am working with PHP for the first time and I need a form DG>To insert some details and a date. DG> DG>When

Triggers

Hello All, Is Mysql supports sql triggers ...??.. Is anyone know this pls tell me.. Thanks in advance Uma - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

Mysql dump

Hello, I am having all mysql database contents in one txt file.how i will dump all those contents to mysql database tablespls tell me how to do it -Uma - Before posting, please check: http://www.mysql.com

Re: Sorting Data

On Mon, 18 Mar 2002, Victoria Reznichenko wrote: VR>Uma, VR>Monday, March 18, 2002, 11:34:07 AM, you wrote: VR> VR>UST>To get German sorting order, you should start mysqld with VR>UST>--default-character-set=latin_de. This will give you the following VR>UST>

Sorting Data

wrong way... Is any other setting to be made for this. If anybody know this please guide me.. -Uma - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

Creating tables in mysql

is dbase and my table name is rr -Uma - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTE

Re: Creating tables in mysql

is dbase and my table name is rr -Uma - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTE

ISCII support for mysql

Hello, Can anyone tell to me which version of Mysql support ISCII.. Regards, Uma - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the

Check 8 bit in mysql during sorting

Hello, I need one help.To enable 8 bit language in bash we are exporting like this # For 8 bit Language support export LC_CTYPE=iso_8859_1 # For less to support 8 bit chars export LESSCHARSET=latin1 I am using local language for inserting values in mysql.While sorting in mysql is che

Re: need help debugging!

Hello Alex, Check it manually wheather ur query returns any row. -Uma On Fri, 1 Mar 2002, Alex Behrens wrote: AB>how do I fix it so mysql doesn't returns a 0? is my syntax wrong somewhere? AB> AB>Thanks! AB> AB>-Alex

Re: need help debugging!

Hello Alex, If the mysql query returns 0 then it will display the message like this -Uma On Fri, 1 Mar 2002, Alex Behrens wrote: AB>Hey All, AB> AB>I am new to mysql and I need help debugging this peice of code for my site: AB> AB>$db = mysql_connect("db30.

Enable iscii in mysql

Hello, For enabling the iscii in bash we will give export LC_CTYPE=iso_8859_1 For enabling the iscii in mysql is there any setting is there... Anyone came to know this please tell me... - Before posting, pleas

Select 8 bit

Hello, I need one help.To enable 8 bit language in bash we are exporting like this # For 8 bit Language support export LC_CTYPE=iso_8859_1 # For less to support 8 bit chars export LESSCHARSET=latin1 I am using local language for inserting values in mysql.While sorting in mysql is che

no of bits

Hello, Can any one tell me in mysql for sorting how many bits it is check please tell me as soon as possible Cheers Umasankar - Before posting, please check: http://www.mysql.com/manual.php (the manual) htt

Sorting

Hello, I am new to mysql.For the best reference of mysql which site i will look for. please tell me what is the query to sort field name in ascending order Cheers Umashankar - Before posting, please check: http://w

how to give database connection to oracle and mysql

My application is to give database connection to oracle which is in sun solaris machine and to mysql which is in windowsNT machine. How to write a java program to establish connection. please help me.