>Description:
In the tab "services", item "databases", choice "mySQL server
at localhost", right click, "admin properties" tab of window "mySQl
server properties"
Path to start command "/usr/local/mysql/support-files/mysql.server"
with argument "start" : don't work
Path to stop com
Dear MySQL users,
MySQL Server 5.4.1-beta, a new version of the popular Open
Source Database Management System, has been released.
Bear in mind that this is a beta release, and as with any
other pre-production release, caution should be taken when
installing on production level systems or system
Mike,
I re-posted your Show Status to the group to see if anyone can offer
a way to speed up the indexing for you.
BTW, you are adding ALL of the indexes to the table using ONE sql statement
right? And not a separate SQL statement to build each index?
Mike
At 02:01 AM 6/25/2009, you w
SELECT INTO OUTFILE does almost the same thing as spool in SQL*Plus
SELECT columnname from tablename into outfile '/path/and/filename.txt'
Regards
John
> Hi
>
> In mysql , how can we stock the query result into a text file
>
> the table is too large , i don't want to dump it , but select a par
Hi
In mysql , how can we stock the query result into a text file
the table is too large , i don't want to dump it , but select a part of it,
i wrote a script perl to do this, but each time i have to change the
parameters in the script to get another table, when i google it, i find the
function in
>-Original Message-
>From: Mike Spreitzer [mailto:mspre...@us.ibm.com]
>Sent: Thursday, June 25, 2009 1:38 AM
>To: mysql@lists.mysql.com
>Subject: Re: Indexing dynamics in MySQL Community Edition 5.1.34
>
>Actually, my characterization of the current state is wrong. It appears
>that one
Hi
I think you mean that you want to get some results (by calculating the data
in remote database) and then stock them in local database;
so dosen't need to dump the db and transfer to local,but need to do some
program to fetch the result and insert into the local database;
In addition, like John s
u asking any scripts
On 6/25/09, John Daisley wrote:
> Depending on what you mean by 'Calculate the data', you could try using a
> tool like Talend (www.talend.com).
>
>> What exactly do you want to calculate?
>>
>> Generally, export (mysqldump cmd) and import (mysql cmd) of data is done
>> as
>
Depending on what you mean by 'Calculate the data', you could try using a
tool like Talend (www.talend.com).
> 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
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
10 matches
Mail list logo
