Re: Re: Re: Readind a Dump W/o Expanding It

74----- Original Message ----
From: Dan Buettner <drbuettner@gmail.com>
To: Ted Johnson <whatawonderfulworldweliveintoo@yahoo.com>
Cc: mysql@lists.mysql.com
Sent: Sunday, October 15, 2006 9:22:04 AM
Subject: Re: Re: Re: Readind a Dump W/o Expanding It

How were they stored in the database?

You got me on that. I just took over this box. Here's what myqueries show:

server167# mysqlshow -uroot -p tirekingdom
Enter password:
Database: tirekingdom
+--------------------+
| Tables |
+--------------------+
| OrderItem |
| Orders |
| Photo |
| PhotosForTire |
| PhotosForWheel |
| Shopper |
| Tire |
| Vehicle |
| Wheel |
| WheelMake |
| WheelsForWheelMake |
+--------------------+
server167# mysqlshow tirekingdom Photo -uroot -p
Enter password:
Database: tirekingdom Table: Photo Rows: 2160
+-------+-------------+-------------------+------+-----+---------+-------+---------------------------------+---------+
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
+-------+-------------+-------------------+------+-----+---------+-------+---------------------------------+---------+
| oid |int(11) | NULL | | PRI | 0 | | select,insert,update,references | |
| Data | mediumtext | latin1_swedish_ci | YES | | | | select,insert,update,references | |
| Type | varchar(4) | latin1_swedish_ci | YES | | | | select,insert,update,references | |
| Name | varchar(32)| latin1_swedish_ci | YES | | | | select,insert,update,references | |
+-------+-------------+-------------------+------+-----+---------+-------+---------------------------------+---------+
server167# mysqlshow tirekingdom PhotoForTires -uroot -p
Enter password:
mysqlshow: Cannot list columns in db: tirekingdom, table: PhotoForTires: Table 'tirekingdom.PhotoForTires' doesn't exist
server167# mysqlshow -uroot -p tirekingdom PhotosForTire
Enter password:
Database: tirekingdom Table: PhotosForTire Rows: 1058
+---------+---------+-----------+------+-----+---------+-------+---------------------------------+---------+
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
+---------+---------+-----------+------+-----+---------+-------+---------------------------------+---------+
| TireID |int(11) | NULL | | PRI | 0 | | select,insert,update,references | |
| PhotoID | int(11) | NULL | | PRI | 0 | | select,insert,update,references | |
+---------+---------+-----------+------+-----+---------+-------+---------------------------------+---------+
server167# mysqlshow -uroot -p tirekingdom PhotosForWheel
Enter password:
Database: tirekingdom Table: PhotosForWheel Rows: 1098
+---------+---------+-----------+------+-----+---------+-------+---------------------------------+---------+
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
+---------+---------+-----------+------+-----+---------+-------+---------------------------------+---------+
| WheelID | int(11) | NULL || PRI | 0 | | select,insert,update,references | |
| PhotoID | int(11) | NULL | | PRI | 0 | | select,insert,update,references | |
+---------+---------+-----------+------+-----+---------+-------+---------------------------------+---------+

So, where's the blob? It isn't in some file in the site, I've checked.

Which way did you end up restoring the data?

The first way yourecommended. Using vi, I opened the file, set "ma" at the top, searched for the top of the database, entered "d`a" to delete everything above, searched for the bottom of the database, set "ma", entered G to go to the bottom,then "d`a" to delete everything else. It was a little more complicated than that, but with those steps involved.

And the dumpfile you have - howhas it been handled? I ask because if it contains binary data and was FTP'd from one machine to another the wrong way, that could have done it.

No, it was there in the box all along.
TIA,
Ted

Ted - sorry, not sure what this is showing me. Is the image data
supposed to be in the "data" field in the Photo table? It's not
there, or it's corrupt?

Dan


On 10/15/06, Ted Johnson <whatawonderfulworldweliveintoo@yahoo.com> wrote:
>
> 74
> ----- Original Message ----
> From: Dan Buettner <drbuettner@gmail.com>
> To: Ted Johnson <whatawonderfulworldweliveintoo@yahoo.com>
> Cc: mysql@lists.mysql.com
> Sent: Sunday, October 15, 2006 9:22:04 AM
> Subject: Re: Re: Re: Readind a Dump W/o Expanding It
>
> How were they stored in the database?
>
> You got me on that. I just took over this box. Here's what my queries show:
>
> server167# mysqlshow -uroot -p tirekingdom
> Enter password:
> Database: tirekingdom
> +--------------------+
> | Tables |
> +--------------------+
> | OrderItem |
> | Orders |
> | Photo |
> | PhotosForTire |
> | PhotosForWheel |
> | Shopper |
> | Tire |
> | Vehicle |
> | Wheel |
> | WheelMake |
> | WheelsForWheelMake |
> +--------------------+
> server167# mysqlshow tirekingdom Photo -uroot -p
> Enter password:
> Database: tirekingdom Table: Photo Rows: 2160
> +-------+-------------+-------------------+------+-----+---------+-------+---------------------------------+---------+
> | Field | Type | Collation | Null | Key | Default | Extra |
> Privileges | Comment |
> +-------+-------------+-------------------+------+-----+---------+-------+---------------------------------+---------+
> | oid | int(11) | NULL | | PRI | 0 | |
> select,insert,update,references | |
> | Data | mediumtext | latin1_swedish_ci | YES | | | |
> select,insert,update,references | |
> | Type | varchar(4) | latin1_swedish_ci | YES | | | |
> select,insert,update,references | |
> | Name | varchar(32) | latin1_swedish_ci | YES | | | |
> select,insert,update,references | |
> +-------+-------------+-------------------+------+-----+---------+-------+---------------------------------+---------+
> server167# mysqlshow tirekingdom PhotoForTires -uroot -p
> Enter password:
> mysqlshow: Cannot list columns in db: tirekingdom, table: PhotoForTires:
> Table 'tirekingdom.PhotoForTires' doesn't exist
> server167# mysqlshow -uroot -p tirekingdom PhotosForTire
> Enter password:
> Database: tirekingdom Table: PhotosForTire Rows: 1058
> +---------+---------+-----------+------+-----+---------+-------+---------------------------------+---------+
> | Field | Type | Collation | Null | Key | Default | Extra |
> Privileges | Comment |
> +---------+---------+-----------+------+-----+---------+-------+---------------------------------+---------+
> | TireID | int(11) | NULL | | PRI | 0 | |
> select,insert,update,references | |
> | PhotoID | int(11) | NULL | | PRI | 0 | |
> select,insert,update,references | |
> +---------+---------+-----------+------+-----+---------+-------+---------------------------------+---------+
> server167# mysqlshow -uroot -p tirekingdom PhotosForWheel
> Enter password:
> Database: tirekingdom Table: PhotosForWheel Rows: 1098
> +---------+---------+-----------+------+-----+---------+-------+---------------------------------+---------+
> | Field | Type | Collation | Null | Key | Default | Extra |
> Privileges | Comment |
> +---------+---------+-----------+------+-----+---------+-------+---------------------------------+---------+
> | WheelID | int(11) | NULL | | PRI | 0 | |
> select,insert,update,references | |
> | PhotoID | int(11) | NULL | | PRI | 0 | |
> select,insert,update,references | |
> +---------+---------+-----------+------+-----+---------+-------+---------------------------------+---------+
>
> So, where's the blob? It isn't in some file in the site, I've checked.
>
> Which way did you end up restoring the data?
>
> The first way you recommended. Using vi, I opened the file, set "ma" at the
> top, searched for the top of the database, entered "d`a" to delete
> everything above, searched for the bottom of the database, set "ma", entered
> G to go to the bottom, then "d`a" to delete everything else. It was a little
> more complicated than that, but with those steps involved.
>
> And the dumpfile you have - how has it been handled? I ask because if it
> contains binary data and was FTP'd from one machine to another the wrong
> way, that could have done it.
>
> No, it was there in the box all along.
> TIA,
> Ted
>
>