Trigger Lock table

System Linux SUSE 9.1 with mysql-max-5.0.11-beta-linux-i686.tar.gz Trigger: create trigger CustomerHistoryUPD BEFORE Update on Customer For each ROW BEGIN insert into CustomerHist select * from Customer where FD_ID = OLD.FD_ID; Update CustomerHist set HistDate = NOW() where FD_ID =

Trouble configuring mysql-nt as a service with --skip-.* switches

C:\mysql\binmysqld-nt.exe --version mysqld-nt.exe Ver 4.0.25-nt-log for Win32 on ia32 (Official MySQL binary) C:\mysql\binmysqld-nt.exe --install MySQL --defaults-file=%windir%\my.ini Service successfully installed. C:\mysql\binmysqld-nt.exe --remove Service successfully removed.

'ODBC'@'localhost' instead of 'root'@'invalid_hostname.com' ?!??

Hi, I'm using PHP/MySQL to development a web-based application. I just upgraded both PHP and MySQL and I noticed that some of my MySQL calls are now broken and I don't see any easy way to fix them. My script calls mysql_connect() and does very careful error checking. It's important that I

renaming a database

Hi, Please tell me how to rename a database. I couldn't find this in the manual. I have tried to rename manually the name of the directory that holds that database, but some tables can't be accessed after that. (I have found that they are InnoDB tables, even though I never specified that I want

Re: renaming a database

Octavian Please tell me how to rename a database. As you already found, there are database features that don't survive renaming its directory. Best method I know is to mysqldump it and recreate it from the dump under the desired name. PB http://www.artfulsoftware.com - Octavian

Re: MySQLDUMP Problem

On Thursday 18 August 2005 09:34, Carlos J Souza wrote: Sirs, When i use mysqldump on Version 4.1.x, all tables had a one record insert generated in script. When i use mysqldump on a 4.0.x version this problem dos not occurs. How to solve it? That's because extended inserts are on by

MySQLD aborts

Hi: I have version 4.0.20 on slack 10.0. Mysqld fails on startup. From mysqld is the following: 50821 11:10:44 mysqld started 050821 11:10:44 Warning: Can't create test file /var/lib/mysql/linus.lower-test ^G/usr/libexec/mysqld: Can't change dir to '/var/lib/mysql/' (Errcode: 13) 050821

Replication seems ok, but doesn't work

Hello, I have set up replication between several servers, all using the same version of mysql (4.0.25, however on different Versions of SuSE-Linux). Production databases of the master server are replicated on the slave server using the same database name with an underscore. This works in all but

Re: MySQLD aborts

Tim Johnson wrote: Hi: I have version 4.0.20 on slack 10.0. Mysqld fails on startup. From mysqld is the following: 50821 11:10:44 mysqld started 050821 11:10:44 Warning: Can't create test file /var/lib/mysql/linus.lower-test ^G/usr/libexec/mysqld: Can't change dir to '/var/lib/mysql/'

MySQL REGEXP problems...

SELECT * FROM tbl WHERE item REGEXP 'SEARCHSTRING' Database holds: SAMSUNG IDE 40GB 7200RPM Search for SAMSUNG IDE 7200RPM = 0 RESULTS SAMSUNG 40GB 7200RPM = 0 RESULTS SAMSUNG +40GB +7200RPM = 0 RESULTS SAMSUNG IDE 40GB = 1 RESULT How do i need to change the SEARCHSTRING to use AND for each

Re: MySQL REGEXP problems...

Here is another user with the same problem http://forums.pcworld.co.nz/archive/index.php/t-34536.html Maybe his explanation is better :) Quoting John thegimper [EMAIL PROTECTED]: SELECT * FROM tbl WHERE item REGEXP 'SEARCHSTRING' Database holds: SAMSUNG IDE 40GB 7200RPM Search for

Re: MySQL REGEXP problems...

ok just figured out that if the database contains one and one is two and i use regexp to search for one two it will not match. If i search for one(.*)two it will. But how can i make it match if i search for two one ? Quoting John thegimper [EMAIL PROTECTED]: Here is another user with the same

Re: Is there an easy way to copy a table between two mysql servers?

Hi, I would suggest using --hex-blob and --quote-names options of the mysqldump command. regards, esv. --- Santino [EMAIL PROTECTED] wrote: Try: mysqldump -h yourhost.com -u username -ppasswd mydatabase mytable | mysql -h yournewhost.som -u newuser -ppasswd newdatabase Santino

Re: MySQL REGEXP problems...

possible answers to your request are: select * from tablename where stringname REGEXP 'SAMSUNG[^4]*40GB'; select * from tablename where stringname REGEXP 'SAMSUNG.*40GB' they both matched your sample string, I personally like the first one better but it is up to you the one to use. regards,

Re: MySQL REGEXP problems...

John, using 'one.*two|two.*one' would do it. :) regards, esv. --- John thegimper [EMAIL PROTECTED] wrote: ok just figured out that if the database contains one and one is two and i use regexp to search for one two it will not match. If i search for one(.*)two it will. But how can i

Re: MySQLD aborts

... You can get more info about an error message with perror: ~: perror 13 OS error code 13: Permission denied As you guessed, a permissions error. Apparently, the user running mysqld (usually user mysql) does not have access rights to /var/lib/mysql/. Most likely, user mysql