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 $ mysqldump -u -S -p japan > ./source_japan.dbdmp 2) ssh t

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

en fortune wrote: > > Uma, > > On Mon, Jun 1, 2009 at 8:41 AM, Uma Bhat 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 he

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

the CREATION DATE of an EXISTING 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 met

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?

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

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

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

works well for MySQL backups. > > WinMerge: http://www.winmerge.org/ > > Andy > > D. Dante Lorenso wrote: > >> Uma Bhat wrote: >> >>> We are in progress of *optimizing* and designing the existing mysql >>> database >>> enviromnent on *linu

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 sa

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: