We're having a problem with MySQLHotCopy. It has worked flawlessly in the
past but now we're getting an error message similar to this:
Dumping database... DBD::mysql::db do failed: Can't find file:
'./file.frm' (errno: 24) at /usr/local/mysql/bin/mysqlhotcopy line 468.
Deleting previo
this may help you
test> create table d (
-> date date );
Query OK, 0 rows affected (0.45 sec)
test> insert into d values(now());
Query OK, 1 row affected (0.12 sec)
test> select * from d;
++
| date |
++
| 2005-09-10 |
++
1 row in set (0.00 sec)
O
i want to put a value in a column that is the date of today .
IS there a solution to do that in sql way ?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
bruce wrote:
1) i'm trying to figure out how to allow a user to search through a
query/tbl for a given string. ie, if i have the following as the result of a
query:
Why wouldn't you simply create the query that would produce only
the rows you want (where name = '%aa%' OR email = '%aa%' OR...)?
hi...
i'm trying to figure out how to approach/solve a few issues. looking through
google hasn't made the light shine!!
1) i'm trying to figure out how to allow a user to search through a
query/tbl for a given string. ie, if i have the following as the result of a
query:
name email
- Original Message -
From: "Gleb Paharenko" <[EMAIL PROTECTED]>
Hello.
huge.cnf example. What about that thread_concurrency setting in
huge.cnf.. it doesn't seem to show up in a 'show variables' when using
it.. is it deprecated?
In the manual it is meant that thead_concurrency is use
Hello.
> huge.cnf example. What about that thread_concurrency setting in
> huge.cnf.. it doesn't seem to show up in a 'show variables' when using
> it.. is it deprecated?
In the manual it is meant that thead_concurrency is used on Solaris.
In the source files I've seen that thread_concurr
Hello.
The complete answer could only be obtained from [EMAIL PROTECTED]
Shaghayegh Sahebie <[EMAIL PROTECTED]> wrote:
> [-- text/plain, encoding 8bit, charset: iso-8859-1, 15 lines --]
>
> hi,
> I'm working in a company which wants to have a client/server application on
> MySQL DBMS
Hello.
This is a frequently asked question. Search in Google and in the
archives at:
http://lists.mysql.com/mysql
Pay attention to the mysql_real_escape and LOAD_FILE. See:
http://dev.mysql.com/doc/mysql/en/mysql-real-escape-string.html
http://dev.mysql.com/doc/mysql/en/string
Hello.
Maybe STRICT_ALL_TABLES sql mode is that you want? See:
http://dev.mysql.com/doc/mysql/en/server-sql-mode.html
Use 'SHOW WARNINGS' to find out the problems. See:
http://dev.mysql.com/doc/mysql/en/show-warnings.html
Example:
mysql> set @@sql_mode='STRICT_ALL_TABLES';
Query
Hello.
> /opt/local/var/Mattys-iMac-G5.err: Operation not permitted
Check the permissions on /opt/local/var directory. Have a look here
as well:
http://dev.mysql.com/doc/mysql/en/starting-server.html
Matt Scales <[EMAIL PROTECTED]> wrote:
> I've just installed MySQL 4 4.1.12_1 +serve
Hello.
Looks like it is a bug. See:
http://bugs.mysql.com/bug.php?id=7883
Duncan Hill <[EMAIL PROTECTED]> wrote:
> I recently changed /etc/my.cnf to set myisam_data_pointer_size to 6, as we're
> starting to encounter quite a few tables that are larger than 4 GB. However,
> the crea
Hello.
Check your error log. Have a look here:
http://bugs.mysql.com/bug.php?id=12216
"Jeff" <[EMAIL PROTECTED]> wrote:
> Hey all,
>
> Just brought up a new RH EL3 server and updated MySQL to ver
> 4.1.13-standard
>
> I'm trying to get replication from an older server running ver
I recently changed /etc/my.cnf to set myisam_data_pointer_size to 6, as we're
starting to encounter quite a few tables that are larger than 4 GB. However,
the create table statements used by the software application using the DB
don't seem to be creating tables with pointers > 4 bytes.
Recent
hi,
I'm working in a company which wants to have a client/server application on
MySQL DBMS.
our company uses MyODBC and MySQL Connector/.Net. We want to sell our
application which license should we buy?
Should we buy MySQL Network license? or there are seperate licenses for
connectors?
and
15 matches
Mail list logo
