Re: InnoDB data log files

2007-04-25 Thread Andrew Simpson
Hi Dan, Thanks for this, fixed the problem perfectly when we applied it. Andrew On Thu, 2007-04-12 at 10:45 -0500, Dan Nelson wrote: > In the last episode (Apr 12), Andrew Simpson said: > > One server had a problem while creating a backup last week. The routine > > normally

InnoDB data log files

2007-04-12 Thread Andrew Simpson
this case to expand the file id_logfile0 and instructions are not given on how to clean it out and start again. Any help on how to sort this out without a reinstall or, more importantly, to understand why this may have happened, would be greatly appreciated. Best regards, Andrew Simpso

How to move database to new server

2003-11-20 Thread Andrew Simpson
Hi I have a mysql database with 20 tables containing data whch i need to transfer to a new hosting server (i access this server via webmin.) What's the easiest way to move a database from one server to the other?. Can you export full databases from mysql (this would be the easiest), or do i ne

user types

2003-08-25 Thread Andrew Simpson
[EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] can anyone tell me the difference between the above 3. These are for the root user. i need to create a newuser and im not sure which of the above they are supposed to have thanks