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
with
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 tabl
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 th
Hi,
I'm new to the list.
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 WHERE clause. Is the same i
Only if you incorporate mysql into your app--for example, if your app is a
database system based on the mysql engine. An app that merely "talks to"
mysql doesn't require you to license it.
- Original Message -
From: "John Mistler" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday,
I thought I read that if your app is not GPL and interacts with MySQL in any
way, you must license MySQL.
on 4/9/04 5:16 PM, Dan Bowkley at [EMAIL PROTECTED] wrote:
> Exactly. The license only becomes an issue when you distribute mysql
> itself. Essentially, the gist is you can't charge people
Hello:
I have need to declare a column as type integer then default is at '0'
(that is a string with a zero in it).
An example may be:
Create table foo (
foo_id int not null default '0'
)
My question centers on the notion of implicit type conversion. Is the
server converting the type
MIchael, Point well taken.
Cheers,
Adam
On Apr 8, 2004, at 2:47 PM, Michael Stassen wrote:
Good point. I was focused on the question of using the alias to
restrict results, so I left the function in the SELECT part. As you
say, in this query, that would just give a useless column of '1's, so
Exactly. The license only becomes an issue when you distribute mysql
itself. Essentially, the gist is you can't charge people for mysql; only
mysql can do that. You could, OTOH, let folks get your php app, and provide
a link so they can download mysql themselves.
- Original Message -
F
Hi all,
I am still a bit confused as to the license for using MySQL.
If I create an application in PHP, that uses a MySQL database (for
example a shopping cart application) and I want to sell this
application (not open source), am I required to pay a license fee?
I found this quote:
"2. Free
BT> Hello again,
BT> I have a form that users fill out and submit into a mysql database using php.
BT> The problem I have is that there is only one unique field in the main
BT> table... it's an int that's auto-incremented with each new entry. This works
BT> fine unless the user accidentally sub
Hello again,
I have a form that users fill out and submit into a mysql database using php.
The problem I have is that there is only one unique field in the main
table... it's an int that's auto-incremented with each new entry. This works
fine unless the user accidentally submits the data twice.
I'm trying to build a fulltext index on a table with about 4 million
entries with 2 varchar and one text field.
The indexing starts and runs for about 1/2 to 1 hour, then the process
stops without any error message. And leaves me with no index. I checked
for the size in tmp and redirected it to
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Christos Karras wrote:
> Yes, I use JDBC (with the MySQL Connector/J driver). I did not find a
> way in the JDBC API to escape a string before inserting it in a SQL
string.
> The JDBC PreparedStatement class is able to escape parameters (in a
> databa
Friday, April 09, 2004, 8:59:48 PM, Rohan Shrivastava wrote:
RS> there are some tables named
RS> columns_priv and tables_priv
RS> are you talking about these
Yes.
In this case check permissions on the MySQL data dir and files.
MySQL should be owner of the data dir.
RS> Regards
RS> Rohan
>> "Roh
Philippe,
- Original Message -
From: "Philippe Lewicki" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Wednesday, April 07, 2004 12:51 AM
Subject: Re: read_key: Got error 146 when reading table
> Heikki,
>
> Its: mysql-standard-4.0.17-pc-linux-i686
thank you for the bug
Mark,
- Original Message -
From: "Mark Susol|Ultimate Creative Media"
<[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Thursday, April 08, 2004 11:25 PM
Subject: Re: Corruption and my.cnf
> > I've experienced more corruption lately on my main site since I moved to
=
> my
>
Brad Tilley <[EMAIL PROTECTED]> wrote:
>
> Is there a way to do regex search are replace on all entries in a mysql field?
> Or, a way to uppercase or lowercase all characters for all entries in a
> filed? Some of the fields are varchars with numbers and letters. In my
> particular case, I have
Lecho <[EMAIL PROTECTED]> writes:
>I have a db with objects table, each of those objects may belong to groups
>of objects. The number of groups can be about 256 and an object
>belongs from one to many different groups at once.
Lecho,
I threw together the following tables/data/queries that I b
"Rohan Shrivastava" <[EMAIL PROTECTED]> wrote:
> hello,
>
> I have installed mysql-3.23.58-pc-linux-i686 on Red Hat 9.0,
> while starting daemon i got the following message:
>
> ./bin/safe_mysqld --user=mysql &
> [1] 5240
> [EMAIL PROTECTED] mysql-3.23.58-pc-linux-i686]# Starting mysqld daemon w
On Fri, 9 Apr 2004, Mickey wrote:
> I am trying to install Mysql
> (mysql-standard-4.0.18-pc-linux-i686.tar.gz) on my 'SCO_SV 3.2 5.0.5
> i386' unix machine.
This is for linux. Do you have the lxrun installed? If you have lxrun
installed and updated to the lastest libraries then it will work.
Hello again,
Is there a way to do regex search are replace on all entries in a mysql field?
Or, a way to uppercase or lowercase all characters for all entries in a
filed? Some of the fields are varchars with numbers and letters. In my
particular case, I have a field of serial numbers some of wh
Hello,
I am trying to install Mysql (mysql-standard-4.0.18-pc-linux-i686.tar.gz) on my
'SCO_SV 3.2 5.0.5 i386' unix machine.
When unzipping and untarring the file when I try to run the scripts/mysql_install_dn
program I get a bunch of error messages. Here is what I get :-
WARNING: The host
On Friday 09 April 2004 12:26 pm, Mark Susol | Ultimate Creative Media wrote:
> Ok now I want to "dump" tables with names starting with "phpads" so I can
> move them to another db. How is the mysqldump command run then?
>
> And when I go to move them to the new db, I do use the mysqldump command
>
On Fri, 2004-04-09 at 09:48, [EMAIL PROTECTED] wrote:
> Hello,
>
> I've recently came across a problem I couldn't seem to solve right by myself.
>
> I have a db with objects table, each of those objects may belong to groups
> of objects. The number of groups can be about 256 and an object
> belon
hello,
I have installed mysql-3.23.58-pc-linux-i686 on Red Hat 9.0,
while starting daemon i got the following message:
./bin/safe_mysqld --user=mysql &
[1] 5240
[EMAIL PROTECTED] mysql-3.23.58-pc-linux-i686]# Starting mysqld daemon with
databases from /usr/local/mysql-3.23.58-pc-linux-i686/data
Looks like it could be a bug. I'll check it out.
> -Original Message-
> From: tweewan.wong [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, April 07, 2004 8:13 PM
> To: [EMAIL PROTECTED]
> Subject: RE: Using BYTEFX to connect to MySql , closing connection do not
> release the connection.
>
>
Ok i worked out a possible bug with mysql 4.1 compiling openssl on solaris
i keep getting this error
gcc -DDEFAULT_CHARSET_HOME=\"/usr/local/mysql\" -DDATADIR=\"/usr/local/mysql
/var
\" -DSHAREDIR=\"/usr/local/mysql/share/mysql\" -DDONT_USE_RAID -I. -I. -I..
-I..
/include
/opt/csw/include/openss
Hello,
I've recently came across a problem I couldn't seem to solve right by myself.
I have a db with objects table, each of those objects may belong to groups
of objects. The number of groups can be about 256 and an object
belongs from one to many different groups at once.
I cannot find a good
Michael:
Thanks. It did the trick.
Kirti
-Original Message-
From: Michael Stassen [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 08, 2004 6:32 PM
To: Kirti S. Bajwa
Cc: [EMAIL PROTECTED]
Subject: Re: Perl Modelues
Kirti S. Bajwa wrote:
> Ken:
>
> Thank you for your response. I trie
>> Ah..I see now. I was still using mysqldump..instead of mysql. Yes I'm
>> trying to import the data from backup, into an empty table since the data
>> was corrupt.
>
> Looks like you are on the right track now! :)
>
> James
Ok now I want to "dump" tables with names starting with "phpads" so I
"sdf sdf" <[EMAIL PROTECTED]> wrote:
> When configurating a dual master setup do I need to set
> parameter
> log-slave-updates ?
>
MySQL supports only one master for slave. What do you mean "dual master setup"?
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This
On Friday 09 April 2004 11:40 am, Mark Susol | Ultimate Creative Media wrote:
> > On Friday 09 April 2004 11:29 am, you wrote:
> >> I'm not getting an error..I'm getting inserts that are NOT in the file
> >> I'm directing it to dump. Maybe I don't understand the dump function and
> >> how it works
> You could do something like this:
>
> $start = 0;
> if (isset($_GET['start'])) {
> $start = 1 * $_GET['start']; //make sure it's numerical
> }
>
> then query:
> SELECT .. FROM .. ORDER BY date LIMIT $tart, 1
>
> display the comment
>
> $start++;
>
> provide a link to thispage.php?
That didn't work but it led to something that did. It turned out that
the owning group didn't have full authorization in the data folder. So,
I did a brute force approach. I made mysql the owner of everything,
instead of root, made mysql the group of everything (which it already
was), then made
> On Friday 09 April 2004 09:52 am, Mark Susol | Ultimate Creative Media wrote:
>> I'm trying only to update one table from a backup. I have the sql file
>> stripped down to just the INSERT commands. I have emptied the table from
>> phpMyadmin to start.
>>
>> How do I load this sql file so it runs
Tim McDonough writes:
>The solution I presently have does a query for the first criteria.
>Then, I loop through the results of that query and do another query
>for each returned row. This produces the desired results but requires
>a lot of queries, i.e.-- if the first query returns 1000 customer
> > We have a DB of customer comments that we want to display one at a time
on
> > our web site. We want the web pages (wrote in php) to use a user
> > name/password on the DB that has SELECT ability and that's it.
> >
> > What's the best way to cycle through the comments so that each page
> > req
Hi all--
We have one master and 12 slaves replicating from it. Server is 4.0.16
(havn't wanted to take it down to upgrade), the slaves are 4.0.17, all
running on RedHat AS. Lately, every few hours one of the machines caughs
up this error, and quits replicating:
Could not parse relay log event e
Just realized my subject wasn't correct, we don't want the next field, we
want the next row...
Thanks!
> We have a DB of customer comments that we want to display one at a time on
> our web site. We want the web pages (wrote in php) to use a user
> name/password on the DB that has SELECT ability
We have a DB of customer comments that we want to display one at a time on
our web site. We want the web pages (wrote in php) to use a user
name/password on the DB that has SELECT ability and that's it.
What's the best way to cycle through the comments so that each page
requested gets the "next"
Mark Susol|Ultimate Creative Media <[EMAIL PROTECTED]> wrote:
> I'm trying only to update one table from a backup. I have the sql file
> stripped down to just the INSERT commands. I have emptied the table from
> phpMyadmin to start.
>
> How do I load this sql file so it runs all of the inserts in
I found a place that say MYSQL has a limit for the size off the packet
in relation with blob field. They say that you need to put this in the
my.cnf "set-variable = max_allowed_packet=15M". With that you increase
the size to 15 mb
You can go and check the code in
http://www.mysql-hispano.org/page.
On Friday 09 April 2004 09:52 am, Mark Susol | Ultimate Creative Media wrote:
> I'm trying only to update one table from a backup. I have the sql file
> stripped down to just the INSERT commands. I have emptied the table from
> phpMyadmin to start.
>
> How do I load this sql file so it runs all of
Yes, I use JDBC (with the MySQL Connector/J driver). I did not find a
way in the JDBC API to escape a string before inserting it in a SQL string.
The JDBC PreparedStatement class is able to escape parameters (in a
database specific way) with the setString(parameterIndex, string)
method, but it's
I'm trying only to update one table from a backup. I have the sql file
stripped down to just the INSERT commands. I have emptied the table from
phpMyadmin to start.
How do I load this sql file so it runs all of the inserts in this file
through ssh (70MB)?
Mark Súsol
--
> I have an application where I want to look for records that match
> certain criteria and then for each item found do a second lookup for
> additional information. Normally I would do a join. In this case
> however I want to display each of the results from the first of the
> two criteria whether
* Tim McDonough
> I have an application where I want to look for records that match
> certain criteria and then for each item found do a second lookup for
> additional information. Normally I would do a join. In this case
> however I want to display each of the results from the first of the
>
Perhaps stated a bit more correctly:
Apache is NOT unique to Linux, so any system using Apache would need this
configuration, that would include windows, MAC OS, Solaris, Irix, etc.
Can't blame the OS on a softwares requirements...
Dan.
At 08:07 AM 4/9/2004, Paul Smith wrote:
%% Dan Nelson <[EMAI
Can you create a 'fact' table containing the infomration that you are
querying? This goes
against normalization but if the table will only be used for querying
purposes then this
will eliminate your need to perform joins.
-Original Message-
From: Tim McDonough
To: [EMAIL PROTECTED]
Sent:
I have an application where I want to look for records that match
certain criteria and then for each item found do a second lookup for
additional information. Normally I would do a join. In this case
however I want to display each of the results from the first of the
two criteria whether or not the
I ahve a problem with updating a row using a field from another row in the
same table.
The mySQL manual says:
Error 1093 (ER_UPDATE_TABLE_USED)
SQLSTATE = HY000
Message = "You can't specify target table 'x'
for update in FROM clause"
This error will occur in cases like this:
Hi!
On Apr 08, Haitao Jiang wrote:
> Why Mysql "load index ... into cache" require the same
> size index block when it creates indexes in different
> block sizes (1k or 2k)? I don't understand.
It's limitation of the current implementation :(
It reads MYI file successively by fixed chunks
(multip
[EMAIL PROTECTED] wrote:
> We have been looking and looking for some guidance for installing MySQL with
> SSL on a SuSE 9.0 box. By searching the archives, the net using Google,
> etc., we keep finding pieces of the puzzle, but no single piece that covers
> all of the ground.
>
> The problem is t
%% Dan Nelson <[EMAIL PROTECTED]> writes:
dn> That is because although Linux binaries can access files over 2gb,
dn> they do not do so by default. Apache was probably not compiled
dn> with the required defines (-D_LARGEFILE_SOURCE
dn> -D_FILE_OFFSET_BITS=64), so that's why it stops at 2gb
Hi Ciprian,
OK, I'm by no means a DB guru, so a) take this with a grain of salt
and b) feel free to tear it apart if I'm completely wrong! ;]
If in fact your people and city tables aren't going to change very
often, then why don't you just go all the way and keep that
informatio
Pascal Francq wrote:
OK, you use a C "char*" using an UTF-8 encoding.
That's very commmon in the Unix world. 2-byte encodings are very rare
on Unix-like systems, for compatibility reasons.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://li
OK, you use a C "char*" using an UTF-8 encoding.
On Friday 09 April 2004 11:45, Hirofumi Fujiwara wrote:
> > Hi,
> > I have a question. I have read that since MySQL 4.1, VARCHAR type can
> > hold unicode characters. But, it seems that the API of the C library use
> > to send queries to the server
Hi,
When configurating a dual master setup do I need to set
parameter
log-slave-updates ?
/J
_
Hitta rätt på nätet med MSN Sök http://search.msn.se/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsu
* dan orlic
> INSERT INTO cp.Items SELECT distinct g.RecordID as id,'' as
> category_id, '' as pattern_id,'' as manufacturer_id, g.Item + g.Desc1
> + g.Desc2 + g.Desc3 as description, g.Desc4 as price,0 as quantity, ''
> as comments,'Active' as status,'n' AS is_bridal, 'Gallery' AS type,
> now() as
Env: Win2003 Server, MySql 4.17
I've the following table
CREATE TABLE TabellaTipi (
id int unsigned NOT NULL AUTO_INCREMENT,
intero int,
lungo bigint,
decimale decimal(20,10),
data datetime,
stringa varchar(100),
booleano tinyint unsigned,
> Hi,
> I have a question. I have read that since MySQL 4.1, VARCHAR type can hold
> unicode characters. But, it seems that the API of the C library use to send
> queries to the server still use 'const char*' for the type of the query.
> So, praticaly, if I have a unicode string stored in C, how
Start another Mysql shell session; then do "show processlist"; identify
the thread ID of the offending process, then do "kill ". Not sure
how graceful this method is, though. I use it to kill overlooked hanging
connections from time to time.
Cheers,
Vadim.
Scott Haneda wrote:
Every now and th
63 matches
Mail list logo
