Hello,
I'm currently developing a program for centralizing the vehicle fleet GPS
information -http://openggd.sourceforge.net-, written in C++.
The database should have these requirements:
- The schema for this kind of data consists of several arguments -latitude,
longitude, time, speed. etc-,
Juan
I don't think it really matters, doesn't look like you'll need any
features which are only available in one or the other!
The main issue you will have is supporting the application and the RDBMS
so go for the one you are most comfortable with and can support/configure
best.
Regards
John
I have an application and database doing this right now. We run both
ways, a single db per customer and a single customer per db. Smaller
customers are in a shared enviroment and larger customers have their
own db, sometimes they even have their own server. We use a company_id
field in each table
Juan,
On Wed, Mar 18, 2009 at 11:14 AM, Juan Pereira
juankarlos.open...@gmail.com wrote:
Hello,
I'm currently developing a program for centralizing the vehicle fleet GPS
information -http://openggd.sourceforge.net-, written in C++.
The database should have these requirements:
- The schema
Hi, I just tried this on a local copy of the table with ~500.000 rows:
execute 'ALTER TABLE users MODIFY email VARCHAR(255) CHARACTER
SET latin1 NOT NULL'
The old character set was UTF8. We're doing this to make the index
smaller. This took around 45 minutes to complete. In
On Mar 18, 2009, at 11:47 AM, Johnny Withers wrote:
I have an application and database doing this right now. We run both
ways, a single db per customer and a single customer per db. Smaller
customers are in a shared enviroment and larger customers have their
own db, sometimes they even have
Hello Jim,
If I unserstand well your needs the steps you need to do are:
Create one user X with insert privileges on the mydb.audit_table
Create the stored procedure specifying the user X both in the DEFINER
section and in the SQL_SECURITY section
of the create procedure statement (
Gentelemen, this is my opinion.
This is not a list for job posting, there are specific sites for that.
If we consider useful a 'private' list for job postings we can ask a new
one.
I understand every thing about the need of a job but it can be done in a
better way,
I use this list to solve
On Wed, 2009-03-18 at 13:54 +0100, Claudio Nanni wrote:
This is not a list for job posting, there are specific sites for that.
If we consider useful a 'private' list for job postings we can ask a new
one.
I understand every thing about the need of a job but it can be done in a
better way,
I
Stop going around and around on this subject. Job announcements do NOT BELONG
HERE. 99% of the people on this list are technical and they are looking to
share technical information NOT job announcements from the UK. James please do
not send anymore JOB related posts to this list. Like
Hi all,
I am looking for a solution.
While being on one db server how to get the data from other server. One
method is federated. Is there any other way
Thanks,
Krishna Chandra Prajapati
you can do this also
(source)
(desti)
mysqldump -uroot -p -habc.com --databases yyy --table tab1 | mysql
-uroot -p -hzzz.com -Dxxx
On 3/18/09, Krishna Chandra Prajapati prajapat...@gmail.com wrote:
Hi all,
I am looking for a solution.
While being on one db server how to get the data
Thanks, Claudio, but that's not quite it. I'm not writing any procedure.
I'm inserting code into procedures other people write. I am taking each
procedure out of the mysql.proc table, inserting a few lines of code right
at the start of the body, and saving back into the proc table. These lines
Here is an interesting blog post link I came across today that suggests IBM
may want to buy Sun:
http://blogs.zdnet.com/BTL/?p=14817
Mike
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
On Wed, March 18, 2009 06:29, Johnny Withers wrote:
Everytime we make a schema change in development we save an SQL script
into
a directory named in MMDD format. The scripts are named in
MMDD_NNN_DESCRIPTION.SQL format, where NNN is the sequence number.
This
I realize its probably a
Sun only worth 6.5 billions?
--
-
Lin Chun
I suppose it would... but we have not (and hopefully never will) have to
release more than 12 months worth of upates at a time. If we do, can I
contact you to get all these files renamed???
I can see it causing a problem at hte end of each year though.
Dang.
-jw
On Wed, Mar 18, 2009 at 11:22 AM,
Yeah! No kidding. If IBM doesn't pick it up then maybe I will. ;-p
On Wed, Mar 18, 2009 at 12:30 PM, Lin Chun franks1...@gmail.com wrote:
Sun only worth 6.5 billions?
--
-
Lin Chun
Seems a very low valuation despite Sun's problems!
If this goes through what do you think the future holds for MySQL and DB2?
In the long term maybe this would mean some much needed decent MySQL
support in the IBM Cognos BI suite ;)
Regards
John
Yeah! No kidding. If IBM doesn't pick it up
Juan:
We've had success with spatial indexes and mysql on our sites however our
numbers are smaller:
http://brokersnetwork.com (200,000+ records)
http://yearlyrentals.com (200,000+ records)
http://avalonrealestate.com/map.php (4,400+ records)
...
Not sure why you you need the trucks location
Hello there guys,
Latelly our database server is going into a very big problem, our current
configuration (is in an attachment file), is having huge load of leak memory
and a variable *innodb_log_file_size *is off cause when i up it the mysqld
doesn't start, our server is having this
John,
At 11:49 AM 3/18/2009, you wrote:
Seems a very low valuation despite Sun's problems!
Sun stock was worth only $3 billion a few weeks ago when the stock was
around $3. Today the stock is $9 with almost 80% move today alone! IBM
should have bought it last November and saved themselves
Hi!
My name is Valentin and I am writing to you for the following problem:
I created a database containing the table:
CREATE TABLE `documents_ex` (
`ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
`Journal_ex_ID` int(10) unsigned DEFAULT NULL,
`Documents_ID` int(10) unsigned DEFAULT NULL,
Interesting commentary at http://blogs.zdnet.com/BTL/?p=14817
PB
http://www.artfulsoftware.com
-
mos wrote:
John,
At 11:49 AM 3/18/2009, you wrote:
Seems a very low valuation despite Sun's problems!
Sun stock was worth only $3 billion a few weeks ago when the stock was
around $3.
Ok sorry, I did not understand at first.
GRANT INSERT on mydb.audit_table to ''@'%';
should do the work.
Cheers
Claudio
Jim Lyons wrote:
Thanks, Claudio, but that's not quite it. I'm not writing any
procedure. I'm inserting code into procedures other people write. I
am taking each
great! thanks much.
On Wed, Mar 18, 2009 at 1:52 PM, Claudio Nanni claudio.na...@gmail.comwrote:
Ok sorry, I did not understand at first.
GRANT INSERT on mydb.audit_table to ''@'%';
should do the work.
Cheers
Claudio
Jim Lyons wrote:
Thanks, Claudio, but that's not quite it. I'm
Velentin,
http://dev.mysql.com/doc/refman/5.1/en/innodb-foreign-key-constraints.html
Note the section for the droping of foreign keys used the contraint name, not
the key name. Try this and see if it solves the first problem (of removing the
constraint). Then you should be able to drop the
We are using the PostgreSQL currently to store the Bayes information. It
seems to periodically spend a lot of time 'vacumming' which of course
drives up disk load. The system admin has adjusted it so it only does
this at low load. I'm curious if anyone has actually tested the
PostgreSQL vs
Ubuntu 8.10.
I was experimenting with the Spring Petclinic sample application,
configured with MySQL. I found that some of the tests were failing,
apparently because of table name case-sensitivity issues. I was able to
fix some of the code references, but after that I hit other, probably
They'd all be identical DBs/schemas. And if we updated schema on one,
we'd update all. We're talking like 100-200 operators total (they are
airlines). They just have TONS of data each.
So one of my questions that I was hoping to hear answered (and maybe I
missed it) is this:
Are mySQL reports
Hi Morten,
You might want to read this post on MySQL Performance Blog that was
posted a few days ago:
http://www.mysqlperformanceblog.com/2009/03/17/converting-character-sets/
Have a nice day,
- Martijn
On Wed, Mar 18, 2009 at 11:50, Morten my.li...@mac.com wrote:
Hi, I just tried this on a
I have taken a Microsoft Access database and have basically copied the
structure of it and rebuilt it in MySQL, however, I have encountered
some problems with formatting of data. I need to ask what is the most
suitable field type to use to retain the content from Access field types
The MS
32 matches
Mail list logo