Dear MySQL general list members,
I have a guest book on a small club web page that has been getting
regular spam in with
the legitimate replies.
I use MySQL and (I think) Apache-style PHP to run the database. I know
it is PHP and
am certain when I started these survey and guest book it was
Hi;
I rebuilt mysql and injected the database which had user mysqluser and a root
user. Both got wiped out. It looks like the data is intact other than that.
Look at this:
mysql CREATE USER dev IDENTIFIED BY 'pass';
Query OK, 0 rows affected (0.04 sec)
mysql CREATE USER mysqluser IDENTIFIED BY
Problem solved:
/usr/local/bin/mysql_fix_privilege_tables2
Drew Jenkins [EMAIL PROTECTED] wrote: Hi;
I rebuilt mysql and injected the database which had user mysqluser and a root
user. Both got wiped out. It looks like the data is intact other than that.
Look at this:
mysql CREATE USER dev
On 3/9/07, Gloria McMillan [EMAIL PROTECTED] wrote:
Dear MySQL general list members,
I have a guest book on a small club web page that has been getting
regular spam in with
the legitimate replies.
I use MySQL and (I think) Apache-style PHP to run the database. I know
it is PHP and
am certain
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
I'm having trouble with the following:
In the MySQL 4 database I had the following values in an unique varchar
and there was no problem:
Gross
Groß
(the latter has the german sharp s character)
Now whenever I import this into the MySQL5
First at all, i`m spanish so please, apologize for my english
Hello to everybody, i`m a newby with mysql and i have a problem with a select
I`m making a database for a hostel
I have 2 tables for reservations, one is called rooms and have 2 fields
(id_room, tipo)and the other one is ocupation
- Original Message -
From: Yo Mismo [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Monday, February 26, 2007 8:41 AM
Subject: problems with a select
First at all, i`m spanish so please, apologize for my english
Hello to everybody, i`m a newby with mysql and i have a problem
Well I´m having some problems with a trigger and i don´t know how to handle
this situation.
Let´s start... well I have 2 tables (Table1 and Table2). Only fictional
tables.
CREATE TABLE `table1` (
`id` int(10) unsigned NOT NULL auto_increment,
`status` tinyint(1) unsigned NOT NULL,
PRIMARY
,CONVERT(id USING latin1))) from test;
Thanks
ViSolve DB Team
- Original Message -
From: Dušan Pavlica [EMAIL PROTECTED]
To: list mysql mysql@lists.mysql.com
Sent: Wednesday, January 31, 2007 5:31 PM
Subject: CONCAT(int_col, string_col) and charset and collation problems
Hi,
I'm using MySQL
and collation problems
Hi,
I'm using MySQL 4.1.15, WinXP and my problem is that
SELECT CHARSET(CONCAT(int_column, string_column)) FROM mytable;
always returns charset 'binary' and I need resulting charset to be
same as a charset of a string_column because I don't want to look
for charset of a column
Hi,
I know about CONVERT but I wanted to check character set of 'tt' column
and this result use in CONVERT. Something like CONVERT(id USING
CHARSET(Name))
which doesn't work.
It wont. the syntax is -- CONVERT(expr USING transcoding_name); its the
name of the transcode and not an expr.
I
Hi,
I'm using MySQL 4.1.15, WinXP and my problem is that
SELECT CHARSET(CONCAT(int_column, string_column)) FROM mytable;
always returns charset 'binary' and I need resulting charset to be same
as a charset of a string_column because I don't want to look for
charset of a column whenever I have
I have a table with numerous columns but needing to perform a query
based on three columns:
Lab_number, result, release_time.
What I want to do is search for lab_number where there is a result but
not released. The problem that is making this difficult for me, is that
there are multiple entries
Daniel,
find the lab_number where ALL the tests have been performed and
not the lab_numbers which have partial results.
SELECT t1.lab,t1.res,t1.dt
FROM tbl t1
WHERE NOT EXISTS(
SELECT lab FROM tbl t2 WHERE t1.lab=t2.lab AND t2.res IS NULL
);
The decorrelated version uses an exclusion join,
On Wed, 2007-01-17 at 09:56 -0600, Peter Brawley wrote:
Daniel,
find the lab_number where ALL the tests have been performed and
not the lab_numbers which have partial results.
SELECT t1.lab,t1.res,t1.dt
FROM tbl t1
WHERE NOT EXISTS(
SELECT lab FROM tbl t2 WHERE t1.lab=t2.lab AND
Daniel,
CREATE TABLE tbl (
lab_number int(11) default NULL,
result int(11) default NULL,
release_time datetime default NULL
);
select * from tbl;
+++-+
| lab_number | result | release_time|
+++-+
|
|
+++-+
PB
This works!! It seems it was my defaults for my original table that was
causing me my problems. Sorry for troubling you, thanks once again for
the prompt solution.
Danny
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
Haig Dedeyan (Home) wrote:
Hi everyone,
I'm a dbase rookie and I've ran into a small problem.
I created a basic faq table and all is fine regarding displaying
searching the Q A's on a web page.
Up until now, I;ve entered all Q A's from phpMyAdmin.
I'm trying to create an admin page to
Hi everyone,
I'm a dbase rookie and I've ran into a small problem.
I created a basic faq table and all is fine regarding displaying
searching the Q A's on a web page.
Up until now, I;ve entered all Q A's from phpMyAdmin.
I'm trying to create an admin page to enter the Q A's and for the
[snip]
You have an error in your SQL syntax; check the manual that corresponds
to your MySQL server version for the right syntax to use near 's
resources than dual monitor mode to generate the video output. Running
in dual' at line 2
when I try to add:
Note : Single-monitor mode uses more of
I keep getting the following error:
You have an error in your SQL syntax; check the manual that corresponds
to your MySQL server version for the right syntax to use near 's
resources than dual monitor mode to generate the video output. Running
in dual' at line 2
when I try to add:
[EMAIL PROTECTED] wrote:
I keep getting the following error:
You have an error in your SQL syntax; check the manual that corresponds
to your MySQL server version for the right syntax to use near 's
resources than dual monitor mode to generate the video output. Running
in dual' at line 2
Hello,
my question refers to the user root in MySQL 5.0.22.
Is the standard MySQL root user really required with the name root or can I
rename the root user for example to myroot?
Our software vendor affirms that MySQL need the User root always but I argue
the convers.
The application of
.
- Original Message -
From: [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Thursday, December 07, 2006 1:41 PM
Subject: Renaming the root user - problems.
Hello,
my question refers to the user root in MySQL 5.0.22.
Is the standard MySQL root user really required with the name root
[EMAIL PROTECTED] schrieb:
Hello,
my question refers to the user root in MySQL 5.0.22.
Is the standard MySQL root user really required with the name root or can I rename the
root user for example to myroot?
Our software vendor affirms that MySQL need the User root always but I argue
the
On 12/7/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Hello,
my question refers to the user root in MySQL 5.0.22.
Is the standard MySQL root user really required with the name root or can I rename the
root user for example to myroot?
No, it isn't required, you can rename it or simply
- Original Message -
From: Daniel da Veiga [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Thursday, December 07, 2006 9:48 AM
Subject: Re: Renaming the root user - problems.
On 12/7/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Hello,
my question refers to the user root
My innodb_buffer_pool_size is:
innodb_buffer_pool_size | 8388608
That looks like 8MB... that sounds small if I have a DB with over 1M
rows to process. No?
Yes, that's extremely small. I'd go for at least 256M, and maybe 512M
if your machine will primarily be doing mysql duties.
On Saturday 25 November 2006 17:54, John Kopanas wrote:
The following query takes over 6 seconds:
SELECT * FROM purchased_services WHERE (purchased_services.company_id =
535263)
What does EXPLAIN say about that query?
Have you done an optimize recently?
--
Scanned by iCritical.
--
MySQL
All,
I have an application in which I am trying to insert some traditional Chinese
characters. The insert statement probably won't cut and paste correctly but it
is: insert into TKTS13 values (2,'ÄãºÃ', 'ÄãºÃ');
I have used this website
http://people.w3.org/rishida/scripts/uniview/conversion
Hi Barbara,
The hex value '3F' represents the question mark,
which means your server CAN'T convert the characters
correctly from your client.
Regards,
Barbara Deaton [EMAIL PROTECTED] wrote on 2006-11-28 11:16:09:
All,
I have an application in which I am trying to insert some
Thanks a lot for your help.
The query should and only does return 1-6 rows depending on the id.
Never more then that. Here are the comperative EXPLAINs:
mysql EXPLAIN SELECT * FROM purchased_services WHERE id = 1000;
The application is not in production yet but when it will go in
production the server will be considerably faster and have much more
RAM. But before I put the app in production I want to make sure it is
working properly. 500K rows does not sounds like that much in this
day in age. If I
match
~600k rows and will do a full table scan. Mysql only keeps a single
cardinality value for each index that estimates how many records have
a unique value in the index. This can cause problems for the optimizer
if you have one value for say 60% of the table, and unique values for
the rest. You
match
~600k rows and will do a full table scan. Mysql only keeps a single
cardinality value for each index that estimates how many records have
a unique value in the index. This can cause problems for the optimizer
if you have one value for say 60% of the table, and unique values for
the rest. You
cause problems for the optimizer
if you have one value for say 60% of the table, and unique values for
the rest. You can try adding a FORCE INDEX clause to the query and see
if that helps.
When I did a:
SELECT * FROM purchased_services WHERE company_id = 1000;
It took me 7 seconds
value for each index that estimates how many records have
a unique value in the index. This can cause problems for the optimizer
if you have one value for say 60% of the table, and unique values for
the rest. You can try adding a FORCE INDEX clause to the query and see
if that helps.
When I
At 08:31 PM 11/26/2006, John Kopanas wrote:
When I did a:
SELECT * FROM purchased_services WHERE company_id = 1000;
It took me 7 seconds. This is driving me crazy!
I am going to have to try this on another computer and see if I am
going to get the same results on another system. Argh...
Sorry about these questions. I am used to working with DBs with less
then 10K rows and now I am working with tables with over 500K rows
which seems to be changing a lot for me. I was hoping I can get some
people's advice.
I have a 'companies' table with over 500K rows and a
I tried the same tests with the database replicated in a MyISAM
engine. The count was instantaneous but the following still took
3-6seconds:
SELECT * FROM purchased_services WHERE (purchased_services.company_id = 535263)
The following though was instantaneous:
SELECT * FROM purchased_services
If I just SELECT id:
SELECT id FROM purchased_services WHERE (company_id = 1000)
It takes approx 2-2.5s. When I look at the process list it looks like
that it's state seems to always be in sending data...
This is after killing the db and repopulating it again. So what is going on?
On
In the last episode (Nov 25), John Kopanas said:
Sorry about these questions. I am used to working with DBs with less
then 10K rows and now I am working with tables with over 500K rows
which seems to be changing a lot for me. I was hoping I can get some
people's advice.
I have a
This kind of timeframe (2 - 2.5 secs) could just be the result of
running on a laptop. You've got a small amount of RAM compared to
many servers, a bit slower processor, and *much* slower hard disk
system than most servers. If your query has to access multiple
records spread out throughout the
Hello!
I cannot unsubscribe from the list. After filling in the form
(http://lists.mysql.com/[EMAIL PROTECTED]), no e-mail comes
to me for me to approve the unsubscription.
P. S. If somebody of the list administrators reads this message, please
unsubscribe my address ([EMAIL PROTECTED]) from
I have a registration script that inserts data into the database, and
then emails you an activation code to activate your account. The
problem is that when I click on the link in the email, the account does
not get updated. The portion of the script that has a problem is this:
$query = UPDATE
Which error do you get in activation page?
Nicholas Vettese [EMAIL PROTECTED] escreveu na mensagem
news:[EMAIL PROTECTED]
I have a registration script that inserts data into the database, and
then emails you an activation code to activate your account. The
problem is that when I click on the
I can see something that can be the problem, in mysql 3 you don´t have
trigger, then you cannot use trigger_error function, try to use mysql_error
instead.
Nicholas Vettese [EMAIL PROTECTED] escreveu na mensagem
news:[EMAIL PROTECTED]
I have a registration script that inserts data into the
At 08:22 AM 9/6/2006, Nicholas Vettese wrote:
I have a registration script that inserts data into the database, and
then emails you an activation code to activate your account. The
problem is that when I click on the link in the email, the account does
not get updated. The portion of the
, 2006 9:15 AM
To: mysql@lists.mysql.com
Subject: Re: Problems Updating Database
At 08:22 AM 9/6/2006, Nicholas Vettese wrote:
I have a registration script that inserts data into the database, and
then emails you an activation code to activate your account. The
problem is that when I click
error: Found option without preceding group in config file:
/u07/mysql/data/upgrade_defaults at line: 2
Fatal error in defaults handling. Program aborted
This is your problem.
What's in that file (/u07/mysql/data/upgrade_defaults) ?
--
MySQL General Mailing List
For list archives:
Hi,
could it be this bug :
http://bugs.mysql.com/bug.php?id=21011
2006/8/31, Whisler, David [EMAIL PROTECTED]:
I've upgraded from 5.0.22 to 5.0.24 MySQL Server on Solaris 9 using the
Solaris package utility (which means I de-installed 5.0.22 then
installed 5.0.24 in the same location,
?
-Original Message-
From: Chris [mailto:[EMAIL PROTECTED]
Sent: Friday, September 01, 2006 2:02 AM
To: Whisler, David
Cc: mysql@lists.mysql.com
Subject: Re: mysql_upgrade script problems on MySQL 5.0.24
error: Found option without preceding group in config file:
/u07/mysql/data
I've upgraded from 5.0.22 to 5.0.24 MySQL Server on Solaris 9 using the
Solaris package utility (which means I de-installed 5.0.22 then
installed 5.0.24 in the same location, environment, configuration).
I'm having the following error when trying to execute the mysql_upgrade
executable according
Jieqi Wang wrote:
I am using WinXP, GNU Emacs 23, MySQL 5.
When I start a mysql process with `sql-mysql' in emacs, no output is
displayed in the buffer until I quit or kill the process.
After I add the following line into the initialization file of emacs,
(setq sql-mysql-options '(-C -t
On 8/6/06, Ro BGCT [EMAIL PROTECTED] wrote:
Hello,
I installed MySQL on a remote server and am having a problem. I am
connected to it via SSH and I can do mysql -u root -h localhost just
fine and connect. However, when I try to connect via mysql -u root
-h web1.server.com, I get the following
On 8/6/06, Ro BGCT [EMAIL PROTECTED] wrote:
Hello,
I installed MySQL on a remote server and am having a problem. I am
connected to it via SSH and I can do mysql -u root -h localhost just
fine and connect. However, when I try to connect via mysql -u root
-h web1.server.com, I get the following
Hello,
I installed MySQL on a remote server and am having a problem. I am
connected to it via SSH and I can do mysql -u root -h localhost just
fine and connect. However, when I try to connect via mysql -u root
-h web1.server.com, I get the following message:
ERROR 1130 (0): Host
I got the following query:
select s.id,s.name,sum(p.fee) as fee from serie as s inner join race_serie as
rs on (rs.serie_id=s.id) inner join races as r on (r.id=rs.race_id) inner
join participants as p on (p.race_id=r.id) where s.receipt=1 and
p.rider_id=236 and fee 0 group by s.id order by
At 11:10 +0200 30/7/06, Jørn Dahl-Stamnes wrote:
select s.id,s.name,sum(p.fee) as fee from serie as s inner join race_serie as
rs on (rs.serie_id=s.id) inner join races as r on (r.id=rs.race_id) inner
join participants as p on (p.race_id=r.id) where s.receipt=1 and
p.rider_id=236 and fee 0
Message -
From: Jørn Dahl-Stamnes [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Sunday, July 30, 2006 2:40 PM
Subject: Problems with WHERE clause
I got the following query:
select s.id,s.name,sum(p.fee) as fee from serie as s inner join race_serie
as
rs on (rs.serie_id=s.id) inner join
You must specify explicitly what 'fee' to use... so if you wand every
p.fee to be greater than zero then you must do:
SELECT s.id, s.name, SUM(p.fee) AS fee
FROM serie AS s
INNER JOIN race_serie AS rs ON rs.serie_id = s.id
INNER JOIN races AS r ON r.id = rs.race_id
INNER JOIN
On Sunday 30 July 2006 12:37, Gabriel PREDA wrote:
You must specify explicitly what 'fee' to use... so if you wand every
p.fee to be greater than zero then you must do:
SELECT s.id, s.name, SUM(p.fee) AS fee
FROM serie AS s
INNER JOIN race_serie AS rs ON rs.serie_id = s.id
INNER
Do the right thing(TM) and don't use an alias that is the same as a
field that exists (this was mentioned before by someone else).
Since there is a field in your join named fee, using fee as an
alias, is bound to cause your trouble.
Also, trying to call sum(p.fee) twice is a waste of cputime. I
Jørn Dahl-Stamnes wrote:
I got the following query:
select s.id,s.name,sum(p.fee) as fee from serie as s inner join race_serie as
rs on (rs.serie_id=s.id) inner join races as r on (r.id=rs.race_id) inner
join participants as p on (p.race_id=r.id) where s.receipt=1 and
p.rider_id=236 and fee
Hi Thomas
I try to configure replication from master to one slave for a database
with various table types (InnoDB, MyISAM) without stopping the master.
Therefore I make a mysqldump on the slave from master with this options:
mysqldump
-h master-db \
-udummyuser \
I have just started with MYSQL and am building a racing site using PHP.
I have Date, Course, Time, Horse, Odds, Result as my fields and the database
is poulated with the data.
I'm having problems with the formatting of data when it is output.
Problem 1.
I want to display the date
having problems with the formatting of data when it is output.
Problem 1.
I want to display the date in the format dd/mm/. I know you can use
the
DATE_FORMAT command but I can't seem to get it to work. Can anyone give me
the exact script I need to write.
***
select date_format(Date,%d/%m
, Odds2, `Result` FROM Results;
--
View this message in context:
http://www.nabble.com/Date-Problems-tf1937078.html#a5310495
Sent from the MySQL - General forum at Nabble.com.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
On 13 Jul 2006 at 8:27, wizard007 wrote:
I used $query_Recordset1 = SELECT date_format(Date, %d/%m/%Y) as Date,
Course, Time, Horse, Odds1, Odds2, `Result` FROM Results;
Hi,
That's a PHP error because you have a double quotes: %d/%m/%Y within double
quotes: $query_Recordset1 = SELECT ..
create view v_authornames as
select authorid, CONCAT(lastname,',',firstname)
from t_authors;
Or replace the middle term in the CONCAT function to whatever you want
to separate it -- ie, ' ' for a space, or just
CONCAT(lastname,firstname) to get output KritzerSheeri.
-Sheeri
On
Spoken too soon...
Yesterday MySQL died again... there is nothing in the log files... (be
it mysqld.log, .err, or /var/log/messages).
The hosting provider is running an application called 'big-brother'
and a lot of sef-faults appear in the logs from this. I don't know if
thins is the cause...
Hi Gabriel,
Yesterday MySQL died again... there is nothing in the log files... (be
it mysqld.log, .err, or /var/log/messages).
The hosting provider is running an application called 'big-brother'
and a lot of sef-faults appear in the logs from this. I don't know if
thins is the cause... if this
Yup... For now the problem stopped...
These humongos values were because they were initialized at MAX_INT on
that 64bit machine...
In the my.cnf file they were not mentioned at all !
2^64 - 1 == 18446744073709551615
Now look at the values below !
--
Gabriel PREDA
Senior Web Developer
On
Hello NG,
I have two tables in my mysql database
created with phpmyadmin:
t_authors:
1 authorid (primary key, auto_increment)
2 lastname
3 firstname
And a table named t_books, fields inside:
t_books:
1 bookid (primary key, auto_increment)
2 authorid (Typ:index, reference to authorid from
Hi list,
Since we bought a better hardware for our dedicated MySQL Server we
have been running into some problems.
We are using:
- Fedora Core 3 - 64bit version
- Kernel: 2.6.9-1.667smp - x86_64
- MySQL 5.0.21-standard - for 64bit
- RAM: 4 GB
- RAID 5 matrix with 3 SCSI disks at 15k rotations
we
have been running into some problems.
We are using:
- Fedora Core 3 - 64bit version
- Kernel: 2.6.9-1.667smp - x86_64
- MySQL 5.0.21-standard - for 64bit
- RAM: 4 GB
- RAID 5 matrix with 3 SCSI disks at 15k rotations
We are using InnoDB tables (with one or 2 exceptions... for some
FullText
hardware ... wonder if you could have a problem with it.
Dan
Gabriel PREDA wrote:
Hi list,
Since we bought a better hardware for our dedicated MySQL Server we
have been running into some problems.
We are using:
- Fedora Core 3 - 64bit version
- Kernel: 2.6.9-1.667smp - x86_64
- MySQL 5.0.21
]
To: mysql@lists.mysql.com
Sent: Wednesday, June 21, 2006 12:21 AM
Subject: Full-Text problems
Hi all,
I am experiencing some issues with Full-Text and was hoping someone could
shed some light on the following.
I have some content which I know contains for example the word news, the
table
!
-Original Message-
From: Brent Baisley [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 21 June 2006 10:24 PM
To: [EMAIL PROTECTED]; mysql@lists.mysql.com
Subject: Re: Full-Text problems
Perhaps the searches that return nothing are actually matching more than
50% of the record in the table
]
To: mysql@lists.mysql.com
Cc: 'Brent Baisley' [EMAIL PROTECTED]
Sent: Wednesday, June 21, 2006 8:51 AM
Subject: RE: Full-Text problems
Is there any way to test this?
I doubt it is 50%, some of these words only appear once or twice within the
content.
Kind regards,
Taco Fleur
Free Call 1800 032 982
I'm obviously getting myself into more and more trouble with fulltext..
I have the following SQL statement;
SELECT indexIdentity, webpageIdentity, content, MATCH (content) AGAINST
('gallery' ) as score FROM db_com_pacificmomentum.tbl_index
where MATCH (content) AGAINST ('gallery' );
Which
* Domain Registration, .COM for as low as fifteen dollars a year,
.COM.AU for fifty dollars two years!
-Original Message-
From: Brent Baisley [mailto:[EMAIL PROTECTED]
Sent: Thursday, 22 June 2006 2:07 AM
To: [EMAIL PROTECTED]; mysql@lists.mysql.com
Subject: Re: Full-Text problems
.
now after i have done make install i do
ln -s /opt/.mysql-4.1.20 /opt/mysql
/opt/mysql/bin/mysql_install_db --user=mysql
cd /opt/mysql
chown -R root *
chown -R mysql var
chgrp -R mysql *
And now the problems start.
The server runs fine, but the client doesn't work _at all_:
(root)/opt/.mysql
On Tuesday 20 June 2006 12:02 pm, Martin Jespersen wrote:
./configure --prefix=/opt/.mysql-4.1.20 --enable-assembler
--enable-thread-safe-client --enable-static=all --with-gnu-ld
--with-mysqld-user=mysql --without-debug
--with-client-ldflags=-all-static --with-mysqld-ldflags=-all-static
I thought of that, but i didn't think it'd be a problem since i do have
thpse shared libraries for the application to use at runtime - and since
the server runs just fine, i doubt that is what is causing the problem
(tho it is definately worth trying). It seems to me that if this is
truely the
Hi all,
I am experiencing some issues with Full-Text and was hoping someone could
shed some light on the following.
I have some content which I know contains for example the word news, the
table is MyISAM, the column type is LONGTEXT, there is an index on the
column of FULLTEXT.
I have
Hello,
I'm trying to compile mysql-5.0.22 on Solaris 10 using the Forte Compiler
(cc: Sun C 5.8 2005/10/13). I'm doing this so I can build
the DBI driver for mysql (DBD::mysql). The .pkg versions
are missing libmysqlclient.so required to build DBD::mysql
Hi all,
I've been using MySQL for over a year now and I didn't install
anything special recently, yet I suddenly find myself locked out of
MySQL.
I'm using version 3.23.49 and I'm running Mac OS 10.4.6 fully up-to-
date. I normally connect using the root-user but this afternoon I
first
Kevin -
You can start up the MySQL server without password protection using the
--skip-grant-tables option. Note that will leave your server wide open,
so you may also want to use the --skip-networking option and access it
through the socket on the same machine.
Something like this I
Dan,
A thousand times thanks for the fast reply, I just reset my password
with MySQL Administrator now, everything is back the way it was!
On a sidenote: I also saw this as the version MySQL 5.0.17-max via
socket. The version 3 was through phpinfo(). My php install and
other MySQL do all
Hello,
I have been using MySQL version 4.0 because I have experienced problems since
version 4.1 and later versions...
I tried to update to version 5.0 but problems remain, in short
Due to my stupidity I had been using latin1 encoding for my database even
though everything seemed quite
Ioannis Anifantakis wrote:
Hello,
I have been using MySQL version 4.0 because I have experienced problems since
version 4.1 and later versions...
I tried to update to version 5.0 but problems remain, in short
Due to my stupidity I had been using latin1 encoding for my database even
Hi all,
I have downloaded and installed the myodbc3 driver for MacOSX onto my
Panther machine (10.3.9). First surprise, the MySQL graphical installer
doesn't seem to appear in the Applications folder, has it been dropped ?
Secondly, although I have manage to configure ODBCAdministrator, the
Dear all,
I've been testing our backup and recovery strategies here at work.
When dumping all the databases I'm using this command:
mysqldump --all-databases --force -u root -p -h 192.168.45.7 all.sql
When this command is run I receive these error messages:
mysqldump: mysqldump: Couldn't
Paul Nowosielski wrote:
Dear all,
I've been testing our backup and recovery strategies here at work.
When dumping all the databases I'm using this command:
mysqldump --all-databases --force -u root -p -h 192.168.45.7 all.sql
When this command is run I receive these error messages:
On Thursday 25 May 2006 12:09, you wrote:
Paul Nowosielski wrote:
Dear all,
I've been testing our backup and recovery strategies here at work.
When dumping all the databases I'm using this command:
mysqldump --all-databases --force -u root -p -h 192.168.45.7 all.sql
When this
Paul Nowosielski wrote:
On Thursday 25 May 2006 12:09, you wrote:
Paul Nowosielski wrote:
Dear all,
I've been testing our backup and recovery strategies here at work.
When dumping all the databases I'm using this command:
mysqldump --all-databases --force -u root -p -h 192.168.45.7
Gerald,
Thank you that worked. now I'm receiving this error:
dev:/tmp # /usr/local/mysql/bin/mysqldump -u root -p -h 192.168.45.7 --force
--all-databases all.sql
Enter password:
/usr/local/mysql/bin/mysqldump: Can't get CREATE TABLE for table
`help_category` (File
Hi, I'm having problems with a trigger that I'm working on, I want to create
a trigger that after inserting a row in table A will copy the row to table B
and once there will delete the row from table A.
I'm using two triggers for this one goes on table A and does the copy of the
information
Dear MySQL,
I've installed 5.1.9 from source on a SUSE 10 box. But I can't get
InnoDB tables respected.
I have used the correct compilation flag (--with-innodb).
SHOW VARIABLES; lists all the usual innodb variables.
The innodb table space has been created in ~/var/ibdata1.
But if I enter:
201 - 300 of 2763 matches
Mail list logo