Hello,
today I got this in my logs and mysql stopped working.
InnoDB: http://dev.mysql.com/doc/mysql/en/InnoDB_troubleshooting_datadict.html
InnoDB: how to resolve the issue.
071107 8:46:26 InnoDB: Flushing modified pages from the buffer pool...
071107 8:46:26 InnoDB: Started; log sequence
Hi.
Working on Linux, I've got installed MySQL 3.23.58, but I'm
experiencing some problems. For instance, I suffer too many
connections error but I cann't set 'max_connections' parameter to a
value bigger than 250.
I decided to migrate to MySQL 5.0, and I've got some questions:
- I installed
On Wed, 2007-11-07 at 10:22 +0100, thomas Armstrong wrote:
Hi.
Hello,
Working on Linux, I've got installed MySQL 3.23.58, but I'm
experiencing some problems. For instance, I suffer too many
connections error but I cann't set 'max_connections' parameter to a
value bigger than 250.
... and
Hi Tiago. Thank you very much for your answer.
I decided to migrate to MySQL 5.0, and I've got some questions:
- I installed MySQL from sources on '/usr/local/mysql'. Is it as easy
as installing it again on '/usr/local/mysql5'?
Yep. Just change the '--prefix' com './configure' time.
ok
Hi All
Make sure you use the mysqldump from version 5 and not version 3. Also
recheck all your application queries once you have restored the data the
list of changes SQL syntax might haunt you.
Mark
thomas Armstrong wrote:
Hi Tiago. Thank you very much for your answer.
I decided to
Make sure you use the mysqldump from version 5 and not version 3. Also
recheck all your application queries once you have restored the data the
list of changes SQL syntax might haunt you.
But can I use '/usr/local/mysql5/bin/mysqldump' to dump data of MySQL 3?
--
MySQL General Mailing List
Never tried it with version 3 only 4.1 but it has a --compatible switch
with a version 3.23 switch see command line --help so I assume the mysql
guys are allowing you to dump 3.23. Try dumping it without the switch as
you will be restoring to 5.0. The idea is to make sure the restore is
done
Charles Jardine wrote:
I am planning to set up a system in which mysql servers access
their data via NFS. All the computers involved run Solaris 10.
NFS version 4 will be used.
I plan to ensure that no NFS share is ever mounted by more than
one client computer, and that no client computer ever
I am planning to set up a system in which mysql servers access
their data via NFS. All the computers involved run Solaris 10.
NFS version 4 will be used.
I plan to ensure that no NFS share is ever mounted by more than
one client computer, and that no client computer ever runs more
than one mysql
My apologies, try this:
DELIMITER ;;
CREATE TRIGGER DEL_TB_INSTRUKSI AFTER DELETE ON Tb_Instruksi
FOR EACH ROW
BEGIN
DELETE FROM Tb_Stuffing WHERE No_Instruksi = OLD.No_Instruksi;
END;
;;
DELIMITER ;
To answer your question:
The DELIMITER statement tells MySQL to use a different set of
Marc
ERROR 1418 (HY000): This function has none of DETERMINISTIC, NO SQL, or
READS SQL DATA in its declaration and binary logging is enabled (you *might*
want to use the less safe log_bin_trust_function_creators variable)
It has to do with whether the fnc is deterministic and how its results
Try putting the data directory on a small partition and let it get filled 100%
with a single update that does not get fully committed due to disk full, then
turn the power off to the computer so there is no attempt for a nice shutdown.
You should also get a corruption in the master binary logs,
Your mysql server is either not running, or is not creating the sock file at the
location /var/lib/mysql/mysql.sock that calendar.php expects.
What do you get when you do this?
linux$ ls -la /var/lib/mysql/mysql.sock
look in the my.cnf file to find where the MySQL sock is written to, and modify
Hi
I'm working with mysql 5.0.24a-log trying to create a procedure as is
indicated at mysql web page
and i get the following error before delimiter ;
mysql delimiter //
mysql CREATE FUNCTION hello (s CHAR(20)) RETURNS CHAR(50)
- RETURN CONCAT('Hello, ',s,'!');
- //
Query OK, 0 rows
Hi Charles, all !
Charles Jardine wrote:
I am planning to set up a system in which mysql servers access
their data via NFS. [[...]]
If you want to use this for testing or development - fine.
If you want to run performance measurements on this - silly.
If you want to use it for production
Guys, just wanted to thank you again for helping me with
the sql statement that I needed. I was able to sorted using
php and I was able to display the correct result.
Thanks again!!1
Nestor :-)
On Nov 6, 2007 7:37 AM, Néstor [EMAIL PROTECTED] wrote:
You guys are correct, that is exactly what
Hello,
We are trying to upgrade from 4.0 to 5 and we are not having any luck on the
character sets.
We need to use French characters for some things.
We have tried setting utf8 for everything we can find but the characters
still show all screwed up..
I have read the manual regarding all
DROP FUNCTION IF EXISTS secs_to_hrs;
DELIMITER |
create function secs_to_hrs (secs varchar(10))
returns varchar(13)
DETERMINISTIC
BEGIN
return CONCAT_WS(' h ',lpad(secs/60 div 60,3,' ') ,
CONCAT(lpad(round(secs/60 mod 60),2,' '),' mins') );
END;
|
DELIMITER ;
What if I wanted to not display
At 05:22 PM 11/6/2007, you wrote:
Hi David,
Thanks for your reply. This helped greatly.
Yeah, I supposed I could just randomly flip bits in the MySQL files
and that would do the trick.
The program I'm writing does first attempt to repair the tables with
MySQL's utilities if they're MyISAM but
looking at it through a browser, ensure that the
correct character set header is sent out.
brian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
__ NOD32 2644 (20071107) Information
:
http://lists.mysql.com/[EMAIL PROTECTED]
__ NOD32 2644 (20071107) Information __
This message was checked by NOD32 antivirus system.
http://www.eset.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com
is sent out.
brian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
__ NOD32 2644 (20071107) Information __
This message was checked by NOD32 antivirus system.
http://www.eset.com
James Sherwood wrote:
Hello,
Thanks for the info,
For the dump, I would imagine that it is latin1 as mysql 4.x is
defaulted to that I beleive.
Is there a way to dump it to utf8?
You can convert it using iconv:
I am attempting to get a simple query working:
select *,MAX(a.teaching_date) as max, MIN(a.teaching_date) as min from
teaching a, topic_cat b where a.teaching_topic = b.topic_id or
a.teaching_topic = 999 group by a.teaching_topic order by a.teaching_date
DESC
This all works, except I don't want
24 matches
Mail list logo