My host says that, at least, one of my online message board tables is corrupted and beyond fixing.
So, he recommends that I restore the database, from a trusted backup.
Problem is that, I created the online database via HeidiSQL, years ago, and now I forget how it's done.
So, please point me in the right direction!
phpBB : Critical Error
Error creating new session
SQL Error : 1062 Duplicate entry '-1' for key 2
INSERT INTO phpbb2_sessions (session_id, session_user_id, session_start, session_time, session_ip, session_page, session_logged_in, session_admin) VALUES ('f03c15bea9a6767fef03ba9481a23a06', -1, 1275448500, 1275448500, 'd1c34890', 0, 0, 0)
Line : 187
File : sessions.php
I have a large database (29 Mb mysql dump file) that I need to restore.
HeidiSQL loads the file into memory (after warning that it will use a lot of memory).
F9 does nothing other than generating the following message - "/* 0 rows affected, 0 rows found. Duration for 0 queries: 0.000 sec. */".
Please login to leave a reply, or register at first.