Cheers Smarty
I am not sure where the cache is. The only one I can search has nothing to remove?
Server: localhost Database: forums Table: search_cache
Structure Browse SQL Search Insert Export Operations Empty Drop
Field Type Collation Attributes Null Default Extra Action
id int(10) UNSIGNED No 0
ident varchar(200) latin1_swedish_ci No
search_data text latin1_swedish_ci Yes NULL
Check All / Uncheck All With selected:
--------------------------------------------------------------------------------
Print view Relation view Propose table structure
Add field(s) At End of Table At Beginning of Table After id ident search_data
--------------------------------------------------------------------------------
Indexes:
Keyname Type Cardinality Action Field
PRIMARY PRIMARY 1 id
search_cache_ident_idx INDEX None ident 8
Create an index on columns
Space usage:
Type Usage
Data 2,464 Bytes
Index 3,072 Bytes
Overhead 2,304 Bytes
Effective 3,232 Bytes
Total 5,536 Bytes
Optimize table
Row Statistics:
Statements Value
Format dynamic
Collation latin1_swedish_ci
Rows 1
Row length ø 160
Row size ø 5,536 Bytes
Creation Dec 11, 2007 at 09:36 AM
Last update Mar 30, 2008 at 09:40 PM
Last check Dec 11, 2007 at 09:36 AM
--------------------------------------------------------------------------------
Run SQL query/queries on database forums Fields:
SELECT * FROM `search_cache` WHERE 1 id ident search_data
Show this query here again
Or Location of the text file:
Location of the text file:
(Max: 2,048MB)
Compression:
Autodetect None "gzipped"
Character set of the file: armscii8 ascii big5 binary cp1250 cp1251 cp1256 cp1257 cp850 cp852 cp866 dec8 euckr gb2312 gbk geostd8 greek hebrew hp8 keybcs2 koi8r koi8u latin1 latin2 latin5 latin7 macce macroman sjis swe7 tis620 ucs2 ujis utf8
Bookmark this SQL query:
Bookmark options:
Label:
Let every user access this bookmark
Insert data from a text file into the table
Server: localhost Database: forums Table: search_cache
Structure Browse SQL Search Insert Export Operations Empty Drop
Showing rows 0 - 0 (1 total, Query took 0.0135 sec)
SQL query:
SELECT *
FROM `search_cache`
LIMIT 0 , 30
[Edit] [Explain SQL] [Create PHP Code] [Refresh]
row(s) starting from record #
in horizontal horizontal (rotated headers) vertical mode and repeat headers after cells
id ident search_data
1470408961 tbaol a:5:{s:14:"search_results";s:2:"87";s:8:"num_hits"...
Check All / Uncheck All With selected:
row(s) starting from record #
in horizontal horizontal (rotated headers) vertical mode and repeat headers after cells
--------------------------------------------------------------------------------
Insert new row Print view Print view (with full texts) Export
Bookmark this SQL query
Label:
Let every user access this bookmark
Utrinque Paratus