Error with mysqldump

2007-02-15 Thread Peter K AGANYO
When my server was running MySQL 4.1 I used mysqldump for backup with no errors - Redhat Linux 9. In fact when the server crashed and I had to restore the whole box I used the backups from mysqldump to restore all the databases and tables including the users. However, the server is now running

Re: Recreate mysql

2003-07-03 Thread Peter K Aganyo
Mario wrote: "Victoria Reznichenko" [EMAIL PROTECTED] wrote: "Mario" [EMAIL PROTECTED] wrote: I'm a newbie in experimental mode and have just deleted /ALL/ databases on a MySQL server, i.e. including the one ("mysql") that

Re: Newbie SELECT problem

2003-07-02 Thread Peter K Aganyo
Tim: Assuming that in your ealier posting the 99 was supposed to be 999, then the solution given by Mike Hillyer is excellent and should work. However, when I read your new posting, I seem to get confused. The scenario sounds totally different - excuse me - from the earlier one and would