mysqldump failing to load data

Hi, MySQL v4.1.22 on Linux 2.6.18-6-686 I have a dump file generate with mysqldump created by a version 4.1.10 server. I want to import the dump file into a different server. When I run mysqldump --database mydb --debug < mydumpfile.sql I get the following: -- MySQL dump 10.9 -- -- Host: loca

binary handling - any difference between V4 and V5

Hi, First off, you have to forgive my ignorance, I'm not very savvy with DBs so I hope that I explain myself correctly. I have an anomaly on a development system. There are several fields with the type set as bigint(20) that are meant to store a bit pattern. The pattern is used to determine count

Install/compile problems

/client' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/usr0/src/mysql-4.0.15a' make: *** [all] Error 2 Dermot Paikkos [EMAIL PROTECTED] Network Administrator @ Science Photo Library Phone: 0207 432 1100 Fax: 0207 286 8668 -- MySQL General Mailing Li

Select problem

t would be greatly appreciated. Dermot -- whathaveibecome? mysweetestfriend everyoneiknow goesawayintheend youcouldhaveitall myempireofdirt iwillletyoudown iwillmakeyouhurt ificouldstartagain amillionmilesaway iwouldkeepmyself iwouldfindaway -- MySQL General Mailing List For list arch

date_add function

current_date or feed the values from one (or 2) fields. Ideally I just want the return the time +7 hours. What would also help out is if someone can explain if there is a general rule for using literal strings and column values? Thanx. Dp. ~~ Dermot Paikkos * [EMAIL PROTECTED] Network Admi

SUMMARY how to retrieve data from two tables?

ork with but once I add "AND t.date = (current_date) I get 0 records returned and I need the users.id an users.surname. Can anyone think of a way round this? ~~ Dermot Paikkos * [EMAIL PROTECTED] Network Administrator @ Science Photo Library P

how to retrieve data from two table?

once I add "AND t.date = (current_date) I get 0 records returned and I need the users.id an users.surname. Can anyone think of a way round this? Thanx. Dp. sql,mysql,query. ~~ Dermot Paikkos * [EMAIL PROTECTED] Network Administrator @ Science Photo Library Phone: 0207 432 1100 * Fax: 0207 286

SUMMARY: how to update time field with current time?

Thanx to all those how answered: hcir walt William Mussatto David Yahoo The answer was now() or update tab_name set fd_name = (now()) where_expr; I had tried this but was missing a pair of brackets (honest..) MYSQL dp. ~~ Dermot Paikkos * [EMAIL PROTECTED] Network Administrator @ Science Photo

how to update time field with current time?

Hi Probably a silly question but how can I set a time field to the current time with update in mysql? I have 4 time fields per record. Should I have used set them up as timestamp? Thanx. Dp. ~~ Dermot Paikkos * [EMAIL PROTECTED] Network Administrator @ Science Photo Library Phone: 0207 432