Martijn Tonies wrote:
Hi,
I'm working on quite big database. It consists of about 200 tables.
Additionaly about 50 tables are per year (because of annual data). It
means every year new 50 tables will have to appear in application. And
now I have a question. Should I use separate databases
Fredrik Carlsson:
Hi,
Yes I'm using the -q option with mysqldump, but the result is the same.
This is a replicated environment and the master is running FreeBSD and
the slave NetBSD and on the master which only has InnoDB tables there
is no problems to run a dump but the machine is to
I think what you want to do is look into creating a spacial index on the raw data. Then just searching on that index will allow you
to judge distances between things. You won't need to create a table with every single possible combination. There are quite a few
examples in the manual and online.
Hi everyone,
I¹m trying to set up a database with information that will be used in a
garment slideshow in flash.
The information to be included as part of the slideshow would be:
code, optional title, description, colours, sizes, garment image, fabric
swatch image
Each clothing item to be
Hello,
I'm having some trouble with the LIKE operator on MySQL 5.0. Here's my
transcript:
mysql select 'abc\\def';
+-+
| abc\def |
+-+
| abc\def |
+-+
1 row in set (0.00 sec)
mysql select 'abc\\def' like '%\\%';
++
| 'abc\\def' like '%\\%' |
Hi
Im contructing a build script and would like to dump my dev db with
mysqldump so I can run a deploy script on the production server with the
update db.
I would like to construct the script so that it updates existing
tables/fields/posts and add new tables/fields/post if they do not exists.
Officelink wrote:
Hi everyone,
I¹m trying to set up a database with information that will be used in a
garment slideshow in flash.
The information to be included as part of the slideshow would be:
code, optional title, description, colours, sizes, garment image, fabric
swatch image
Each
You can using any language to automate it, a scripting language would probably
be the easiest (php, perl, ruby, python, shell, etc).
The table type doesn't matter too much. Although if the tables are static, I
would use MyISAM.
Spatial indexes come across as more for use in geometry, rather
Hi,
I have tables to which the mysqlgisimport tool is used to upload spatial
data. The current situation is that these tables have geomety but
without an srid definition.
How does mysqlgisimpoprt work w.r.t. srid? When trying 'select
srid(geo) from foo', the value returned is 0, as opposed to
Hi,
Running 4.1.22 created from FreeBSD ports on FreeBSD 5.5 .
I run under TCP Wrappers. Even if 1 foreign machine attempts
to contact us on the tcp port, the database becomes incredibly sluggish
or unresponsive.
phpmyadmin shows MySQL said: #2003 - The server is not
Normalization is about using ids to minimize change, which also eliminates repetition. It's fine to have the color red repeated
throughout your table as long as it will never change. But if you suddenly have two shades of red, you'll need to update all the
records that say red. If you used id's,
On 23.05.2007 14:49 CE(S)T, Yves Goergen wrote:
[1]
http://dev.mysql.com/doc/refman/5.0/en/string-comparison-functions.html#operator_like
Never mind. This very page says why it is like it is. It's definitely
too hot in here today. :(
--
Yves Goergen LonelyPixel [EMAIL PROTECTED]
Visit my web
You would need to find out the reason for the crash to prevent or minimize it.
The reason may be external to mysql.
Innodb can get really, really slow when tables get physically large if you
don't have a similar amount of RAM.
MyISAM doesn't support transactions, so no, that wouldn't help.
If
On Tue, May 22, 2007 23:29, PrzemysÅaw Klein said:
Martijn Tonies wrote:
Hi,
I'm working on quite big database. It consists of about 200 tables.
Additionaly about 50 tables are per year (because of annual data). It
means every year new 50 tables will have to appear in application. And
now
I am running the 64 bit version of mysql server 5.1.18, and on the
client side I am running python with the mysqldb module. While
running a very large insert query I get the following error :
2013, 'Lost connection to MySQL server during query'
I have --log-warnings set to 3, but I get no
I need some help. I am under presure from management to migrate and
existing Sybase ASA database to Mysql for a proof of concept.
I have done most of the work, but am having an issue creating a foreign
key. I keep getting the Can't create table './mysqk/#sql-d70_1f.frm'
(errno: 150) error. I
Hi Chris,
Chris Hoover wrote:
I need some help. I am under presure from management to migrate and
existing Sybase ASA database to Mysql for a proof of concept.
I have done most of the work, but am having an issue creating a foreign
key. I keep getting the Can't create table
Here is the error from the show innodb status:
070523 15:39:39 Error in foreign key constraint of table mysql/#sql-d70_22:
FOREIGN KEY (tab_id, class) REFERENCES system_tabs(tab_id, class):
Cannot find an index in the referenced table where the
referenced columns appear as the first columns,
Hi Chris,
Chris Hoover wrote:
Here is the error from the show innodb status:
070523 15:39:39 Error in foreign key constraint of table mysql/#sql-d70_22:
FOREIGN KEY (tab_id, class) REFERENCES system_tabs(tab_id, class):
Cannot find an index in the referenced table where the
referenced
http://dev.mysql.com/doc/refman/5.0/en/create-table.html
under MySQL 5.0 you can do this:
CREATE TABLE mynewtable LIKE theotherone;
-- this will copy the structure as well as add idexes identical to
the plan in the original
under any earlier 4.x version, this will work too
CREATE TABLE
create table x like y
Creates an exact copy of the table without the data, indexes are included.
- Original Message -
From: J Trahair [EMAIL PROTECTED]
To: MySQL General mysql@lists.mysql.com
Sent: Wednesday, May 23, 2007 3:58 PM
Subject: Replicating an existing table
Hi Everyone
mysqlcheck -h$host -u$user -p$pass --analyze $dbname
I wish that was the case!
I tried analyze table ... and optimize table ..., which I presume
would be the same. It did not help. I also ran mysqlcheck just to see
if it will make a difference. Nope!
--
MySQL General Mailing List
For list
I hope someone can clue me in what a syntax of query that produces the
same would look like for MySQL 5.0.12
Old query meant to list most recent message from each thread, e.g.
select * from messages left join messages as messages_ on
messages.thread = messages_.thread and messages.created
Hi i am using mysql-4.1.3-beta version in mysq server
my concern is that i want to create a user that should able to take backup
using mysqldump ...
can any one help me out ..
i tried giving the following grants but it is not works
grant file,SHOW DATABASES,select,lock tables on *.* to
[EMAIL
Hi i am using mysql-4.1.3-beta version in mysq server my concern is that i
want to create a user(minimal grant) that should able to take backup using
mysqldump ...
can any one help me out ..
i tried giving the following grants but it is not works
grant file,SHOW DATABASES,select,lock tables on
[EMAIL PROTECTED] schrieb:
I am running the 64 bit version of mysql server 5.1.18, and on the
client side I am running python with the mysqldb module. While
running a very large insert query I get the following error :
2013, 'Lost connection to MySQL server during query'
I have
Hi i am using mysql-4.1.3-beta version in mysq server my concern is that i
want to create a user(minimal grant) that should able to take backup using
mysqldump ...can any one help me out ..
i tried giving the following grants but it is not works
grant file,SHOW DATABASES,select,lock tables on
It worked in 4.x but does not work in the new syntax. How should I
rewrite it to get the same result?
OK, that was a lie. It works in 5.x as well. I should learn to
describe my problem more accurately as well as RTFM :-(
The correct description of the query in question would have been:
select
Hi i am using mysql-4.1.3-beta version in mysq server my concern is that i
want to create a user (minimal grant) that should able to take backup using
mysqldump ...can any one help me out ..
i tried giving the following grants but it is not works
grant file,SHOW DATABASES,select,lock tables on
29 matches
Mail list logo
