side-by-side Error on Vista
Hello, I've install mysql on Vista using the mysql-5.0.51a-win32 setup. When I try and run MySQLInstanceConfig.exe (even as Administrator) I get an error The application has failed to start because its side-by-side configuration is incorrect Anyone know why this is? thanks, Dave. -- Dr. David Holden. See: http://www.gnu.org/philosophy/no-word-attachments.html regarding Word or PowerPoint. GPG key available on request. - -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Decimal - Maximum is 30
At 9:50 PM -0600 1/31/08, Peter Brawley wrote: Postgres has PostGIS Oracle has OracleSpatial MySQL has ? OpenGis. As stated here: http://dev.mysql.com/doc/refman/5.0/en/gis-introduction.html -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
lock (deadlock?) queries
Hello All. I need your help with Mysql. I'am using version 5.1.22 compiled with libthread and MyISAM engine on FreeBSD 6.2-STABLE and some times getting lock (deadlock?) on parallel update queries from some hosts. Very long time the query is keep state Updating and no disk, cpu and other activity. Kill command only change status to killed :( After manipulations impossible shutdown server normally. Used kill -9. Also partitioning used, but in other table. Tkanks. Table format and output show full process list attached. CREATE TABLE `tbl_test` ( `uid` varchar(64) NOT NULL DEFAULT '', `domain` varchar(64) NOT NULL DEFAULT '', `ip` int(10) unsigned DEFAULT NULL, `tt` timestamp NOT NULL DEFAULT '-00-00 00:00:00', UNIQUE KEY `idx_domainuid` (`domain`,`uid`), KEY `idx_tt` (`tt`) ) ENGINE=MyISAM DEFAULT CHARSET=ascii +--+--++-+-+---+--+--- -- -+ | Id | User | Host | db | Command | Time | State| Info | +--+--++-+-+---+--+--- -- -+ |1 | user_test | 10.10.10.33:57296 | db_mail | Query | 1408 | Locked | UPDATE tbl_test SET tt = IF((@t := STR_TO _DATE('Fri Feb 1 17:06:16 2008', %a %b %e %T %Y)) tt, @t, tt), ip = IF(@t = tt, INET_ATON('x.x.x.x'), ip) WHERE uid = 'lknan' AND domain = 'example.ru' | |2 | user_test | 10.10.10.93:58937 | db_mail | Query | 1408 | Locked | UPDATE tbl_test SET tt = IF((@t := STR_TO_DATE('Fri Feb 1 17:06:16 2008', %a %b %e %T %Y)) tt, @t, tt), ip = IF(@t = tt, INET_ATON('x.x.x.x'), ip) WHERE uid = 'galin' AND domain = 'example.ru' | |3 | user_test | 10.10.10.94:52218 | db_mail | Query | 1408 | Updating | UPDATE tbl_test SET tt = IF((@t := STR_TO_DATE('Fri Feb 1 17:06:16 2008', %a %b %e %T %Y)) tt, @t, tt), ip = IF(@t = tt, INET_ATON('x.x.x.x'), ip) WHERE uid = 'igv' AND domain = 'example.ru' | |4 | user_test | 10.10.10.222:50197 | db_mail | Query | 1408 | Locked | UPDATE tbl_test SET tt = IF((@t := STR_TO_DATE('Fri Feb 1 17:06:16 2008', %a %b %e %T %Y)) tt, @t, tt), ip = IF(@t = tt, INET_ATON('x.x.x.x'), ip) WHERE uid = 'sky' AND domain = 'example.ru' | +--+--++-+-+---+-+--+ | Id | User | Host | db | Command | Time | State | Info | +--+--++-+-+---+-+--+ |1 | user_test | 10.10.10.33:57296 | db_test | Query | 1458 | Locked | UPDATE tbl_test SET tt = IF((@t := STR_TO_DATE('Fri Feb 1 17:06:16 2008', %a %b %e %T %Y)) tt, @t, tt), ip = IF(@t = tt, INET_ATON('x.x.x.x'), ip) WHERE uid = 'lknan' AND domain = 'example.ru'| |2 | user_test | 10.10.10.93:58937 | db_test | Query | 1458 | Locked | UPDATE tbl_test SET tt = IF((@t := STR_TO_DATE('Fri Feb 1 17:06:16 2008', %a %b %e %T %Y)) tt, @t, tt), ip = IF(@t = tt, INET_ATON('x.x.x.x'), ip) WHERE uid = 'galin' AND domain = 'example.ru' | |3 | user_test | 10.10.10.94:52218 | db_test | Query | 1458 | Updating | UPDATE tbl_test SET tt = IF((@t := STR_TO_DATE('Fri Feb 1 17:06:16 2008', %a %b %e %T %Y)) tt, @t, tt), ip = IF(@t = tt, INET_ATON('x.x.x.x'), ip) WHERE uid = 'igv' AND domain = 'example.ru' | |4 | user_test | 10.10.10.222:50197 | db_test | Query | 1458 | Locked | UPDATE tbl_test SET tt = IF((@t := STR_TO_DATE('Fri Feb 1 17:06:16 2008', %a %b %e %T %Y)) tt, @t, tt), ip = IF(@t = tt, INET_ATON('x.x.x.x'), ip) WHERE uid = 'sky' AND domain = 'example.ru' | +--+--++-+-+---+--+--+ | Id |
Convert Dbase file to mysql and enter data
Hello I have a dbase3 database that I would like to convert to mysql. After I download mysql (need a link to a stable version), what do I need to do to create a mysql database with the dbase fields and then import the data. In addition is there some sort of gui tool that will allow me to enter data and this uses a insert sql statement (in the background) to put the data in the database. I know sql but I would like to get a quick jump on it. Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Convert Dbase file to mysql and enter data
Andrew, I have a dbase3 database that I would like to convert to mysql. A dBASE III database isn't a database but rather a single ASCII fixed-field-length data table with a binary header describing data layout. I think these are your main choices: (i) if you have an xbase product on hand (dBASE III, Clipper, FoxPro c), open the file in that tool, export its data via SET ALTE; (ii) if you Google for 'dbf to mysql', you will find a few tools that do the job for various xbase inputs; (iii) and most fiddly, strip off the binary header, decode it manually or with an xbase tool, then write a script in a language with a MySQL API (C, PHP, Perl, Access, .NET, Java, Python, Ruby) to import the fix-length rows of data into an appropriately defined MySQL table. PB [EMAIL PROTECTED] wrote: Hello I have a dbase3 database that I would like to convert to mysql. After I download mysql (need a link to a stable version), what do I need to do to create a mysql database with the dbase fields and then import the data. In addition is there some sort of gui tool that will allow me to enter data and this uses a insert sql statement (in the background) to put the data in the database. I know sql but I would like to get a quick jump on it. Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Error in /index.php: Access denied for user 'apache'@'localhost' (using password: NO)
Hello mysql, I just started having this problem and wonder if someone might give me a clue why this is happening. The scenario is that I build a CMS on my local XP system to make sure it is working correctly and customize it per the client's specifications. Almost always the client has some version of this software running on their site, if not the same version. I make mods to the database, test it out and import the tables into the client system. Generally, it works with no problem. But the last two times I have received Acess denied for user [EMAIL PROTECTED] on two completely different systems, even separated by Continents ;-) On the first system, I dropped and replaced all the tables but on this second one, I didn't drop several huge tables that I didn't want to upload redundant data for so I left them intact to save time and bandwidth. I have done this sort of transfer hundreds of times with no trouble but the last two in a row have required that the permissions be reset. I am just looking at the error messages in the emails I am getting and apparently it is not just the Apache user. It is sending access denied for the site account owner too, I just noticed. I am using the same login credentials from the configuration files to connect to the database including username/password yet I get this apache error message. Any ideas or explanations on this greatly appreciated in advanced. -- Best regards, mikesz mailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]