Well, like others, I reccomend MySQL by Paul Dubois. It is my only MySQL
book besides the copy of the MySQL reference manual provided by work. I have
an associate that has PHP and MySQL web development by Sams, and it gives my
any references I need for PHP. Looks like it is being updated on the
hi there i am having an issue formatting a date string back to mysql for a query, say
i have a month string January from a get query string like so ?month=January , and i
need to check a range of results within an endate so i need WHERE end_date
$_GET['month'] , how can i format the month
There are three my.cnf you should look for:
1) /etc/my.cnf = global options
2) datadir/my.cnf = server options, overriding global options
3) home_directory/.my.cnf = user specific options, overriding server
options
Thanks for your reply! The information does make sense.
However, I searched
Easy question for beginner. Why am I getting this error ? I just
installed
Mysql and I'm trying to create a database. Beginner stuff...
E:\mysqladmin create TestDB
mysqladmin: CREATE DATABASE failed; error: 'Can't create database
'testdb'. (err
no: 13)'
thanks in advance for anything...
Easy question for beginner. Why am I getting this error ? I just
installed Mysql and I'm trying to create a database. Beginner stuff...
E:\mysqladmin create TestDB
mysqladmin: CREATE DATABASE failed; error: 'Can't create database
'testdb'. (err
no: 13)'
thanks in advance for anything...
sorry if you may get this twice, my work is persistant to not give me
newsgroup access and their email server is shitty and slow , i think being on
novell heh anyway here is the message.
hi there i am having an issue formatting a date string back to mysql for a
query, say i have a month string
NOBODY has an idea???
it's a redhat linux box with downgraded gcc 2.95.4 - glibc 2.2.4
hi list,
getting this with mysql-3.23.55 on 2 machines (on other it compiled):
make all-am
make[3]: Entering directory `/usr/src/mysql-3.23.55/include'
make[3]: Nothing to be done for `all-am'.
this may seem as a desperate questions, but is there anway to restore
deleted data from a table? Is there any logs of the database commmands
that for example sql-servere has, that can be used to rollback to the a
specific time and in that way restore the old content of a database.
I was pretty
Hi Mr. Bueno,
thnak you for you're response.
I knows the way you described how determine if replication is finished.
But doing this I need to make a connection to the slave and a connection to
the master and compare the results of this two queries.
I'm looking for a way of deciding this with
OK, I'm coming back to this problem after not touching it for a while.
Sorry about the indentation, it's a dynamically generated query and I just
cut and pasted into the email.
I tried your suggestion, and it is showing the correct number of displays
for most ads, but it is not limiting the
First of all, I'd try optimizing your app before writing a whole new
back-end. As such, I'd keep to the normal mysql list.
For example, even if the indexes are big, try to index all the columns that
might be searched. Heck, start by indexing all of them. If the data is
read-only, try myisampack.
Hi list,
I have a create table command in which the check statement does
not seem to do anything. I know it was just there for compatibility
in older mySQL versions, but I thought it should be working in
version 4.0.2. Isn't it?
Rinke
Do you have an application with a sort of upgrade functionallity that
when started checks the database for incosistency and when it finds some
updates the database? (ie compares the structure of the table in the
database to some template stored in the application or as
datafiles/scripts)
Or do
Hello,
I am using mysql3.23.49 on openbsd3.2. I have a myisam table with 4G
file size and now I can no longer insert records into table. My mysql
data partition is not full (%24 used). I have read that mysql 3.23
supports up to 2 terabytes table size. Not so sure but I know openbsd's
file
Hi,
On Sun, 2003-02-02 at 00:25, B. van Ouwerkerk wrote:
If it gives errors about creating/writing mysql.sock, check the
permissions/ownership of directory /var/lib/mysql.. Check the manual for
the right permissions...
Might depend on your distro, AFAIK mysql.sock would normally live in
Description:
If I run a query like UPDATE questions, q_list SET questions.point =
60, q_list.point = questions.point WHERE q_list.qid = questions.qid AND
questions.qid = 311677 InnoDB will crash, and cause damage to some of my
MyISAM tables.
How-To-Repeat:
Run the above query.
Fix:
Put the error number in to perror in ../mysql/bin
It will then tell you what the error is about.
---snip---
/usr/local/mysql/bin$ ./perror 13
Error code 13: Permission denied
---snip---
This is an operating system error.
Simon
-Original Message-
From: wiley [mailto:[EMAIL PROTECTED]]
Hi all
Is there any concept of Tablespace for MyISAM tables in MySQL?
Even if it is not present, is there any concept in MySQL which is
equivalent to Tablespace in Oracle?
Where could i get the information about it?
Thanks in advance
Prasanth
I am using MySQL 3.23.47-nt on Windows 2000 Pro SP3;
I have the following DB's:
# Host : localhost
# Database : test
CREATE DATABASE test;
USE test;
# Structure for table users :
CREATE TABLE `users` (
`id` smallint(4) NOT NULL auto_increment,
`user` varchar(8) NOT NULL default '',
technical question-
The MySQL-4.0-mysql-4.0.6-gamma-win works on winNT
will it work on win98?
Plz reply me immediately..
__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
Hi and thanks for the reply.
After I read all about replication, I have a little question.
In section 4.10.3 How To Set Up Replication, in step 3 it is written and
then take a snapshot of the data on your master server.
I am working on windows 2000 and I don't understand, how do I do the
perror 13
returns
Error code 13: Permission denied
You do not have permission to create databases as the default user.
As installed. there is already a test database called 'test' and a test
user called 'test' with no password to do the kind of inital trying out you
probably want.
May I
Does anybody know what this means?
Script started on Mon Feb 3 07:17:16 2003
dashielljt@athame:~$ mysql
ERROR 2002: Can't connect to local MySQL server through socket
'/var/run/mysql/mysql.sock' (111)
dashielljt@athame:~$ exit
exit
Script done on Mon Feb 3 07:17:31 2003
--
Jude
Hi
Error 13 is Permission denied. Check you have write permissions on the mysql database
directory (you might not if you copied from a CD for instance).
Hope this helps
iolaire
On Sun, Feb 02, 2003 at 08:44:23PM -0800, wiley wrote:
Easy question for beginner. Why am I getting this error ? I
Alex,
If I put a copy of my.cnf to datadir would that be any help? Any
what
is home_directory? Sorry I am kind of newbie for in-depth knowledge
of MySQL.
Nope. You don't have three copies of my.cnf (one of them actually
called .my.cnf, note the dot) to make things more complicated, but to
Inbal,
a snapshot is simply a backup of the database at a well defined point
in time. A snapshot is essential for replication to work. Master and
slave are supposed to start with exactly the same set of data
(snapshot) in the beginning.
There are several ways to create a snapshot on the master
Daniel,
(you posted this question twice, but I will only answer it once ;-)
have a month string January from a get query string like so
?month=January ,
and i need to check a range of results within an endate so i need
WHERE end_date
$_GET['month'] ,
You could use the DATE_FORMAT() function
Hello!
When I run mysql with default-charset = estonia, it makes difference
between upper and lower case. With latin1 charset no such distinction are
made. Could someone clarify for me, is it bug?
--
Lauri Anton
( [EMAIL PROTECTED] )
( +3727302126 )
- estonia -
Server version:
If it's lost, it's lost. But that's not the end of the matter. When
making a table for use, make a backup tablee and have update operati
operations like closing make a backup of data in original table.
Interestingly, msaccess 2000 has a problem with subquerydatasheets that
makes such an approach
Peter,
sorry to say, but I guess your data have gone to Nirvana.
Is there any logs of the database commmands
There is. It's called binlog (binäre update log), and you can turn it on
by starting the server like mysqld --log-bin (or put log-bin in the
[myslqd] section of your my.cnf / my.ini).
From manual:
LONGBLOB
A BLOB or TEXT column with a maximum length of
4294967295 (2^32 - 1) characters
If I insert a 400k file into a longblob, will it
occupy 400k in actual space on the harddrive, or will
it occupy the maximum for a longblob?
Is there any difference here between innoDB an
We had an issue the other day where we could not access the myslq database
we have on our redhat linux 7.2 box.
when I did a
ps -ef |grep mysql
I got the following.
root 645 1 0 2002 ?00:00:00 [safe_mysqld]
root 688 645 0 2002 ?00:01:31
This is not so...Mysql will write out the data for MyIsam tables without
calling the operating system to do an fsync()...it's up to the OS to flush
dirty pages to disk.
See http://www.mysql.com/doc/en/Command-line_options.html under the --flush
command line parameter.
Peter
^_^
-Original
Hi,
I am new to this list so I apologise if this is not the place to post this
message.
I am in the final stages of completing a project and I have one query that
is causing problems.
I need the query to get a story or stories from the story table and
journalists from the journalist table
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Sun, 2 Feb 2003, Andy Smith wrote:
Where have the links to MySQL SRPM packages gone from
http://www.mysql.com/downloads/mysql-4.0.html ??
I found being able to build binary RPMs from your SRPMS to be
useful, please could you make these
Hi everyone.
Does anybody know if it is possible to commit only partially ?
example:
query: select ... from A ... for update;
// update fields locked in A
query: select ... from B ... for update;
then I would like to commit all changes I did in the locked records from
table A,
In the last episode (Feb 03), Grigor, Peter said:
This is not so...Mysql will write out the data for MyIsam tables
without calling the operating system to do an fsync()...it's up to
the OS to flush dirty pages to disk.
He specifically asked for MySQL-only write activity:
I am just trying to
Hi,
Even if you have large file support you must tell mysql to use long
pointers when creating the table. The way to accomplih this is to add
the MAX_ROWS table option when creating the table, just make it a
really large number like 50. You can verify this effect by
BEFORE makeing the
On Monday 03 February 2003 06:44, wiley wrote:
Easy question for beginner. Why am I getting this error ? I just
installed Mysql and I'm trying to create a database. Beginner stuff...
E:\mysqladmin create TestDB
mysqladmin: CREATE DATABASE failed; error: 'Can't create database
'testdb'. (err
On Monday 03 February 2003 01:18, Michelle de Beer wrote:
This question might be a little OT.
My question is, what is the smallest working install
of mySQL?
Can you install it in a PDA, like the Yopy, that uses
linux as OS?
MySQL is portable. The questions is: if it is possible to
On Monday 03 February 2003 01:08, Jianping Zhu wrote:
I have rehat 7.3 linux server with apache server running, when i try to
install mod_auth_mysql, i
got followine error msg,
[root@mango mysqlsrc]# rpm -i
Hi.
First of all, do all of us, including yourself, a favor and upgrade to
4.0.9 (or 4.0.10 which should come out this week). Reporting problems
against a 7 months old alpha version is not very, well, productive, if
the current release is gamma quality.
On Mon 2003-02-03 at 10:04:58 +0100,
Yes, setting up MAX_ROWS parameter is the right solution i think. I have
tried it with alter table command and it seems to work.
Thanks all.
[EMAIL PROTECTED] wrote:
Hi,
Even if you have large file support you must tell mysql to use long
pointers when creating the table. The way to accomplih
In the last episode (Feb 03), Prasanth Krishna said:
Is there any concept of Tablespace for MyISAM tables in MySQL? Even
if it is not present, is there any concept in MySQL which is
equivalent to Tablespace in Oracle?
MyISAM tables are stored as separate files in the filesystem, so you
could
Hi,
I am sorry this is a bit off topic.
I am looking for recommendations of MySQL / PHP / HTML / Javascript development
companies.
Companies which you have previously worked and found to be very good at what
they do and good value.
They need to be English speaking. I am especially looking
i have a problem with my project :-)
i created two functions, base64_encode, and base64_decode, to insert a
binary file in a LONGBLOB field. When i use theses functions without a
buffer i don't get errors.
by example : OUTPUT = base64_decode(base64_encode(INPUT)); -- i don't
have errors, i can
Hi,
I am sorry this is a bit off topic.
I am looking for recommendations of MySQL / PHP / HTML / Javascript development
companies.
Companies which you have previously worked and found to be very good at what
they do and good value.
They need to be English speaking. I am especially looking
Peter,
MySQL stores all updates that modify, insert or delete the database in a
transaction log file, as long as the option is turned on, it is by
default in some cases. The newer versions of MySQL use a binary log,
often stored in the the data directory and named like hostname.001,
.002,
Hi all
please help
19:36:59[p0]talmuth@smtp:~cat /etc/my.cnf
[client]
host=localhost
user=root
[mysqld]
max_connections = 5000
19:37:58[p0]talmuth@smtp:~cat /usr/local/etc/rc.d/mysql.sh
#!/bin/sh
cd /usr/local/mysql
./bin/mysqld_safe --user=mysql --default-character-set=cp1251 --max_connect
Grover,
I am carbon copying this to [EMAIL PROTECTED]
- Original Message -
From: Grover Cussi [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, February 01, 2003 2:16 AM
Subject: Problems with innodb
Hello!
I have various databases, one has a table with more than 3 millions
Hi all
please help
19:36:59[p0]talmuth@smtp:~cat /etc/my.cnf
[client]
host=localhost
user=root
[mysqld]
max_connections = 5000
19:37:58[p0]talmuth@smtp:~cat /usr/local/etc/rc.d/mysql.sh
#!/bin/sh
cd /usr/local/mysql
./bin/mysqld_safe --user=mysql --default-character-set=cp1251 --max_connect
it should
*
* Cal Evans
* Stay plugged into your audience.
* http://www.christianperformer.com
*
-Original Message-
From: Smita Marda [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 03, 2003 5:25 AM
To: [EMAIL PROTECTED]
Subject: question
technical question-
The
Hi,
Already work (very well) on Win98.
You can download it from http://www.mysql.com/downloads/mysql-4.0.html
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL
How-To-Repeat:
create table teste ( id integer auto_increment unique,imagem LONGBLOB not null);
insert into teste (id) values (1);
update teste set image = (IMG OF 300K) where id = 1;
select if(imagem is null, ERRO, OK) from escriba2.teste where id = 1;
* My System is Linux 2.4.18
* Table table
Quoting [EMAIL PROTECTED]:
By the way, I did use pthread:
./configure --prefix=/usr/local/mysql --with-pthread
I'm running Tru64 5.1a and I downloaded mysql-3.23.51.tar. I was able to
compile it successfully but when id did a GNU Make, I recieved the
following:
cc: Warning:
55 matches
Mail list logo