Re: Trouble w/ mysqldump (images attached)

Thanks for all your help Gleb! I Appreciate all your hard work! In a message dated 1/12/2005 5:31:19 AM Eastern Standard Time, Gleb Paharenko <[EMAIL PROTECTED]> writes: >Hello. > >[mysqldump] >default_character_set = latin1 > > > >[EMAIL PROTECTED] wrote: >> amazing.. I failed to see that i

Re: Trouble w/ mysqldump (images attached)

Hello. [mysqldump] default_character_set = latin1 [EMAIL PROTECTED] wrote: > amazing.. I failed to see that in the last msg - but that seemed to do the > trick - The images appear correctly now.. is there anyway in my.cnf to tell > it to always use the command?? Thanks much for the

Re: Trouble w/ mysqldump (images attached)

amazing.. I failed to see that in the last msg - but that seemed to do the trick - The images appear correctly now.. is there anyway in my.cnf to tell it to always use the command?? Thanks much for the help! In a message dated 1/11/2005 4:48:27 AM Eastern Standard Time, Gleb Paharenko <[EMA

Re: Trouble w/ mysqldump (images attached)

Hello. Have you tried to perform the dump using --default-character-set=latin1 option and then restore data from it? [EMAIL PROTECTED] wrote: > Hello, thanks for helping! Here is the output of the requested statements on > live database: > > > SHOW CREATE TABLE avatardata; > | custo

Re: Trouble w/ mysqldump (images attached)

Hello, thanks for helping! Here is the output of the requested statements on live database: SHOW CREATE TABLE avatardata; | customavatar | CREATE TABLE `customavatar` ( `userid` int(10) unsigned NOT NULL default '0', `avatardata` mediumtext NOT NULL, `dateline` int(10) unsigned NOT NULL defa

Re: Trouble w/ mysqldump (images attached)

Hello. mysqldump usually produced SET NAMES utf8 at the begining of the dump file. The clues may be in this. Send us the output of such statements: SHOW CREATE TABLE avatardata; SHOW CREATE DATABASE 'put the name of the avatar database'; SHOW VARIABLES LIKE '%char%'; and your my.

Re: Trouble w/ mysqldump (images attached)

Hi Dr. The avatars still show fine on 4.18a -- but the problem occurs when I actually do a dump and reimport the dump file. That's when something goes array.. Kinda weird if you ask me.. I wish that vBulletin wouldn't actually hard code the binary in a table, lol.. It's got me totally baffled

RE: Trouble w/ mysqldump (images attached)

I have reinstalled the v3 RPM again to my system, and used one of my original backups from that same version. In 3.23 there is no 'collation' field.. I wonder if that is the problem?? I am going to change it to latein1_bin to see what happens next.. Thanks! I'll let you know! In a messag

Re: Trouble w/ mysqldump (images attached)

Hi, [EMAIL PROTECTED] schrieb: Hi Tom, Thanks for the reply! I show the following information for my DB, and shows the same for both the 3.23 DB And the 4.18a DB Field Type Collation avatardata mediumtext latin1_swedish_ci I pasted a data table from the ba

RE: Trouble w/ mysqldump (images attached)

Hi there, [EMAIL PROTECTED] wrote on Thursday, January 06, 2005 7:19 PM: > Thanks for the reply! I show the following information for my DB, > and shows the same for both the 3.23 DB And the 4.18a DB > > Field Type Collation > avatardata --

RE: Trouble w/ mysqldump (images attached)

Hi Tom, Thanks for the reply! I show the following information for my DB, and shows the same for both the 3.23 DB And the 4.18a DB Field Type Collation avatardata mediumtext latin1_swedish_ci I pasted a data table from the bad avatar and the good avatar t

RE: Trouble w/ mysqldump (images attached)

[EMAIL PROTECTED] wrote on Thursday, January 06, 2005 4:57 PM: > Sorry, forgot the attachments. These are the same exact two > avatars from the same user, using my 3.23 backup, for the > good avatar, then the 4.18 bad avatar Looks like a character set issue - what's th

Re: Trouble w/ mysqldump (images attached)

Sorry, forgot the attachments. These are the same exact two avatars from the same user, using my 3.23 backup, for the good avatar, then the 4.18 bad avatar <><>-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED

Re: Trouble w/ mysqldump

I am confused over the much smaller DataBase, but also of the corrupted avatars and file attachments (I've attached examples).. I did some research using mysqladmin, and the 'attachment' and the 'customavatar' tables are exactly the same size in both databases, but the entire DB is about 10MB sm

Re: Trouble w/ mysqldump

Hello. > Right, three is a true dump file, and I can restore the database, everything >'seems' to be there, So, as I understand, the only thing that were confusing you, was the small dump file? If you see binary files after restoring from the dump file - they are in the dump file. I think

Re: Trouble w/ mysqldump

Right, three is a true dump file, and I can restore the database, everything 'seems' to be there, I can browse the table all day long, and I can see the binary files in the database, but the length of the tables are different. mysql@lists.mysql.com In a message dated 1/5/2005 3:50:39 AM Eastern

Re: Trouble w/ mysqldump

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: > Tha

Re: Trouble w/ mysqldump

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

Re: Trouble w/ mysqldump

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 us

Trouble w/ mysqldump

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