Got error 1 from storage engine

Hi all! OS: Win 2000 server MySQL: mysql 4.1 I have an issue trying to restore some databases from a disk replaced, I mean, move from the old disk to the new one, I cannot launch mysqld from the old disk because boot sector was damaged, so I cannot do a mysqldump, We've replaced the disk and copi

RE: MySQL 5.0.x and Delphi

Sorry for dont start my own topic... I apologize Hi! No I haven't tested with the v5 driver yet, but I found out that the problem is when I use date_format function If I dont use it the data is returned ok in my app(but with hours, minutes etc), but if i do a date_format i get "bytes" on each rec

MySQL 5.0.x and Delphi

Hi all! I'm having problems upgrading my database from 4.0.x to 5.0.x, specially with date fields For example with 4.0.x I do: "select startDate from TEvent" and in my application it is displayed ok(managed with controls), but the same code, same odbc, same control in delphi, etc with mysql 5.0.x

RE: Dictionary

Have you had a look for aspell check? For example in eventum: http://lists.mysql.com/eventum-users/2683 This may be usefull... For example in php there are some function for aspell http://mx2.php.net/aspell Regards! Edwin. -Mensaje original- De: Scott Hamm [mailto:[EMAIL PROTECTE

RE: Show Description options??

orte | double| | iva | double| | observacion | char | | activo | char | +-+---+ 12 rows in set (0.01 sec) mysql> Regards! +--------+ | ISC Edwin Cruz

RE: Alter table

ALTER TABLE db.table DROP INDEX nameOfTheIndex; If you don't know "nameOfTheIndex" use: Show create table db.table Regards! -Mensaje original- De: Yemi Obembe [mailto:[EMAIL PROTECTED] Enviado el: Lunes, 02 de Enero de 2006 10:03 a.m. Para: mysql@lists.mysql.com Asunto: Alter table

RE: I'm new to mySQL

MySQL AB has a very good GUI tools Have a look in: http://www.mysql.com/products/tools/ You should try to use them, phpmyadmin also is good. For administration mysql-administrator To execute queries or create functions, procedures, etc mysql-querybrowser To migrate data from another RMDBS so use

Mysqldump segmentation fault(core dumped)

:/usr/obj/usr/src/sys/GENERIC i386 apps# tail -f apps.medel.com.mx.err Table status: Opened tables: 12 Open tables: 6 Open files:12 Open streams: 0 Alarm status: Active alarms: 0 Max used alarms: 0 Next alarm time: 0 I've had a look at bugs.mysql

RE: Newbie Question on Update

I guess that the problem is the reserved word "table" Try it: Update `table` Set column5=number1 where column 1 = number2 and column1 = number3 But the sintax is ok Regards! -Mensaje original- De: Kraer, Joseph [mailto:[EMAIL PROTECTED] Enviado el: Miércoles, 30 de Noviembre de 2005 1

RE: Two MySQL databases on different computers

If you have MySQL > 5.0.3 then you could use this storage engine: http://dev.mysql.com/doc/refman/5.0/en/federated-storage-engine.html It is only a recomendation. Regards! -Mensaje original- De: Peter Lauri [mailto:[EMAIL PROTECTED] Enviado el: Viernes, 25 de Noviembre de 2005 03:44 a.m

RE: dotproject

I've tryed and I only get a lot of sql errors, looking into the source code I sow that the problem is with JOIN clause. Any ideas abaut how to install it? -Mensaje original- De: ISC Edwin Cruz [mailto:[EMAIL PROTECTED] Enviado el: Miércoles, 23 de Noviembre de 2005 05:06 p.m.

dotproject

Have somebody tryed to install dotproject 2.x with MySQL 5.0.x??( The stable release) ++ | ISC Edwin Cruz <[EMAIL PROTECTED]>| | IT Manager | | Transportes Medel Rogero SA de CV | | Desk: 01 (449) 910 30 90

RE: How to SUM every row for SubTotal?

mysql> select * from table5; ++--+ | code | qty | ++--+ |100 | 30 | |200 | 20 | |300 | 25 | ++--+ 3 rows in set (0.00 sec) mysql> set @a=0; Query OK, 0 rows affected (0.05 sec) mysql> select code,qty,@a:[EMAIL PROTECTED] as subtotal from ta

RE: dump to more than 1 file

Mysqldump has "where" condition, you may have to segment your data and dump it in diferents files Mysqldump --where='date between \'dateStart\' and \'dateFinish\' ' (for example) See full documentation at: http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html Regards!! Edwin Cruz -Me

RE: Runing MySQL on boot

If you´ve installed mysql from ports the startup sript is under /usr/local/etc/rc.d/ Change its permissions to be extecutable I hope that this help you Regards! ++ | ISC Edwin Cruz García | | IT Manager

RE: Backward-compatible authentication in v5.0?

Hi! It is a common error, have a look here: http://dev.mysql.com/doc/refman/5.0/en/old-client.html I have had the same error. ++ | ISC Edwin Cruz García | | IT Manager | | Transportes Medel Rogero SA de CV

RE: Sum entire group listing

SELECT products.product, products.price, count( log.product ) AS 'Count', ROUND(price*count(log.product), 2) AS 'Total' FROM products LEFT JOIN log ON products.product= log.product GROUP BY product Union SELECT 'Total', '', count( log.product ) AS 'Count', ROUND(price*count(log.product), 2) AS 'T

RE: How to write this query?

Try it: select distinct a.* from order a, item b, item_status c, status d where a.order_id = b.order_id and b.item_id=c.item_id and c.item_status_id = d.item_status_id where d.status = 'completed' It isn´t "tunned" but I think that it works for that you want -Mensaje original- De: Jerry

RE: report from two tables

Try it: SELECT o.Trans_No, o.SoldBy, 'NA', sm.LName, sm.FName, sm.Salesperson_No FROM v_orders as o, v_salesmen as sm WHERE o.Order_Date = '". $report_starts."' AND sm.Salesperson_No = o.SoldBy UNION SELECT o.Trans_No, o.SoldBy, 'A', sm.LName, sm.FName, sm.Salesperson_No FRO

Migration problem

N | | innodb_thread_concurrency | 20 | | innodb_thread_sleep_delay | 1 | +-++ 33 rows in set (0.00 sec) Tanks a lot for any suggestion +---