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 A
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 wrote:
>
> Hi, I just tried this on a local copy of t
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 goi
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
fo
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 MySQL
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 c
great! thanks much.
On Wed, Mar 18, 2009 at 1:52 PM, Claudio Nanni wrote:
> 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
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 proced
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. Toda
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,
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 bi
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 status(averag
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
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
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 wrote:
> 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,
Sun only worth 6.5 billions?
--
-
Lin Chun
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
yup!!!
On Wed, 18 Mar 2009 10:47:42 -0500, mos wrote:
> 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 un
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
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
o
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 wrote:
>
> Hi all,
>
> I am looking for a solution.
>
> While being on one db server how to get the data from other server
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
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
allows us to string the files together in the proper order to apply when an
update g
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 sever
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
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 tech
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 (
http://dev.
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 the
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 production,
Juan,
On Wed, Mar 18, 2009 at 11:14 AM, Juan Pereira
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 for this kind of dat
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 t
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
>
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-, no
34 matches
Mail list logo
