Login
[x]
Log in using an account from:
Fedora Account System
Red Hat Associate
Red Hat Customer
Or login using a Red Hat Bugzilla account
Forgot Password
Login:
Hide Forgot
Create an Account
Red Hat Bugzilla – Attachment 293546 Details for
Bug 420611
3.41 Update database code in Bugzilla 3.0 to work with data from Red Hat 2.18 Bugzilla
[?]
New
Simple Search
Advanced Search
My Links
Browse
Requests
Reports
Current State
Search
Tabular reports
Graphical reports
Duplicates
Other Reports
User Changes
Plotly Reports
Bug Status
Bug Severity
Non-Defaults
|
Product Dashboard
Help
Page Help!
Bug Writing Guidelines
What's new
Browser Support Policy
5.0.4.rh83 Release notes
FAQ
Guides index
User guide
Web Services
Contact
Legal
This site requires JavaScript to be enabled to function correctly, please enable it.
SQL script moving attachment data from attachments table to attach_data table
move_attach_data.sql (text/plain), 690 bytes, created by
Tony Fu
on 2008-01-31 05:47:26 UTC
(
hide
)
Description:
SQL script moving attachment data from attachments table to attach_data table
Filename:
MIME Type:
Creator:
Tony Fu
Created:
2008-01-31 05:47:26 UTC
Size:
690 bytes
patch
obsolete
>--- copy attachments.thedata to attach_data.thedata > >--- create attach_data table >DROP TABLE IF EXISTS `attach_data`; >CREATE TABLE `attach_data` ( > `id` mediumint(9) NOT NULL, > `thedata` longblob NOT NULL, > PRIMARY KEY (`id`) >) ENGINE=InnoDB DEFAULT CHARSET=utf8 MAX_ROWS=100000 AVG_ROW_LENGTH=1000000; > >--- copy attachments.attach_id and attachments.thedata data into /tmp/attach_data.dat file >SELECT attach_id, thedata FROM attachments INTO OUTFILE '/tmp/attach_data.dat'; > >--- load data from data file into attach_data table >LOAD DATA INFILE '/tmp/attach_data.dat' INTO TABLE attach_data; > >--- drop thedata column from attachments table >ALTER TABLE attachments DROP COLUMN thedata; >
<b>You cannot view the attachment while viewing its details because your browser does not support IFRAMEs. <a href="attachment.cgi?id=293546">View the attachment on a separate page</a>.</b>
View Attachment As Raw
Actions:
View
Attachments on
bug 420611
:
284681
|
285731
|
285741
|
291816
|
291817
|
291818
|
292118
|
292119
|
292335
|
292336
|
292464
|
292465
|
293354
|
293546
|
293608