Hi!
I have LAN with some PC, which use MySQL database. Sometime power supplay failure
occurs. I have back-UPS too, but them can't hold power for 2 or more hours and because
it server loose power supplay and just stop (without correct system shut-down).
I got such problem: I waste data in
How to round the result number after the multiplication,
below are the PHP codes,
any help greatly appreciated
?php
If (@$rcurr ==)
{ echo ();
?
?php
while ( $row = mysql_fetch_array($result) )
{ echo(tr);
echo(td . $row[Room_Category] . /td);
echo(td . $row[Room_Size] .
Hi Andis.
I have no experience with this, but once your UPS kicks in
can you schedule a graceful shutdown after some number
of minutes?
On my Red Hat 7.0 machine, I see this in /etc/inittab:
# When our UPS tells us power has failed, assume we have a few minutes
# of power left. Schedule
Hi, I have a problem. I have unzip the file with winzip, but I couldn't get it to
install.
I downloaded both the 3.22 and 3.23 verison, but I still couldn't get it to work as
install. my teacher in school told me to install it with winzip and then use
mysqladmin to work, but I couldn't get
Andis wrote:
I have LAN with some PC, which use MySQL database. Sometime power supplay failure
occurs. I have back-UPS too, but them can't hold power for 2 or more hours and
because it server loose power supplay and just stop (without correct system
shut-down).
I got such problem: I
Hello All,
When I use order by .. DESC in query, time always more then in
order by .. ASC case.
Explain say Using filesort,in DESC case query.
Why???
Why I can't use key value in select like that:
select * from TableName where KEY(KEYNAME)concat('value1','value2')
or
select * from
How to round the result number after the multiplication,
below are the PHP codes,
any help greatly appreciated
?php
If (@$rcurr ==)
{ echo ();
?
?php
while ( $row = mysql_fetch_array($result) )
{ echo(tr);
echo(td . $row[Room_Category] . /td);
echo(td . $row[Room_Size] .
if you are working on windows, unzip the file using winzip classic and then
use the extract function to extract the files to a desired directory. after
that, just click on setup.exe to setup mysql.
regards
shane
-Original Message-
From: Maggie Cheang [mailto:[EMAIL PROTECTED]]
Sent:
Can this be done? What I want is to generate a list of journal sorted by
the titles, ignoring the leading articles (the, a, an, etc.). If there is
no SQL statement for this, How could I do this w/ DBI or PHP? I am using
mysql 3.23.40 on Solaris 7. Thanks for any advise.
Bin
hi all..
this error came out after i make backup for my database using mysqldump
what this error say is wrong... maybe my database is corrupt or crash or something
like that.. any command can fix this error..?. any idea what i should do.
Database error: Invalid SQL: select id, subid from
hi all..
this error came out after i make backup for my database using mysqldump
what this error say is wrong... maybe my database is corrupt or
crash or something like that.. any command can fix this error..?.
any idea what i should do.
Please paste the output of typing DESCRIBE
Ok problem.
Upgrade from 3.23.37 to 3.23.40 on linux readhat 7.0 - using rpm
and after the uppdate I get : Cant find file ./mysql/host.frm (error: 13)
so I copied the db and run mysql_install_db, still get the same msg,
So I checked the error 13 = permission denined.
So I doublecheck tthe
In PHP specifically, no clue.
Using Perl, something like so (and this assumes a 1:1 mapping on
titles/ids):
my $get_art_list = $sql-prepare(eosql);
SELECT title, id
FROM table
eosql
$get_art_list-execute;
my %articles;
while (my $art = $get_art_list-fetchrow_hashref) {
Error 13 is permission denied.
Mysql does not own the files.
chown -R mysql /var/lib/mysql ( Or whatever )
Roger Westin wrote:
Ok problem.
Upgrade from 3.23.37 to 3.23.40 on linux readhat 7.0 - using rpm
and after the uppdate I get : Cant find file ./mysql/host.frm (error: 13)
so I copied
Hello,
I'm having a problem with MySQL when it runs for a couple of days. At some
time mysqld 'forgets' where it's databases are and searches for them in the
mysql temp dir. (In my case /var/tmp). In the tmp dir there is always the
recover directory for vi (vi.recover) so mysqld thinks that it's
PD At 10:43 AM +0530 7/25/01, [EMAIL PROTECTED] wrote:
Hi,
I just want to know how to insert a BLOB data type in a field of a
table. I want to put the binary data stream not the file link in the
filed. The language i m using is PERL5.
PD Use $dbh-quote() or placeholders to insert the BLOB
I don't know if I can do a query such as this. Could someone please help...
SELECT
B.name Boat name,
(CASE WHEN B.motor_sail=S THEN Sail boat
WHEN B.motor_sail=S THEN Motor boat
WHEN B.motor_sail=S THEN Paddle boat
ELSE Unknown END),
IF(B.age=0,NEW,B.age) Years old,
Artem V. Ryabov writes:
Hello All,
When I use order by .. DESC in query, time always more then in
order by .. ASC case.
Explain say Using filesort,in DESC case query.
Why???
--
Best regards,
Artem mailto:[EMAIL PROTECTED]
Hi!
This is a known
Stephen,
you have to add to the my.cnf or my.ini file
the following parameters, to the [mysqld] section:
Suppose you have a Windows NT machine with 128 MB RAM and a single 10 GB
hard disk. Below is an example of possible configuration parameters in
`my.cnf' for InnoDB:
[mysqld]
# You can write
On 2001 Jul 23, [EMAIL PROTECTED] wrote:
Description:
Whenever I compile mysql 3.23.40 with Berkeley DB support,
I get a signal 11 when attempting to start the mysql server.
If I omit Berkeley DB support, everything starts fine.
Synopsis:solairs 8 x86 get signal 11
Hi, got a problem:
My table (part of it) looks like this:
CREATE TABLE cust (
id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
name CHAR(30) NOT NULL,
PRIMARY KEY (id)
);
When i type
INSERT INTO cust VALUES(NULL,Peter);
the value of id will increase by 1 every time i insert a record.
By misstake
what's the easiest way to transfer a local database to a remote one?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this
When installing mysql the only problem I receive is the following
which cannot install the grant tables. I am unable to view the log
because my access is denied.
What to do? Anyone?
[localhost:/usr/local/bin] nezi% ./mysql_install_db
mkdir: /usr/local/var/mysql: Permission denied
chmod:
- Original Message -
From: Jay McGarry [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, July 25, 2001 7:57 AM
Subject: Mysql
what's the easiest way to transfer a local database to a remote one?
Depends on many factors really. Are you doing this as a one-off thing or
something
hi all,
I'm having a problem wrt character sets in mysql. i'm trying to add the euro
symbol to a table (MyISAM), but it seems that it is being replaced with '?'.
Having looked into the problem a bit, I assume it is that the table is using the
default latin1 character set, which does
Try doing it as root if you're not already.
Tyler Longren
Captain Jack Communications
[EMAIL PROTECTED]
www.captainjack.com
- Original Message -
From: Michael Nezi [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, July 25, 2001 11:08 AM
Subject: Problems running
I hope this is not to stupid.
I have looked at how to encrypt strings in my database. I know that you need
to use a blob
and I think I can figure out how to encrypt from a query or SELECT but how
do I
encrypt on the INSERT.
Thanks for your help
Jason
Hello !
This is a syntax taken from MS Access:
SELECT messages.message_id, messages_1.message_id
FROM messages AS messages_1 INNER JOIN (messages INNER JOIN connections ON
messages.message_id = connections.parent) ON messages_1.message_id = connections.child
ORDER BY messages.message_id,
Hi,
I have looked through the documentation (http://www.mysql.com/docs)
and the mailing list archives
(http://www.geocrawler.com/lists/3/Databases/8/0/)
and find no mention of a feature that I was hoping was available:
* text or varchar columns that are automatically compressed/uncompressed
I recently did my first mySQL installation (the OS is Linux). How can
I set up users so that they do not need to supply a password to use
mysql?
I want to be able to issue commands like
mysql -e select host,db,user from db mysql
instead of having to do something like
mysql -e select
At 10:44 AM -0600 7/25/01, Michael Nezi wrote:
Saw your post on mysql.com and wondering if you could help me.
Working with the Mac OS X Terminal
Mac OS X comes with a Terminal application that can be used for
issuing instructions to the OS from a command line. You will find it
necessary at
Hi-
I am getting error 127 and I cant seem to get the myisamchk command to work for me.
Can anyone help me with this issue?
Is there a phone-based support option available? Money is no object - I am desperate
and looking to fix this issue before my client finds out.
Thanks,
Marko
Hi,
It seems like what you are trying to do is select all messages
that have child messages and display the results sorted by the
parent message ID.
How about...
select
messages.message_id,
messages_1.message_id
from
messages,
connections,
messages
Greetings: I was wondering if anyone has any ideas about the best way to
store credit cards in a database ... and I'm not referring that much to the
field type, but rather encrytption techniques.
Thanks.
Alan Cox
[EMAIL PROTECTED]
At 5:23 PM +0400 7/25/01, Ilya Martynov wrote:
PD At 10:43 AM +0530 7/25/01, [EMAIL PROTECTED] wrote:
Hi,
I just want to know how to insert a BLOB data type in a field of a
table. I want to put the binary data stream not the file link in the
filed. The language i m using is PERL5.
PD
At 4:47 PM +0200 7/25/01, Peter Wiherkoski wrote:
Hi, got a problem:
My table (part of it) looks like this:
CREATE TABLE cust (
id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
name CHAR(30) NOT NULL,
PRIMARY KEY (id)
);
When i type
INSERT INTO cust VALUES(NULL,Peter);
the value of id will
At 9:02 AM -0700 7/25/01, John Meyer wrote:
http://builder.cnet.com/webbuilding/0-7537-8-6580620-1.html?tag=sd
It's a general overview of MySQL, but it's a pretty fair comparison.
From the article:
Transactions and commit/rollback is another management feature
that's not directly supported
Only use placeholders. $dbh-quote() is unreliable (and this fact is
documented in DBI documentation).
PD Please show me the part of the documentation that you're referring to,
PD and please supply a counter-example. quote() is extremely useful for
PD producing SQL statements that will be
Dear Maggie,
http://mysql.com/Downloads/MySQL-3.23/mysql-3.23.39-win.zip has a
SETUP.EXE which will install MySQL (database server plus client tools to
work with the server) - by default it will install in C:\mysql. After
setup, it's easiest to restart Windows. Now, the MySQL server should
load.
Dear /roger,
some suggestions ...
- Check mysqladmin variables to get the value for datadir (that's
where the server will expect the mysql database (containing the host
table) to be.
- Check /etc/my.cnf to see if the datadir variable has been set
correctly.
Obviously, your server does not
Dear Zhang,
check for the regular expression section in the MySQL manual. You can
filter out any patterns you want with RegExp :)
Regards,
--
Stefan Hinz
Geschäftsführer / CEO iConnect e-commerce solutions GmbH
# www.js-webShop.com www.iConnect.de
# Gustav-Meyer-Allee 25, 13355
in the mysql command line, try this:
use databasename;
repair table tablename;
(repeat that last line for each of your tables)
I haven't tried myisamchk at all. This is what I use.
Walter
At 12:13 PM -0400 7/25/01, Marko Andrus wrote:
Hi-
I am getting error 127 and I cant seem to get the
to all, warm regards from brazil.
here's the plot: my isp has been complaining
for last couple of days about this query,
generated automatically by a query generator
(no, duh??)...
SELECT * FROM listaemail WHERE id LIKE %% OR nome LIKE %% OR empresa
LIKE %% OR email LIKE %% OR ativo LIKE %%
Hello,
Try
SELECT messages.message_id, messages_1.message_id
FROM messages as messages_1
INNER JOIN connections
ON messages_1.message_id = connections.child
INNER JOIN messages
ON messages.message_id = connections.parent
ORDER BY messages.message_id, messages_1.message_id
or
SELECT
Depending on the 'environment' (i.e. O/S you're using), the tools available
might be different...
But, using Linux (and I'm sure any other 'flavor' of Unix), my company
used the latest 'libmcrypt' to encrypt the credit card numbers (as well as
the user passwords) within a PHP function prior
So sprach »Alan Cox« am 2000-02-20 um 11:57:47 -0500 :
Greetings: I was wondering if anyone has any ideas about the best way to
store credit cards in a database ... and I'm not referring that much to the
field type, but rather encrytption techniques.
'encryption'? Hmm, how about: none? If
Dear Peter,
Even if i delete the record where id=65535
DELETE FROM cust WHERE id=65535
AUTO_INCREMENT starts with 65535 and i cant add any more records.
Sad, but true, MySQL remembers the biggest number inserted into an
auto_increment column. If you delete the row in question, the next
Dear KJ,
How can
I set up users so that they do not need to supply a password to use
mysql?
Use MySQL Monitor (the command line tool, mysql) and type:
GRANT ALL ON *.* TO @%
This will grant all rights on all databases and tables to anyone ()
from anywhere (%) without password.
Hello All,
I've been trying upgrade our current MySQL 3.23.39 to the 3.23.40 I have tired
with both the binary distro and source distro with no luck. The install seems to
go OK, but I can't start the mysql server. This is on a RH/Linux 6.2 Kernel
2.4.6 i686 system.
The main problem seems to be,
the output look like this..
mysql desc policy;
+++--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
+++--+-+-+---+
| service_charge | int(2) | | | 0 | |
hello kynn,
you have to :
first you must UNDERSTAND the USER-table from mysql-DB on your box.
from that point you are able to insert directly values into USERS like
values into any other MySQL-Table:
example:
INSERT INTO USER VALUES
('localhost','Testuser','PASSWORD('little
I am currently trying to examine the benefits of continuing to use MySQL
over Oracle. I need to know what MySQL's features are vs. those of Oracle.
Also I am looking for performance data. What kind of scalability does MySQL
have vs. that of Oracle. Is there (or will there be) any support in
You probably want to GRANT ALL ON oneDatabase.* TO login@%. I can't
image a situation where letting everyone see everything (including
the mysql database with all the permissions) would ever be a good
idea.
Walter
At 7:44 PM +0200 7/25/01, Stefan Hinz wrote:
Dear KJ,
How can
I set up users
George,
current binary versions do not yet support
rows of size 8000 bytes. The next binary
version 3.23.41 will do it.
If you want right now to use 8000 byte rows,
you have to download the source distribution
innodb-3.23.39b from www.innodb.com, replace
the InnoDB files in the source
Hi,
I have configured MySQL with charset latin2 on a Linux box. I made a big
table with a mediumtext filed and a search engine using MySQL
match-against. On the Linux box everything looked fine. Now we replaced
our server to FreeBSD. I compiled the same source with the same
configuration
Did you read about optimizing joins?
Yes I've read the manuals docs.
I see in the manual a section entitled Optimising LEFT JOIN and RIGHT JOIN but my
JOIN in question is neither LEFT or RIGHT.
Can you please point me at some specific URLs ?
thanks,
- Sam.
Werner Stuerenburg [EMAIL
Hello All,
I've been trying upgrade our current MySQL 3.23.39 to the 3.23.40 I have tired with
both the binary distro and source distro with no luck. The install seems to go OK,
but I can't start the mysql server. This is on a RH/Linux 6.2 Kernel 2.4.6 i686
system.
Please disregard this
If this is a MyISAM table you can use myisamchk to set the auto_incriment
value. Check out the man page.
ryan
- Original Message -
From: Stefan Hinz [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; Peter Wiherkoski
[EMAIL PROTECTED]
Sent: Wednesday, July 25, 2001 12:15 PM
Subject: Re:
Do the names of indexes have any significance to MySQL internals or is the name merely
a convenience for the DB operator ?
For now I try to match the index names to the column names used but I'm wondering if
the name matters at all.
thanks,
- Sam.
-
Do You
I think mysqld may have a problem parsing long lines in my.cnf. I recieve
the following error when trying to start mysqld:
/usr/local/libexec/mysqld: unrecognized option `--r3/ibdata31:2G'
Here is the line that is offending mysqld (it is all one line in my.cnf). If
I remove or shorten this
Do the names of indexes have any significance to MySQL internals
or is the name merely a convenience for the DB operator ?
Well, PRIMARY KEY does carry some significance... ;-)
Other than that, no. But you need them if you should ever
want to do an ALTER TABLE to change the index
Dear Peter,
Even if i delete the record where id=65535
DELETE FROM cust WHERE id=65535
AUTO_INCREMENT starts with 65535 and i cant add any more records.
Sad, but true, MySQL remembers the biggest number inserted into an
auto_increment column. If you delete the row in question, the
At 2:55 PM -0500 7/25/01, MikemickaloBlezien wrote:
Hello All,
I've been trying upgrade our current MySQL 3.23.39 to the 3.23.40
I have tired with both the binary distro and source distro with no
luck. The install seems to go OK, but I can't start the mysql
server. This is on a RH/Linux 6.2
How about this:
---
INSERT INTO Table VALUES(Lamer_ID, SELECT ENCRYPT(you are
lame...!,sa));
---
uses the unix-crypt()-function, means, its a One-Way-Crypt!
sa must be a 2-char long
MikemickaloBlezien [EMAIL PROTECTED] writes:
Hello All,
I've been trying upgrade our current MySQL 3.23.39 to the 3.23.40 I have tired
with both the binary distro and source distro with no luck. The install seems to go
OK, but I can't start the mysql server. This is on a RH/Linux 6.2 Kernel
Sorry ---
How about this WITHOUT SELECT:
---
INSERT INTO Table VALUES(Lamer_ID, ENCRYPT(you are
lame...!,sa));
---
uses the unix-crypt()-function, means, its
We have an optimization question that probably could be easily resolved
with some of the additional features of some commercial database products,
but, being stubborn about migrating away from MySQL (What can't it do
again?) I'm looking for a solution to a particular design and optimization
Hi All:)
I'm running mysql-3.23.30-gamma on FreeBSD 4.3-stable and running into a
problem with max file sizes.
I've got a table, names, which is taking 4294967288 bytes. I notice this
is 8 bytes less than 2^32, so I assume there's a 32 bit pointer issue
within mysql somewhere.
At 4:08 PM -0500 7/25/01, MikemickaloBlezien wrote:
On Wed, 25 Jul 2001 16:04:17 -0500, Paul DuBois [EMAIL PROTECTED] wrote:
Source distributions don't really come with any table handler enabled
by default, because there are no binaries included in the distribution.
To see what options control
Mysql:
We have installed mysql 3.23.26 beta version to a BSD 4.2 server. It works
fine, however when we test a php file which just function to insert some
data to a table in database, and display all data on the web page. After
run this, the data have been inserted and displayed;
Greetings all,
I have a RedHat 7.1 on i386 (Pentium III), and I am trying to build the
2.23.40-1 src rpm, and I get the following error:
---
th-extra-charsets=complex --exec-prefix=/usr
--libexecdir=/usr/sbin --sysconfdir=/etc
I've been trying upgrade our current MySQL 3.23.39 to the 3.23.40 I have tired
with both the binary distro and source distro with no luck. The install seems to go
OK, but I can't start the mysql server. This is on a RH/Linux 6.2 Kernel 2.4.6 i686
system.
Please disregard this posting,
On Wed, Jul 25, 2001 at 07:12:17PM +0200, Alexander Skwar wrote:
[snip]
'encryption'? Hmm, how about: none? If you don't need to reconstruct
the cc#, md5 will be good.
Indeed. That is however rarely the case with credit card numbers.
However, if you need to reconstruct it, nothing is safe.
On 7/25/01 at 7:12 PM, Alexander Skwar wrote:
However, if you need to reconstruct it, nothing is safe. And that's
quite simple:
a) You need to get access to the MySQL server. Impossible to do from
the outside if '--skip-networking' is used.
b) So, only possible from the localhost. This
MyVbQL is a direct interface to MySQL databases ... you don't need to use the ADO/ODBC
combination ... you can get some more details on the MyVbQL web page ...
http://www.icarz.com/mysql/index.html
Eric
Stephen Sherlock wrote:
I've been told that it's possible to connect directly to a
In possibility 1, if the database is truly running on local, you should be
able to:
a)mysqldump --all-databases all_that_dump.sql
b)mysql (logon stuff for remote machine) all_that_dump.sql
Because the database is running on local the client (mysql) should also be
loaded.
Have a great
I know I've seen the solution to this somewhere...
Running bin\mysql in a DOS window I find that my up arrow will not recall
commands from a command buffer, even when DOSKEY is loaded in the parent DOS
window. But I know that on a Linux machine where I used to run mysql I could
up arrow through
AND, you'd want to 'protect' the data from viewing if you've 'dumped' the
database or backed it up to an 'insecure' media or location (to
tape/disk)... Encrypting the data, with the 'key' or 'salt' located
somewhere else, would allow you to 'transport' the tables containing the
sensitive data
Hi everyone!
I just install the RH 7.1 with mySQL.
I'm developer JAVA, and I'd like to know how I start
the service (mysql) on linux RH 7.1.
The directory is
/usr/share/mysql
I want to set the port and create a table.
I know the comand to create a table, insert data and
so on...
But I dont
Hi all,
I have a problem, I have some VARCHAR data in a column called Sequence
looking like this:-
5;6
12;6
120;6
5;6;1
12;6;12
120;6;105
So there could be anything from 2 to n numbers seperated by ;
Each number could be 1 to 3 digits long (eg 5 12 or 121).
I have tried various searches like
At 6:52 PM -0400 7/25/01, Alan Zaitchik wrote:
I know I've seen the solution to this somewhere...
In the manual:
http://www.mysql.com/doc/W/i/Windows_running.html
You want to use mysqlc, not mysql.
Running bin\mysql in a DOS window I find that my up arrow will not recall
commands from a
I have a date field, how do I check if it is null or
empty in sql statement.
I tried :
select *
where fDate = NULL;
and also tried
where fDate = '';
Both return nothing but actually there are records
with no value.
Hi all,
I am currently researching an issue with slave thread terminating when an
error occurs.
background:
Win2000 server SP2
MySQL server/client ver 3.23.38
MySQL ODBC ver 2.50.33
Program language Clarion 5.5
Our database program can insert and update records without a problem. When a
new
You can always degrade the credit card.
1) verify AUTH ONLY (not capture) with your CC provider. (if you want to verify they
have funds available and the CC is valid)
2) store the CC # in the database
3) ..do your order processing thing or whatever you need to have the CC for...
4) capture
Could anyone shed some light on how to go about uploading a text file with a
web interface using php into a mysql database. wow, that was a mouthfull.
I would much appreciate it.
Kit
_
Get your FREE download of MSN Explorer at
Apologies in advance:
I am a developer with mysql and active and my work
involved CAPI of MYSQl,Database DeZign with Dezign and
database development.
Currently looking out for job opportunities in mySQl
related areas.Can suggest me any exclusive websites
and openings in mysql related areas.
(please reply directly)
I'm new to mysql and I'm working on a design for an
application that will require aLOT of lookups on IP addresses. Data
set is on the order of millions of addresses. In my reading, I have not
encountered a TYPE of ip_address or some such. Did I miss it?
If there is
At 10:17 AM +1000 7/26/01, Alan Tse wrote:
I have a date field, how do I check if it is null or
empty in sql statement.
I tried :
select *
where fDate = NULL;
Wrong test. NULL is special. Use:
where fDATE IS NULL
and also tried
where fDate = '';
Both return nothing but actually there
At 7:53 PM -0600 7/25/01, David Lott wrote:
(please reply directly)
I'm new to mysql and I'm working on a design for an application that
will require a LOT of lookups on IP addresses. Data set is on the
order of millions of addresses. In my reading, I have not
encountered a TYPE of
Since the dump is ascii text with lots of repeating characters, it should
zip or gzip quite nicely.
The compressed file will take a lot less time in transfer over FTP, if
network time/bandwidth is a problem. This becomes important when doing
over-WAN stuff.
The time involved for 1-3GB arch logs
At 10:11 PM -0500 7/25/01, Mike wrote:
I have throughly looked at the documentation and I am beginning to
get frustrated. It says that a LONGTEXT field's max length is L+4
bytes, where L 2^32. I understand the extra 4 bytes(+4) which is
to keep track of the size sense LONGTEXT is no more than
I would suggest that you use an INT column type to store the ip address.
This would use a lot less space than a varchar column (when dealing with the
magnitude that you describe)... the smaller the faster... The following
functions make this very easy:
INET_NTOA and INET_ATON
They are described
I recently moved my MySQL databases from one RedHat Linux 6.x machine to a new RedHat
7.0 machine. Now, I can't seem to add databases. I get the following error message:
mysqladmin: CREATE DATABASE failed; error: 'Can't create database 'jrtest'. (errno:
13)'
And, I think I lost some
On Wed, 25 Jul 2001, Paul DuBois wrote:
I doubt if they are trying to irritate you. The maximum size of a MySQL
database depends on your file system constraints, not on the size of
a LONGTEXT.
Some OSes have a max file size of 2GB, for example; others don't.
Linux ext2 filesystem only
Hi folks.
I have a local Access database here which I have created tab seperated
text files of each of the tables from to import into the Mysql db we are
running on our ISP's server.
However I have one field in one of the tables that is a text file and
contains sometimes very long descriptions
Hi,
I have looked through the documentation (http://www.mysql.com/docs)
and the mailing list archives
(http://www.geocrawler.com/lists/3/Databases/8/0/)
and find no mention of a feature that I was hoping was available:
* text or varchar columns that are automatically
SELECT * FROM listaemail WHERE id LIKE %% OR nome LIKE %% OR empresa
LIKE %% OR email LIKE %% OR ativo LIKE %% ORDER BY nome;
Time: 11 Lock_time: 0 Rows_sent: 30567 Rows_examined: 30568
before anyone jumps out and points it out, it is far
from being optimized. it should (and will, as soon
Database error: Invalid SQL: select id, subid from policy where
id='2' and subid='0'
MySQL Error: 1054 (Unknown column 'id' in 'field list')
Session halted.
the output look like this..
mysql desc policy;
+++--+-+-+---+
| Field | Type
Hello
I need to build a search utility which can query records based
on multiple text parameter,
my table will have about 10 fields and users can search on
3-5 parameters in one query. is there any way to achieve this
other than doing a full table scan.
thanks
raghu
I am currently trying to examine the benefits of continuing to
use MySQL over Oracle. I need to know what MySQL's features are
vs. those of Oracle.
http://www.mysql.com/information/crash-me.php
Also I am looking for performance data.
Oracle prohibits benchmarks, so good luck finding them.
1 - 100 of 105 matches
Mail list logo