Hello.


> The actual tables are there 



I assume that 'there' is a dump file. One more question, can you

select the Avatars data using SQL queries? For example:

  SELECT 'Avatar_field' from 'avatar_table' limit 1;

Does your application work after upgrade?





[EMAIL PROTECTED] wrote:

> Thanks for the reply.

> My original install was w/ an RPM from the Redhat Network, I uninstalled all 
> RPM's associated w/ MySQL, Apache, and PHP and downloaded the latest of 
> everything and compiled it. After I did an updatedb on my box, I searched for 
> "mysqldump" and "mysql" to confirm it was gone -- nothing was found.   

> 

> ./mysqldump Ver 10.9 Distrib 4.1.8a, for redhat-linux-gnu (i686)

> 

> The actual tables are there, but the images (or any attachments) are really 
> messed up.  Looks like something from the 60's, lol.

> 

> In a message dated 1/4/2005 9:36:01 AM Eastern Standard Time, Gleb Paharenko 
> <[EMAIL PROTECTED]> writes:

> 

>>Hello.

>>

>>In what way have you upgraded? How do you dump the data? Is everything fine,

>>execept the database dump? As of MySQL 4.1, --opt command line option is on 
>>by 

>>default, so it can produce a smaller output. The definions of tables

>>which stores Avatars are also absent in dumps? May be you use mysqldump

>>from old 3.23 version?

>>

>>

>>[EMAIL PROTECTED] wrote:

>>> Hi All,

>>> I run a website, and am having a problem w/ corrupt databases..

>>> 

>>> I was runnig MySQL v3.23 previously, and my db dumps worked fine .. 
>>> However, I have since upgraded to v4.1.8a-log and I am having problems 
>>> getting completed (or non corrupt) backups.. The problem is pretty big..

>>> 

>>> My Original Backup of the DB using 3.23 was 208MB --- When I upgraded to 
>>> 4.18 the backup is only 138MB ... My users Avatar's, all attachments, etc 
>>> are totally whacked out. Does anyone have any insight on what is causing 
>>> this, and how to fix it? Any help is appreciated.. I need a new good backup 
>>> desperately 

>>> 

>>

>>

>>

-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
       <___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to