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

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

@souce_hosts_ip_addr:path_to_source_japan.dbdmpusername@souce_hosts_ip_addr:path_to_source_japan.dbdmp path_to_where_space_is_available_on_local_host 5) Import the dumpfile to destination db: $ mysql -uuser -ppassword -Ssocket file path usa ./source_japan.dbdmp Regards, Uma On 6/25/09, Nathan Huang nathan.vorbei.t...@gmail.com wrote

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, ewen fortune

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

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 peter.braw...@earthlink.net wrote: Is there any method to find the CREATION DATE of an EXISTING

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 dbname CHARSET=utf8; would result in unexpected behaviour of the data. Thanks! Uma

Re: Creating / Lookup Users For Database

.* 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/22/09, Carlos Williams carlosw...@gmail.com wrote: This seems to be a simple beginer question for MySQL and I

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 PROTECTED] wrote: Hello

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

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 blocks of errors like the following while trying

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 how it works and you can do the same

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

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

mysqldump: Error 5: Out of memory

! 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 List

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

.. 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 DGI am working with PHP for the first time and I need a form DGTo insert some details and a date. DG DGWhen I check the mysql database

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

Sorting Data

in a 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

Re: Sorting Data

scripting and latin1 sorting VRorder? What's wrong in your ordering? If i sort the data's it is checking the first 7 bits from the right and it is omiting the last bit.It is sorting by taking the 7 bits.If it is sorted like this then the result obtained is not correct. VR VRUST -Uma VR VR VR VR VR

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: Creating tables in mysql

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 PROTECTED] To unsubscribe, e

Creating tables in mysql

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 PROTECTED] To unsubscribe

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

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

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: ABHey All, AB ABI am new to mysql and I need help debugging this peice of code for my site: AB AB?php AB$db = mysql_connect(db30.pair.com, net3dual

Re: need help debugging!

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

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

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,

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:

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)

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.