开发者

Can I empty accesslog table?

Can I empty the table 'accesslog' in Drupal ? Does it contain only logs ?

It is giving me issues in importing a database into a new mysql server:

Error at the line 66: INSERT INTO accesslog (aid, sid, title,

path, url, hostname, uid,

timer, timestamp) VALUES(5686,

'bgp2qr643sg0aoreq7p524ii96', 'Modules', 'admin/build/modules',

'http://localhost/drupal/node/26/edit?destination=admin%2Fcontent%2Fnode',

'127.0.0.1', 1, 2724, 1273997919);

Actually the iss开发者_开发百科ue is not there.. I've deleted that table just to see if I was able to import the database and I get a similar error for the next table to import:

Error at the line 60: INSERT INTO actions (aid, type, callback, parameters, description)

VALUES('comment_unpublish_action', 'comment', 'comment_unpublish_action', '', 'Unpublish comment');

Query: —

INSERT INTO actions (aid, type, callback, parameters, description) VALUES('comment_unpublish_action', 'comment', 'comment_unpublish_action', '', 'Unpublish comment');

MySQL: Duplicate entry 'comment_unpublish_action' for key 1

thanks


Per your original question: yes, accesslog can be safely emptied, as can watchdog and any tables beginning with "cache".

As for the import errors, make sure that the destination database is empty before attempting to import a complete dump. If you don't want to drop all the tables from the destination database each time, create your complete dump with "DROP TABLE IF EXISTS" statements. In phpMyAdmin, for example, you can do this with the "Add DROP TABLE / VIEW / PROCEDURE / FUNCTION" option in the Export tab.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜