Hi Mickey and others,
Here is the location of the lxrun information.
ftp://ftp2.sco.com/pub/skunkware/emulators/lxrun-FAQ.html
This is for lxrun. MySQL does run in a native form on mysql and it uses
gcc. To build or run MySQL on OpenServer you need to install the
libraries and linker from
This should be simple, no? I can't make it work
Objective:
- bring up a panel to ask for MySQL User/Host/Password and save settings if
we get logged in.
- when we start (likely on a new machine) create a new Weather DB if it
doesn't exist
- when we start ( ) create a new TimeTable table if
Hello list,
I have to move a database in MSSQL to MYSQL, with the table
structures and all the respective data. I tested one product to do this,
SQLyog, and it works fine, except for some little problems with indexes
and primary/secondary keys. I want to know if anyone have been dealing
Hi all,
I have two question about UDF(User Defined Function)
(MySQL-4.1.1-alpha-Max-log and 4.0.18-log)
1. how to get character_set_* in UDF.
I want to get following character_set_* information in UDF.
MySQL-4.1.1:
character_set_serve
character_set_system
character_set_database
Hi Boyd,
Can I ask why it really matters? :-) I would assume the DEFAULT value
is stored at creation time; but the end result would be the same either
way.
BTW, I hate how MySQL's SHOW CREATE TABLE quotes DEFAULT INT-family
values. :-( It shouldn't do that.
Matt
- Original Message
Hi sascha,
How's the space on your datadir partition (or wherever this table is)?
I believe MySQL creates the temp tables during ALTER in the DB
directory, not the tmpdir.
If the space there is OK, have you checked the error log for anything
related?
Matt
- Original Message -
From:
Hi Steve,
You might want to look at FLUSH TABLES WITH READ LOCK. That's a query
to run from mysql, but I'm sure you can get it to work in your shell
script (you need to maintain the MySQL connection while doing the
backup). I don't know much about that, though. I think you just run
UNLOCK
Hi Matt, thanks for the help.
Meanwhile the index has been built, and I assume it's a problem of
terminal sessions:
At first I tried it with a remote mysql client issuing the ALTER TABLE
command. This session was closed after some inactivity.
Then I logged in to the database host and retried
David Carlos Brunstein [EMAIL PROTECTED] wrote:
By these days I'm facing a system DB migration to MySQL (the last
production version) and I have the followin problem. All the SELECTs
sentences are all over the application, and for date/datetime filters
are using the dd/mm/ format in the
mail2web - Check your email from the web at
http://mail2web.com/ .
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
hi
I have redhat 7.2 running on my server with plesk
i forgot mysql password for user root
so i reset it by following way
services mysqld stop
safe_mysqld --skip-grant-tables
mysqladmin -u root fulsh-privileges password newpassword
services mysqld restart.
now i can logon to mysql by root
Hello,
I have a database with fields :
- firstname
- lastname
And I want to do a search from the query string john smith in order to
find anyone having john in his firstname and smith in the lastname or smith
in the firstname and john in the lastname.
It tried :
SELECT * FROM members WHERE
Hello again,
To follow my previous message, the CONCAT method does works, but now my
problem is to make a search where the order doesn't count : then to find
members whose firstname is john, lastname smith and vice-versa.
I would like to use an operator or a function for this, but I cannot
On Saturday 10 April 2004 08:15 am, [EMAIL PROTECTED] wrote:
hi
I have redhat 7.2 running on my server with plesk
i forgot mysql password for user root
so i reset it by following way
services mysqld stop
safe_mysqld --skip-grant-tables
mysqladmin -u root fulsh-privileges password
Hmm.
You might be best off using the FIND_IN_SET function (check the manual at
mysql.com for more information).
In short, if you replace all spaces in your string to search with commas,
you should be able to do something like:
SELECT * FROM xyz WHERE FIND_IN_SET(test_column, your string here)
Hi All;
I would like to take a moment to announce the launch of
http://uc2004.vbmysql.com. This site is intended to serve as a resource for
the MySQL community as a blog collection and photo gallery related to the
2004 MySQL User Conference Expo
warning: complete db server newbie!
(I've done plenty of SQL JDBC coding, but never
had to care about the server side until now ;-)
Installed the binary distribution packages for Mac OS X:
mysql-max-4.0.l8.pkg
MySQLStartupItem.pkg
no problem.
But then when trying to configure the root user
Hi Egor.
Thanks for your answer. I'm relatively new to MySQL.
Isn't any way -like an environment variable or configuration file
setting or something like that- to change the date format at the MySQL
side, not at client side ?
Regards,
David.
==
David Carlos Brunstein
Hi,
Thanks to the reply from Sergei, I understand why
MySQL requires SAME block size on all indexes when
load index into cache
However, this feature basically useless for the table
that has any fulltext index. Based on what I've seen,
fulltext indexes use 2048 block size, whereas others
use
I am trying to optimize a query using both BETWEEN and ORDER BY but
after months of reading and research I still can not get the hang of
this. Details are as follows:
2 Tables
CREATE TABLE `p_ad` (
`id` int(11) NOT NULL auto_increment,
`cat` mediumint(9) NOT NULL default '0',
`title`
I needed 5to do some subqueries. I had mysql-3.23. Somehow I thought
mysql4 included subqueries. Loaded mysql-4.0. Converted everything and
got it working except it doesn't do subqueries. Therefore we installed
mysql-4.1.1 6 hours of figuring out the permissions finally we got the
databases all
I needed to do some subqueries. I had mysql-3.23. Somehow I thought
mysql4 included subqueries. Loaded mysql-4.0. Converted everything and
got it working except it doesn't do subqueries. Therefore we installed
mysql-4.1.1 6 hours of figuring out the permissions finally we got the
databases all
hi
I am new to mysql and have a create script that when sourced throws a syntax error.
The script :
CREATE TABLE employee (
id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
name VARCHAR(255) NOT NULL,
PRIMARY KEY(id)
)
TYPE=InnoDB;
CREATE TABLE position (
id INTEGER UNSIGNED NOT NULL
Howdy all,
I am having trouble configuring my server parameters
with my.cnf because there seems to be several mysql
server instances (mysqld processes) running on my
linux box. What I would like to do is bump up the
innodb_buffer_pool_size on the server to 512M (the box
has 3GB of RAM). The
I learned that there are three types of indexes (PRIMARY, UNIQUE, and
INDEX).
Now assuming I create a performance-critical PRIMARY key, will I better have
to specify UNIQUE and INDEX for this column also !? It should be obvious
that a primary key is unique anyway, and an index as well, shouldnt
I suppose this would be easier with subselects but I am using MySQL 4:
I want all orders that are of orderStatus 2 and whose orderitems
contain a product that is in a productparent category greater than 2.
An orderitem can only have one product, and that product has a single
certain product
Hi Rodrigo.
I'm facing a similar task but from Informix to MySQL. What I do is:
1. Obtain a SQL script to create the logical database (an Informix tool
give it). You can use Erwin, with reverse engineer and the save the
script.
2. Add the Type=INNODB clause for each CREATE sentence.
3. Divide
27 matches
Mail list logo