Distance between two points. but in which type? and how can i convert this
value to meter?
Hi Johan,
Johan De Meersman wrote:
as a totally off-topc question, wouldn't something along the lines of
LIMIT COUNT(*)/2, 1 do that trick?
On 4/15/10, Rhino rhi...@sympatico.ca wrote:
...snip...
For example, suppose you had to determine the median grade for a test.
...
That would
I used below query from http://lists.mysql.com/mysql/219805
SET @center = GeomFromText( 'POINT(39.78824896727801 30.50930339115439)' )
;# MySQL returned an empty result set (i.e. zero rows).
SET @radius = 0.005;# MySQL returned an empty result set (i.e. zero rows).
SET @bbox = GeomFromText(
Vikram A wrote:
Hi,
I would like to export my table structure from MYSQL from a particular db. Is there any tool for doing this?
There are several ways to get structure information from within MySQL:
the SHOW COLUMNS... command
the SHOW INDEXES... command
the SHOW CREATE TABLE... command
alba.albetti wrote:
I've just installed MySQL on Windows 2000.
I've opened the MS-DOS windows and I've written
C:\Programs\MySQL\...\bin\mysqladmin -u root -p password mysql2010
After the enter the prompt says Enter password: and I've given enter and I
get
mysqladmin: connect to server at
Hi all, I am hiring a few new junior DBA's and I want to put them thru a
simple db repair training. Does anyone know how I can deliberately
corrupt a MyISAM and InnoDB database in different ways please? So what
I want to do is corrupt 3 MyISAM 100gb databases, 3 InnoDB 100gb
databases - ALL
open the file and remove some data and close it for both data file and index
files, So the tables will be corrupted when access.
On Sun, Apr 18, 2010 at 9:55 PM, Nurudin Javeri nsjav...@idh.com wrote:
Hi all, I am hiring a few new junior DBA's and I want to put them thru a
simple db repair
You can remove the innodb logs and/or the innodb data file. You can also
remove some of the individual .idb files (if you're using file-per-table
option).
On Sun, Apr 18, 2010 at 11:25 AM, Nurudin Javeri nsjav...@idh.com wrote:
Hi all, I am hiring a few new junior DBA's and I want to put them
On Sun, Apr 18, 2010 at 10:39 AM, Suresh Kuna sureshkumar...@gmail.com wrote:
open the file and remove some data and close it for both data file and index
files, So the tables will be corrupted when access.
On Sun, Apr 18, 2010 at 9:55 PM, Nurudin Javeri nsjav...@idh.com wrote:
Hi all, I am
What if the DBA ask for the backup?
And those recommendations can be fixed or they have a very high chance of
making recovery impossible?
On Sun, Apr 18, 2010 at 1:09 PM, Rob Wultsch wult...@gmail.com wrote:
On Sun, Apr 18, 2010 at 10:39 AM, Suresh Kuna sureshkumar...@gmail.com
wrote:
On Sun, Apr 18, 2010 at 11:07 AM, Jim Lyons jlyons4...@gmail.com wrote:
You can remove the innodb logs and/or the innodb data file. You can also
remove some of the individual .idb files (if you're using file-per-table
option).
He originally asked about how to provide a training excise about
A couple good tests are.
1. Corrupt a relay log. For this you can stop the sql thread, cat
/dev/urandom over the newest relay log, start the sql thread and watch
it fail.
2. Change the innodb_log_file_size in my.cnf without going through the
proper procedure to remove the old log files. In 5.0
On Sun, Apr 18, 2010 at 11:13 AM, Andrés Tello mr.crip...@gmail.com wrote:
What if the DBA ask for the backup?
And those recommendations can be fixed or they have a very high chance of
making recovery impossible?
Who is the dba going to ask for a backup? Himself? The guy that puts
backups on
Linux will normally swap out a few pages of rarely used memory so it's
a good idea to have some swap around. 2G seems excessive though.
Usually I prefer to have linux kill processes rather than excessively
swapping. I've worked on machines before that have swapped so badly
that it took minutes
Rob Wultsch wrote:
On Sun, Apr 18, 2010 at 11:13 AM, Andrés Tello mr.crip...@gmail.com wrote:
What if the DBA ask for the backup?
And those recommendations can be fixed or they have a very high chance of
making recovery impossible?
Who is the dba going to ask for a backup? Himself? The guy
On Sun, Apr 18, 2010 at 12:04 PM, Eric Bergen eric.ber...@gmail.com wrote:
Linux will normally swap out a few pages of rarely used memory so it's
a good idea to have some swap around. 2G seems excessive though.
Usually I prefer to have linux kill processes rather than excessively
swapping.
The impact of swap activity on performance is dependent on the rate at
which things are being swapped and the speed of swapping. A few pages
per second probably won't kill things but in this case it was swapping
hundreds of pages per second which killed performance. Disks are much
slower than
This can become a problem when using replication. For example if you do:
begin;
insert into innodb_table;
insert into myisam_table;
insert into innodb_table;
rollback;
The innodb rows won't be replicated but the myisam row will. There is
more info at:
It's distributed as part of mysql. The script is responsible for
restarting mysqld if it exits with a non zero return code such as when
it crashes.
On Mon, Mar 29, 2010 at 2:40 PM, Colin Streicher
co...@obviouslymalicious.com wrote:
Yeah, its just a shell script that acts as a wrapper around the
use can use mysqldump with option *-no-data*
eg.
*mysqldump -u user -ppassword wordpress user --no-data Dumpdata.txt *
where wordpress is my database and user is my table.
Thanks
On Sun, Apr 18, 2010 at 9:48 PM, Shawn Green shawn.l.gr...@oracle.comwrote:
Vikram A wrote:
Hi,
I would
Note : if you table name it will export all tables from given database;
eg:*
mysqldump -u user -ppassword wordpress --no-data Dumpdata.txt *
It will export all tables from db wordpress.
On Mon, Apr 19, 2010 at 8:57 AM, Prabhat Kumar aim.prab...@gmail.comwrote:
use can use mysqldump with
I want to change the mysql default storage engine from MyISAM to InnoDB.
What are the steps involved .Is it edit my.cnf file and add a line
default-storage-engine=innodb and restart the mysql server? How I can bring
my databases with mixed storage engine down without any data loss. What
steps I
How can I remove old mysql-bin log file in log directory? A mysql full
backup will clear the old mysql bin log file or not?
Thanks,
Arshu Paul
On Sun, Apr 18, 2010 at 8:58 PM, Angelina Paul arshup...@gmail.com wrote:
How can I remove old mysql-bin log file in log directory? A mysql full
backup will clear the old mysql bin log file or not?
Thanks,
Arshu Paul
You probably want
On Sun, Apr 18, 2010 at 8:31 PM, Angelina Paul arshup...@gmail.com wrote:
I want to change the mysql default storage engine from MyISAM to InnoDB.
What are the steps involved .Is it edit my.cnf file and add a line
default-storage-engine=innodb and restart the mysql server?
If you do not want
You can add a *expire_logs_days* Variable in my.cnf during the
configuration of replication server.
#* expire_logs_days = 7*
It will purged binary logs older than 7 days.The old logs will be purged
during the next bin-log switch.
Or, You can also delete bin-log manually using command :
PURGE
On Sun, Apr 18, 2010 at 9:40 PM, Prabhat Kumar aim.prab...@gmail.com wrote:
You can add a expire_logs_days Variable in my.cnf during the configuration
of replication server.
# expire_logs_days = 7
It will purged binary logs older than 7 days.The old logs will be purged
during the next
You need to locate the mySQL config file (helpfully named) my.cnf file. On
linux it is located at /etc/my.cnf
Then under the [mysqld] add the following line as shown below!
*[mysqld]
default-storage_engine = InnoDB*
And don't forget to restart mysql. After this whenever you create a table
its
28 matches
Mail list logo