Hi,
Part of our road map is to use an open source database besides commercial
databases (oracle and sql server), we need to select an open source database
to build the necessary skills for administration and operation.
Then we would put guidelines on which applications should use open source
2009/8/26 chen jia chen.1...@gmail.com
Hi there,
I am using MySQL on ubuntu 8.04.
I followed this link
http://www.ubuntu-howto.info/howto/how-to-move-mysql-databases-to-another-location-partition-or-hard-drive
to change the data directory of MySQL.
After stopping MySQL: sudo
Hi,
From yesterday 2009-08-26 i have an error message when my computer
start. The mysqld.exe crash blablabla
I search on g**gle 006B8853mysqld.exe and i find somebody in this
mailing with this problem!!
I don't change anything in my mysql config file, cause i didn't use
mysql
On Thursday 27 August 2009 03:35:19 am Sameh Attia wrote:
Hi,
Part of our road map is to use an open source database besides
commercial databases (oracle and sql server), we need to select an open
source database to build the necessary skills fo
I know this is a mysql mailing list, but I
Many sites let you search databases of information, but the search
queries are very limited.
I'm creating a site that'll allow arbitrary SQL queries to my data (I
realize I'll need to handle injection attacks).
Are there other viable ways to query data? I read a little on
Business System 12
Kelly Jones wrote:
Many sites let you search databases of information, but the search
queries are very limited.
I'm creating a site that'll allow arbitrary SQL queries to my data (I
realize I'll need to handle injection attacks).
Are there other viable ways to query data? I read a little on
Chen, Did you really delete ibdata1 ?
Yes, I did.
Best,
Jia
Claudio Nanni wrote:
2009/8/26 chen jia chen.1...@gmail.com mailto:chen.1...@gmail.com
Hi there,
I am using MySQL on ubuntu 8.04.
I followed this link
-Original Message-
From: Kelly Jones [mailto:kelly.terry.jo...@gmail.com]
Sent: Thursday, August 27, 2009 9:44 AM
To: mysql@lists.mysql.com
Subject: Viable alternatives to SQL?
Many sites let you search databases of information, but the search
queries are very limited.
I'm creating a
Isn't that basically the same as pointing phpmyadmin at a read-only copy of the
data?
There's a reason most searches are limited; when you most people too many
options, it's confusing. Good interfaces hide complexity from the end user.
-Original Message-
From: Jerry Schwartz
That procedure is horribly incorrect. You should simply move the
ib_log and ibdata files with the rest of the datadir. The ibdata1 file
contains innodb's system tables and depending on your setting of
innodb_file_per_table it also contains your data!
On Thu, Aug 27, 2009 at 7:56 AM, Jia
Thanks for the tips. Where can I find more details about the ibdata file?
After I changed the data dir, hese file did get recreated. So far, I
have not noticed any data loss yet.
Best,
Jia
Eric Bergen wrote:
That procedure is horribly incorrect. You should simply move the
ib_log and ibdata
Hi, Google isn't my friend :-(
How can I tell mySQL 5.0 to ignore the case of field names i.e. FullName
should also be able to be referenced as fullname,fullNAME etc ?
I'm running it on a linux box at home but my copy at work (running on
Windows 2000 server) has this by default - I certainly set
http://dev.mysql.com/doc/refman/5.0/en/case-sensitivity.html
You need to set the field format to a non binary one, and case
insensitive will be the default.
On Aug 27, 2009, at 2:57 PM, Adrian Aitken wrote:
Hi, Google isn't my friend :-(
How can I tell mySQL 5.0 to ignore the case of field
Hi Scott, it's not the values I have a problem with, it's the fieldnames
themselves. As an example the mysql.user table has 'Host' but when I do an
update setting 'host' to a value it fails to update. I have to enter 'Host'.
The mysql.com link seems to only talk about field values.
Regards
Oops, sorry about that. My understanding is this is OS dependent:
http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html
You may be able to set lowercase tables names, but would always have
to use lowercase. I would just stick to entering in the correct case,
as the other
On Aug 27, 2009, at 5:11 PM, Adrian Aitken wrote:
Hi Scott, it's not the values I have a problem with, it's the
fieldnames
themselves. As an example the mysql.user table has 'Host' but when I
do an
update setting 'host' to a value it fails to update. I have to enter
'Host'.
The mysql.com
16 matches
Mail list logo