Search results for query: *

I have used the repair table option to try and repair a table that has crashed, this did not seem to work it was suggested that i use the following option. REPAIR TABLE wrm_tellafriend EXTENDED I have used this option but I am not sure if it is working or not after entering this command a...

Robbie2003 (IS/IT--Manageme) Mar 26, 2004 Hi I am new to MYSQL and hoped for some advice on the following. I am unable to access one of my tables, when I try to access it I get the following massage. Database wrm - Table wrm_tellafriend running on localhost Error SQL-query : SELECT *...

No I have not tried these as I do not know how to I only seem to be able to find the option that says repair table as shown below, I would be very grateful if you would be kind enough to explain to me how I can find and use these options. Drop Empty Print view Optimize Table Check Table...

Hi I am new to MYSQL and hoped for some advice on the following. I am unable to access one of my tables, when I try to access it I get the following massage. Database wrm - Table wrm_tellafriend running on localhost Error SQL-query : SELECT * FROM `wrm_tellafriend` LIMIT 0 , 30 MySQL...

Thanks Bastien I will let you know how we get on!

Thanks Vanekl, I will let you know how we get on it's going to take us a few days to get a new server ordered and set-up + some time to transfer all the data over. Once again thanks!

HANDLE: Robbie2003 POSTED ON: Nov 24 Bastien/vanekl Hi guy's we have done everything suggested unfortunatly this has not resolved our problem it does not seem to have made any difference. Do you think the ram could be the problem we are using a server with only 256 meg of ram from a hosting...

The table in question has 5 columns: An autoincrement mediumint (primary key) An e-mail address varchar column A tinyint (boolean) column denothing wether the user has receieved a particular kind of e-mail Another tinyint (boolean) column denothing wether the user has receieved a...

Thanks Bastien I will let you know the result when I have deleted the indexes, these indexes take aprox seven hours each to delete.

The table in question has 5 columns: An autoincrement mediumint (primary key) An e-mail address varchar column A tinyint (boolean) column denothing wether the user has receieved a particular kind of e-mail Another tinyint (boolean) column denothing wether the user has receieved a...