solved Help! Cannot recover old phpmyadmin sql dump

July 28, 2016, 07:48:07 AM by w5det
Several years ago I inherited administering the website for our ham radio club because I am the "one-eyed man."  The site included a mostly unused SMF.  At the time, the most recent post was over a year old.  There was the added problem that the local hosting service they had been using was closing its doors.  Time to move.

An sql dump of the SMF database was performed and saved but wasn't restored at the time due to lack of interest.

Recently, I was told some technical information we need had been posted to the forum "for safekeeping."  Time to restore the database.

Except immediately this error occurs:
Query:
CREATE DATABASE `information_schema` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci

Error occured at:2016-07-28 05:13:27
Line no.:22
Error Code: 1044 - Access denied for user 'root'@'localhost' to database 'information_schema'

Is there a way to get around this error to restore the old system?   I cannot find the old root password.
5 comments | Write Comment

moved MOVED: When i can use Links or Signature on my post?

July 26, 2016, 11:08:09 AM by Irisado
This topic has been moved to Site Comments, Issues and Concerns.

http://www.simplemachines.org/community/index.php?topic=547581.0
0 comments

xx How add users? where documented?

July 19, 2016, 09:17:04 AM by hbaya
How do I add users?   Manually (my preference?),  by invite (how do I do this).   Where is this documented.    Also, why could I not find documentation on this when searching for it?
2 comments | Write Comment

xx New, intermittent problem

July 07, 2016, 05:14:15 AM by GuernseyPete

I'm on the current version of 1.1.21 and have beeen using SMF for years with few issues but suddenly I've started get the following error message - not always but mostly. It usually happens when I've entered a post - it seems to hang for a while then gives this error, although the post or other action does get completed. I've checked with my hosting provider and there are no database or connection issues (I share the server with a number of othe SQL databases that continue to work fine). Can anyone help please?

Database Error: The MySQL server is running with the --read-only option so it cannot execute this statement
File: /home/content/04/7091804/html/smf_1-1-11_install/Sources/Subs.php
Line: 2560Database Error: The MySQL server is running with the --read-only option so it cannot execute this statement
File: /home/content/04/7091804/html/smf_1-1-11_install/Sources/Load.php
Line: 2020
19 comments | Write Comment

xx Update mentioned in database crash

June 28, 2016, 05:24:51 PM by tdennis
I just had a database crash on my SMF 1.1 board, did a repair and all is well. My question is in regards to an error message that one of my Moderators received (shown below)

Quote
Database Error
Table './americ82_smf/smf_log_online' is marked as crashed and should be repaired
File: /home/americ82/public_html/forum/Sources/Subs.php
Line: 2613

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.1.21, while your database is at version 1.1.4. The above error might possibly go away if you execute the latest version of upgrade.php.

To the best of my knowledge I have loaded all upgrades available for SMF 1.1 but when I review my detailed version information it shows that "Current Template" is 1.1 and a 1.1.21 is available (see below).
Quote
Detailed Version Check
This shows you the versions of your installation's files versus those of the latest version. If any of these files are out of date, you should download and upgrade to the latest version at www.simplemachines.org.
SMF File   Your Version   Current Version
SMF Package   SMF 1.1.21   SMF 1.1.21
Sources                  1.1.20   1.1.20
Default Templates   1.1.21   1.1.21
Language Files        1.1.21   1.1.21
Current Templates  1.1        1.1.21

I thought the reason the current Template was as it is shown had to do with me having a custom template.

Is this a problem that I should attempt to fix?
Thanks
Dennis
1 comment | Write Comment