-p without the passwd immediately following is not compatible with
input redirection.
Either add the password after the -p with NO space, or better yet,
create a .my.cnf file in the home directory of the user running the script
and have it contain the user and password settings.
Victor Spång
A group_id cannot be both 1 AND 3, but it can be 1 OR 3.
Try OR
Jouni Hartikainen wrote:
Hi.
how about:
select record.*
from link
where group_id='x'
left join record on record.archive_id=link.archive_id
?
The problem with this query is that with simple left join, I can
search only by
1. The command is not properly formed.
2. You don't have grant privileges.
3. Run this as the mysql root user.
Stephan Wölfel wrote:
When I try to execute grant all on *.* to stw where stw is my user name, I get an error
1045 (Access denied for user: '@127.0.0.1' (Using password: NO).
Is there a
.
- Original Message -
From: gerald_clark [EMAIL PROTECTED]
To: Stephan Wölfel [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, October 13, 2003 4:47 PM
Subject: Re: Error 1045
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
?
- Original Message -
From: gerald_clark [EMAIL PROTECTED]
To: Stephan Wölfel [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, October 13, 2003 5:54 PM
Subject: Re: Error 1045
Stephan Wölfel wrote:
Thanks for the advise.
However I have some additional questions:
ad 2) How can I
The first line starts mysql.
When mysql exits, the second line does nothing, as it is not a valid
shell command.
try :
echo 'INSERT INTO table_name (column_name) VALUES (value)' | mysql
--user=root --password= Database_Name
Or put the second line in a file, and cat the file through a
This is a bit vague.
How about showing what you have done, and how it is not what you wan't.
Colleen Dick wrote:
I am building a SELECT using a left join and I almost have what I want.
One of the fields that gets sucked in from the left join is either
null or has a value in it.
if it is null I
Rob Yale wrote:
Hi folks,
The following is copied exactly from my machine, except for the munged
password. Setting the root password can't be completed, because the host
apparently can't connect the mysql server. What am I doing wrong?:
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root
Leave off the 'WHERE e.Game_ID is NULL'
Wayne Helman wrote:
How would one join multiple table and selected all
records from a joined table whether they exist OR not?
I can get the records if they exist in a second table
and I can get the records if they don't exist, but is
there a way to combine
[EMAIL PROTECTED] wrote:
In MYSQL documentation the following line is
Some cases are not supported by LOAD DATA INFILE:
1. Fixed-size rows( FIELDS TERMINATED BY and FIELDS ENCLOSED BY both empty)
and BLOB or TEXT columns
I defined a column in a table as type TEXT. I then loaded values using
How did you determine this?
I hope not by the order returned when you select them.
There is no order to the set returned unless you use an ORDER BY clause.
Adrian Sill wrote:
Morning all,
I've been using the same format of text files to import monthly text
files using LOAD DATA LOCAL INFILE into
Error 13 means that the file exista, but mysql has no permissions for
the file.
Make sure mysql is the owner of the data directory and all its
subdirectories and files.
Joseph Donato wrote:
Folks,
When I try to start MySQL the mysqld just crashes. I looked at
/usr/lib/mysql/{hostname}.err
Run explain on the query and see if indexes are being used.
John Almberg wrote:
I am trying to find records (from the 'stamps' table) that are NOT
related to records in the 'links' table. To do this, I'm using a left
join. For example:
select s.*, l.item_id as lid from stamps as s left join
Joseph Donato wrote:
Folks,
I am trying to start mysqld and when I do the deamon crashes.
mysqld.log has the following:
030919 14:25:06 mysqld started
030919 14:25:08 Can't start server : Bind on unix socket: Permission
denied
030919 14:25:08 Do you already have another mysqld server
[EMAIL PROTECTED] wrote:
I have two tables and am running a simple join between them to get
questions and their repsective response averages from a survey. The
question table has 49 rows and the Response table has 126,732. I'd like to
cut down on the time its taking to run this specific
You need to add the new socket location to the paragraphs in my.cnf that
start with
[client]
and
[mysql]
/etc/my.cnf needs to be world readable.
Check for private .my.cnf files in the
home directories of the users having the problem.
michael watson (IAH-C) wrote:
Here is an interesting one!
I
Is the server running?
SWIT wrote:
badboy# ./mysql -u root -p
Enter password:
ERROR 2002: Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (
2)
that file is not there.
should I touch it ?
argggh !
and ya say windows sucks. (ok the beer is talking
Andreï V. FOMITCHEV wrote:
Hello everyone,
I use Valgrind to check my programs and this last found leaks in
libmysqlclient.so.
My code is simple:
char * requete = SELECT * FROM NOM_TABLE_1;
Looks like a misplaced '' .
MYSQL * mysql = mysql_init((MYSQL *)NULL);
MYSQL_RES * mysql_resultat;
Do you have
skip-networking
in your /etc/my.cnf file?
Scott Barron wrote:
Hello,
I am attempting to get MySQL to listen on a TCP socket on Solaris 8.
From what I've seen in the documentation, and my experience with MySQL
on Linux this should happen automatically. I've tried 4.0.14 from
source
Joshua Spoerri wrote:
On Tue, 5 Aug 2003, gerald_clark wrote:
You are ORing on two different fields. The index cannot be used to
check the value of z for an OR.
ORing on two different fields is what I have been asking about :).
Using a composite index was suggested, which strangely
Of course, you tried mysql --help ?
[EMAIL PROTECTED] wrote:
Hi all,
Just a quick question here.
May I know how to get a result without heading in Mysql (like set heading
off in Oracle) ?
Thanks and regards,
Helen
--
MySQL General Mailing List
For list archives:
You don't say what your problem is.
aaldrik groenewold wrote:
I just installed mysql 4.0 .There were many problems
with upgrading from 3.23 to 4.0 so I deleted 3.23 and
made a fresh start with 4.0. Everything works fine now
but the only problem to connect to the server is via
the
You are not doing select count(*)
You are doing select count ( *)
Get rid of the spaces before the (
Fatt Shin wrote:
Hi,
I'm running MySQL 4.0.13, connecting from PowerBuilder 9 using ODCB
Connector 3.51.
I'm facing a problem where whenever I issue a SELECT COUNT(*) statement
from PowerBuilder,
You have not shown us anything that would indicate that your output is
not correct.
If you think something is missing you have to show us what is missing,
and why you think
it should not be.
John Wards wrote:
I have this query:
SELECT *
FROM news_category
LEFT JOIN news_x_cat ON
You are ORing on two different fields. The index cannot be used to
check the value of z for an OR.
Why are you cross posting?
Joshua Spoerri wrote:
On Tue, 5 Aug 2003, Alexander Keremidarski wrote:
MySQL will never use any index for small tables. With just few rows using index
adds overhead
How about BIGINT(10) ZEROFILL ?
Eben Goodman wrote:
I am storing book isbn numbers in a table. isbn numbers are 10 digit
numbers and many start with 0. The data type of the field I am
storing this info in is a bigint(16) unsigned. It appears that isbns
that start with 0 are going in as 9
Your primary query has no where clause, so you are setting all Value to
a value from a random record for the most recent date.
Hardly looks like a 'bug' to me.
And why the cross post?
Daniel Kiss wrote:
Hi all,
I have two tables
CREATE TABLE main (
ID int not null,
Value int
);
CREATE
Since you don't show your grant statement, it is difficult tell you what
the problem is.
Since FILE is a global permission you need to grant it on *.* not
somedatabase.*
David Scott wrote:
Greetings all
I am not able to GRANT file permission to users. All permissions end
up being issued with
Vidhya CS wrote:
Hi ,
I am trying to export a database from one machine ie linux, and import
the same database to another machine ie ,solaris .
I exported the database using the following command .
mysqldump -c -u vidhya ifmonitor $HOME/ifmonito.backup.
this is ok , ifmonitor-backup has the
If all these fields are defined as not NULL, simply
use alter table with the ignore option to add a unique key on all
pertainant fields.
Kim Mackey wrote:
Group,
I have been working on a project for a while now trying to figure out
how to remove duplicate records from a single table using a
azamka wrote:
I am trying to right sql statement on the shell prompt but its not going
through.
Here is the statement:
[EMAIL PROTECTED] usr]# mysql security select * from machine;
-bash: select: No such file or directory
echo select * from machine | mysql security
or put your select
Mysqld is the server, and can be started automatically.
Mysql is a client program. It makes no sense to start it automatically.
-{ Rene Brehmer }- wrote:
Hi gang
Not sure if this is more for the RedHat list than here, but let's try...
I've put MySQL on a RedHat by using the RPM ... haven't yet
Use atoi();
Andy Jackman wrote:
Hi,
I'm new to mySql. I've got a table with an integer field defined like
this:
l_start_wait int(9) not null
I inserted a value into the table using mysql command line client with:
Insert into tbl_wait_list values(12345678);
When I use mysql_fetch_row() to
Shutdown mysqld before running myisamcheck,
or use check/repair table.
Jeff McKeon wrote:
Hello,
When I run a script to issue myismchk against the tables in my database,
I get the following..
[EMAIL PROTECTED] scripts]# ./check_mysql_tables
myisamchk: MyISAM file
Did you try the -q option?
Jake Johnson wrote:
Hello,
I have been backing up my db with the mysql dump command and it no longer
works. This is an example of the command I was running...
mysqldump -u dbuser -p -C mydb out.sql
but returns this
-- MySQL dump 8.21
--
-- Host: localhost
Jake Johnson wrote:
How do I fix this error? My tables have data.
But they probably are not owned by mysql.
Regards,
Jake Johnson
[EMAIL PROTECTED]
__
Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on
Perhaps you could post some examples of what you have tried.
I don't understand what you are asking.
Mojtaba Faridzad wrote:
Hi,
I guess there is no way to limit COUNT(*). Is that right? We cannot use the
result of COUNT in WHERE condition or LIMIT doesn't help. In this case so
far I have
Mojtaba Faridzad wrote:
First of all, I don't wanna let the query run to the end and after that,
count the number of records. as I mentioned, some tables are huge and takes
a long time to run COUNT(*) query for all records.
About LIMIT, it doesn't effect on COUNT query. but for the second query
Your maximum packet size must be greater than the size of the video file.
Steven Wu wrote:
Hi Need emergency help:
I am doing some project use the MySQL to store the video file.
The format of video is either avi or mpg. However I can not successfully insert the
video file into the
It writes a status message to the screen, and overwrites your shell prompt.
Hit enter, and you will probably find that you have a prompt afterall.
chad kellerman wrote:
Hey guys,
Anyone ever notice that when you restart mysql ( whether is be thru
mysql.server or ${MYSQL}/bin/sae_mysqld the
the problem...
Thanks,
George
I think there is a world market for maybe five computers.
Thomas Watson, Chairman of IBM, 1943.
- Original Message -
From: gerald_clark [EMAIL PROTECTED]
To: Lekeas GK [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, July 18, 2003 2:11 PM
Subject: Re: Working
Ashwin Kutty wrote:
I am trying to read a file and see if the contents of it exists in the DB
or not and am trying to do it via a Select.
I try to do a select * into outfile /tmp/result.txt from table where field
like %$var%; but it always goes through the first two lines of the input
file and
Lekeas GK wrote:
Hi All,
I am managing a small database and some of the tables
need to be strings of an average length of about 2,000
characters.
I decided to use the text datatype to store this
information knowing that the upper limit is about
65,000 characters.
However, the system crashes
Accidently?
You just asked if you could delete the .MYI table because of your disk
full error.
Oswaldo Castro wrote:
Hi Everybody
I have acidentally deleted an index file (.MYI) from a table. Is there another way, besides its backup, to recover this table ?
Thanks for any help
--
Compiling MySQL from the source tarball is not for linux newbies.
Get the RPMs.
root wrote:
hi there,
I've tried to install mysql-3.23.55.tar.gz but failed. Firstly, I've
created directory /home/users/mysql and add group for mysql. Those are the
command that I've used previously:
shellgroupadd
Nick Boudreau wrote:
Trying to start mysqld for the first time after a reinstall on Mac OS
X gives me this error:
030709 12:53:26 mysqld started
030709 12:53:27 InnoDB: Operating system error number 13 in a file
operation.
mysql doesn't have permissions for this file.
It is probably owned
fsttik has dashes in it and your having does not.
Either add dashes to your having or change the alias to min(datein+0)
as fsttik.
Patrick Shoaf wrote:
I am trying to get a SELECT working and not having any luck, can
someone please help?
SELECT
Does the mysql user have write permissions on the files?
HA. Mooduto wrote:
dear all,
what is the problem sql error : 1036 ...table is read only.
please help me..
thank's...
--
This mail sent through PSP: http://www.polinpdg.ac.id/
--
Since you are ordering by column3, ( in other words sorting your random
mumbers ),
what do you expect?
Scott A. Hammond, Sr. wrote:
I am running MySQL 3.23.54.
Query: SELECT column1, column2, RAND() AS column3 FROM table WHERE column2
IS NOT NULL ORDER BY column3 LIMIT 10;
I am running this
You must create the key (sku), it is not created for you.
Tom Gazzini wrote:
I would appreciate some help with a problem. I'm trying to create two
tables that have referential integrity.
If I try and create the following table it works fine:
CREATE TABLE book
(
sku INT
) TYPE=INNODB;
However,
Mark Depenbrock wrote:
I have installed a Mac OS X 'PKG' binary package on my OS version
10.2.6 Mac.
I have been instructed that after the installation I can start up
MySQL by running the following command lines:
[Computer:/usr/local/mysql] mark% sudo ./bin/mysqld_safe
Password:
Starting
You should have stopped mysql before running the update.
The update might have removed the socket file, leaving the server with
no way to communicate.
you may try connecting through the network interface.
mysqladmin -h 127.0.0.1 shutdown
If that does not work, kill the running mysqld processes
Andrew Staples wrote:
I've setup my my.cnf file on the slave as:
[mysql.server]
user=mysql
basedir=/var/lib
socket=/var/lib/mysql/mysql.sock
server-id=2
master-host=206.xxx.xxx.xxx
master-user=replicateuser
master-password=replicatepassword
Master.info is:
tux-bin.001
3109
206.xxx.xxx.xxx
Does the client close the connection before exiting?
Joshua Shapiro wrote:
Hello,
I am running the binary mysql 4.0.13 pclinux i686 with a linux
2.4.19 kernel. I have the problem that every time a client
connects to the server and then exits, a defunct thread is
left behind. Eventually
If you did not shutdown the server prior to the upgrade, you could have
left mysqld running, even after its socket was removed.
Use ps to see if mysqld is still running, and kill it if necessary.
Todd O'Bryan wrote:
Something bad has happened. MySQL was up and running on my machine,
but now
1 will work.
2 will not work.
3 Use dbf2mysql. ( It should be in the downloads section on mysql.com )
fab wrote:
Hi all,
I'm quite new in mysql. Despite i've read a part of the doc, i can't
fix my prob. Here is my question:
I want to convert a DBASE IV file into mysql table:
1) Have i to
Idries Hamadi wrote:
Hi all,
I've just started using mysql and I'm sure that my all problems are
something todo with my oracle-ness, so please bear with me if I use
case-insensitive table names or somthing ;)
Ok. I've been using the mysql interactive command-line interface for a few
days now,
Check the error log in your mysql data directory.
This should explain why mysqld ended.
suboh wrote:
Hi,
The following message appeared when I installed mysql server on Linux,,,
[2] 10804
[1] Exit 1 ./bin/mysqld -user-mysql
[EMAIL PROTECTED] mysql]$ Starting mysqld daemon with
For Mysql, 127.0.0.1 is not the same as localhost.
Localhost refers to the socket file on the operating system, and is
faster than 127.0.0.1.
Use 'root'@'127.0.0.1' in your grant statements.
Ola Ogunneye wrote:
Please somebody help me.
I have installed MySql 4.0.13 and it works up until I try
That can't be the output of the query.
The fourth column would me titled 'soma'
There is no seperator bar between the data for sw_or_local and soma on
the data lines.
Fabio Bernardo wrote:
hi there
I wrote this querie :
select pop, prot, sw_or_local, sum(qtd_porta) as soma from clientes where
Yes, if you have transaction logging turned on.
You can edit the transaction log, and run it against the restored database.
Subhakar Burri wrote:
Can I roll forward if I do backups using Mysqldump? Say, I did backups using Mysqldump @ 8:00 AM and my instance crashed @ 2:00 PM. I can restore the
Well, without seeing your table structures and key definitions, how
could we tell?
You are selecting on code=87901 , but there is no indication here
about what tbale that column belongs to.
Did you run analyze on your tables to update key distribution
information so the server could make a
'localhost 127.0.0.1' is not a valid host.
Use 'localhost' if you want to use the local socket.
Use '127.0.0.1' if you want to use the TCP port.
Gantier wrote:
Hello,
I work with apache, tomcat and linux redhat 7.3 and mysql 4.0.9
When I try to connect to my database from my application with the
Did you try increasing max_connections ?
Michael Edlund wrote:
I've developed a CMS using PHP and MySQL 4.1 alpha.
It ran just fine with the standard MySQL 4.1a binaries both on my
Powerbook running Mac OS X as well in a production environment on my
FreeBSD server. However, after having
Ok, update log.
Jeremy Zawodny wrote:
On Fri, Jun 27, 2003 at 08:08:40AM -0500, gerald_clark wrote:
Yes, if you have transaction logging turned on.
You can edit the transaction log, and run it against the restored database.
MyISAM doesn't have transactions.
Jeremy
--
MySQL General
[EMAIL PROTECTED] wrote:
Ok, I trying to get this example... what is table1 t1, table2 t2,
table3 t3, table4 t4, I mean, what does the t1, t2, t3, t4
represent? If you say, table 1, table 2, etc well, I assume that,
but isn't that there already?
Let me, or may I, give ask again with my
Check the client sources.
The mysql client is a great example for the c API.
Sean Macmillan wrote:
Please bear with me here as I am new to this whole MySQL thing. Does
anyone know where I can find a good example of how the C API function
call mysql_thread_init() is implemented? Any help would
mysqlhotcopy does your locking for you.
SAQIB wrote:
We are in the process of implementing enterprise wide (20,000+ users)
application that will use mySQL as the Database engine. I was wondering if
the slashdot readers can provide me some details about best practices /
experiences for Backing Up
perror 145
Vikas Gupta wrote:
Hello all,
My /var partition has become full, and now when I try load my db (the
files are in /var/lib/mysql/db/) I get the following message for the
table my_table:
use db;
Didn't find any fields in table 'my_table'
I then do describe my_table and I get:
Why would you expect they should have the same results?
The second query contains a join and may have many times more rows in
the result set.
PaT! wrote:
Dear All,
I have these two queries which are supposed to return the same results
for the fields with the same name (ex query 1 sum1 = query
It is a perl program, so you can look at it and see.
SAQIB wrote:
mysqlhotcopy does your locking for you.
So running
./mysqlhostcopy dbase /path/to/backup/dir
is perfectly safe while database operations (selct, insert, update etc)
are being performed?
---
Saqib Ali
http://www.xml-dev.com
In the second query, the server may switch the order of the join,
producing the same output in different order.
Try adding an ORDER BY to both and see what happens.
[EMAIL PROTECTED] wrote:
Ok, should be this:
SELECT * FROM machines INNER JOIN people ON
machines.peopleID=people.peopleID;
Ted
To also add priviliges on the local machine
GRANT ALL ON *.* TO username@localhost IDENTIFIED BY
password
Riaan Oberholzer wrote:
Hi,
I am created a user by using:
GRANT ALL ON *.* TO username@% IDENTIFIED BY
password
I did this from the mysql command line tool, logged in
as root. The
And what would that be?
Phil Dowson wrote:
Hi,
I am running two identical systems, the only difference between the two are
the database name and username. The problem I am getting only occurs on one
of the systems. I am running
--
MySQL General Mailing List
For list archives:
What does the error log say?
David Shealy wrote:
I'm a newbie to MySQL. I'm trying to run it on Red Hat 9. After running
mysql_install_db, I switch to the directory where mysql.sock is located
and enter safe_mysqld . Here's a copy of the shell output:
# safe_mysqld
[1] 7549
# Starting mysqld
Linux shows threads.
BSD shows processes.
The difference is in the way ps runs, not mysqld.
Henrik Leghissa wrote:
On my server running linux several daemons opens when I run msqld -u
mysql or safe_mysqld.
A listing of the process shows this:
mysql24475 0.5 2.1 83292 2012 ?S
Write a quick perl program.
O.S. Bos wrote:
Hi there,
I have a textfile that I want to get inserted into a database. The
textfile consists of Questions and Answers. 1st line is a question. 2nd
line of the textfile is the answer. And so on...
What is the best way to import these lines into the
a step or added one by accident or even got one wrong, go ahead
and fix it and pretend
I told you correctly. ;-)
The problem with my solution, is that if you have any wierd characters, they
arent escaped.
or you could just write a perl program
chris
-Original Message-
From: gerald_clark
Did you run myisamchk on user.MYI as I suggested last week?
(B
(BPushpinder Singh Garcha wrote:
(B
(B Thanks Nils,
(B
(B I had been having an terrible experience starting up MySQL. I used to
(B get this error Can't connect to local MySQL server through socket
(B '/tmp/mysql.sock' (2)
(B
And what happens if you leave off the 'distinct' ?
vernon wrote:
OK so now I have:
SELECT distinct useronline.uname, penpals_fav.fav_user_id, penpals_fav.ID,
penpals_privmsgs_block.user_id, penpals_privmsgs_block.blocked_id
FROM useronline, penpals_fav LEFT JOIN penpals_privmsgs_block ON
Pushpinder Singh Garcha wrote:
hello all,
i hve been getting the 'mysql ended' error for over a wek now.when i
look into the log file this is what I get
This is from the error logs
030619 17:09:04 mysqld ended
030620 13:14:06 mysqld started
030620 13:14:09 InnoDB: Started
030620 13:14:09
Christensen, Dave wrote:
Oops! Sorry. Deleted that 'temp' table and didn't remove it from my script
file.
-Original Message-
From: Christensen, Dave [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 19, 2003 11:34 AM
To: 'Jay Blanchard'; Dickey, Dallas; '[EMAIL PROTECTED]'
Subject: RE:
We don't know anything about you structures, your data, or your indicies.
You should show them along with the output of EXPLAIN on your query.
Derick Smith wrote:
Hi!
All the select statements have indexes on appropriate fields. Mysql
appears to run fast, I was just wondering if there was anyway
Look at the source for the mysql client.
It is a perfect example.
Sean Macmillan wrote:
Using the C API I have written a program that calls mysql_query() on a
table with values I know to be in the table. It returns fine and I
then call mysql_store_result. The problem I am having is figuring
Joanne Yow [bizfront] wrote:
Hi,
I am trying to install MySQL 3.23 to Solaris 2.8.
After the step - scripts/mysql_install_db
I try the command - chown -R root, error show usage: chown [-fhR] owner[:group]
file...
You entered the command incorrectly.
You gave it no files or directories to
Pushpinder Singh Garcha wrote:
Hello everyone,
I am running MySQl and PHP on a Mac OS Jaguar. When I try to restart
my MySQL Local Server using mysqld_safe, but I keep getting this error
[psg:/usr/local/mysql] psgarcha% sudo echo
Password:
[psg:/usr/local/mysql] psgarcha% sudo
Muazzam Siddiqui wrote:
Hi,
I am getting the error
You have an error in your SQL syntax near 'select max(news_id) from
news)' at line 1
while trying to run this query.
SELECT * FROM News where News_ID = (SELECT MAX(News_ID) FROM News);
You don't say what version of MySQL you are running.
Pick/Create a different directory. Make it owned by mysql:mysql, and set
it mode 775.
Mysqld can not write to /usr/local/bin.
Mark Colvin wrote:
I am having difficulty stopping and starting my mysql server. The mysqld is
currently running as all of the client machines can access the database.
Since you are providing the web page, it depends on how you write the
web page.
This really isn't a MySQL question, is it?
v7rg8 wrote:
Hi all,
My table is like this:
professor(name, gender, bodyImage)
I am not sure if this is correct to set up the table:
create table professor (name char(10),
John Farkas wrote:
I am new to mysql so please excuse my ignorance.
I am running mysql on windows 2000 and have noticed that when a table is
opened to do an insert or update it is not closed after the query is
finished but is left open.
Then when I shut down the mysql server and do a myisamchk
Shane Bryldt wrote:
Just a thought, what about encryption of passwords? Shouldn't it be:
GRANT ALL ON database TO [EMAIL PROTECTED] IDENTIFIED BY
PASSWORD('password');
No, it should not.
Not sure if that is related to the problem, but it may cause an invalid
password error.
However, your
William IT wrote:
I do mysqlamin shutdown and copy all /var/lib/mysql file from another MySQL
server. And then run:
chmod -R 660 *
Try 770
Mysql needs to be able to scan the directories to find tables.
chown -R mysql:mysql *
shutdown now -r
But I can't logon to Mysql. What's wrong?
--
Titu Kim wrote:
Hi,
I am trying to insert an image directly from
command line into mysql table. My table looks like
==
Create table ImageTab (id int, content longblob);
===
I login to localhost. I have an image at /tmp. Then i
issue this query
You will have to write a program to read your text files and
insert/update the appropriate records.
Fernando Gerent wrote:
Hi everybody,
I need to use the Load Data Infile to insert different columns from different files in
a table, but I can't figure out how to keep the number of rows, like
for this file. Still the data
is null in the table.
--- gerald_clark [EMAIL PROTECTED]
wrote:
Titu Kim wrote:
Hi,
I am trying to insert an image directly from
command line into mysql table. My table looks like
==
Create table ImageTab (id int, content longblob
My database editor uses:
describe name;
Karen Chu wrote:
I want to be able to get all table names in a database and all the
column names and associated data type from a particular table. I wonder
how to do that in MySQl. I understand I can use show tables to see the
table info, but I want to be
Steve Mansfield wrote:
Having run MySQL successfully for a while in a WAMP environment, I'm trying
to set up on Linux now (and am a real Linux newbie). I'm using the 4.3.1
version that came as an RPM with SuSE 8.2. The problem is - it doesn't work.
Here's where the various elements have
I use Decimal, because I like my money calculations to be correct.
Mojtaba Faridzad wrote:
Hi,
Which type do you usually use to keep money values? Decimal (12,2) or Float?
to keep the first one, system takes 12 bytes but for the second one, 8
bytes.
Thanks
--
MySQL General Mailing List
[EMAIL PROTECTED] wrote:
Hi,
I am running MySQL 4.0.10 gamma.
I have records with data:
id title version
1a 1
2a 2
3b 1
4b 2
How do I select all the records with highest version for each title?
(The records with id 2 and 4)
I've been thinking
Daniel Crompton wrote:
How do you create ascii line breaks in a text paragraph in mysql?.
When displaying text taken from a mysql row it displays it all as a flowing paragraph ie
sdf sdfgfj fgjhgfh fgj fgj hfj hj hg gh hgk ghk gj gh kg k hg hg jh j fgj fg
When i need to look like
sdf
301 - 400 of 608 matches
Mail list logo
