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

What exactly do you want to calculate? Generally, export (mysqldump cmd) and import (mysql cmd) of data is done as below: Supposing japan is the source db and usa is your destination db, 1) Dump the database on source server: $ cd to dir where you have enough space to take the dump $ mysqldump

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

ewen.fort...@gmail.com wrote: Uma, On Mon, Jun 1, 2009 at 8:41 AM, Uma Bhat bhat@gmail.com wrote: Hi All, I have read many blogs suggesting some examples for this. But suggestions from you guys who have ACTUALLY worked on such a scenario would help me out the best. Current

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?

database and tables in MySQL 5.0 or newer versions? information_schema.tables.create_time for tables. PB Uma Bhat wrote: 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?

Hi All, I have read many blogs suggesting some examples for this. But suggestions from you guys who have ACTUALLY worked on such a scenario would help me out the best. Current Database has: DEFAULT CHARACTER SET - latin1 DEFAULT COLLATION : latin1_swedish_ci We need to convert this to DEFAULT

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

Hi Mikesz, Try increasing the *max_allowed_packet* value in *my.ini *and bounce the server. Explaination - if you send a query (specially via compressed packets) to the server that is larger than the max_allowed_packet, it drops the connection without providing a good error message. A packet

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

Lorenso wrote: Uma Bhat wrote: We are in progress of *optimizing* and designing the existing mysql database enviromnent on *linux*. And need help in comaparing schema of 50 databases from the same mysql instance. If you can afford to spend a few dollars to get the right tool, you want

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

Hey guys! We are in progress of *optimizing* and designing the existing mysql database enviromnent on *linux*. And need help in comaparing schema of 50 databases from the same mysql instance. *MySQL version 5.0* *SCENARIO* - There are 50 mysql databases (which we have been informed that is of

mysqldump: Error 5: Out of memory

Hey Guys! I have been googling a lot on this error and read various suggestions. But havnt found an appropriate solution yet. I get this error while taking mysqldump of an InnoDB table (say mytable) mysqldump: Error 5: *Out of memory (Needed 632894352 bytes) when dumping table `mytable` at row: