> I am having problems with my mysq db. The symthoms are many I'll > list them: > > 1. some select statements return error when the dataset grows to > a certain size, > I think this is because of defect records.
You do not provide a lot of information to go by. Getting the obvious questions out of the way: - At what size of the DB does it fail? - Do you have enough disk space for all those records? And then: Have you run CHECK TABLE on your tables? Which statements fail? What is the structure of the tables involved? And most important of all: What is the error message you get? > 2. Mysqldump does not dump the compleat tables. Which command do you use when running mysqldump? What is missing? / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php