Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Not Solved No Remote MYSQL Access
#7
Not Solved
(2012-07-06, 06:25 AM)crazy4cs Wrote: No. Sad

The db you will export would be in sql format and so you will need to upload it again from your new webhost into a pre-created new database through phpmyadmin.

When I installed MyBB it had me make a DB, that db is [username]_MyBB should I upload the file I download into that DB? The raw SQL file, or do I do something else to it to get it to the proper state?

(2012-07-06, 06:29 AM)PhoenixCraftGaming Wrote:
(2012-07-06, 06:25 AM)crazy4cs Wrote: No. Sad

The db you will export would be in sql format and so you will need to upload it again from your new webhost into a pre-created new database through phpmyadmin.

When I installed MyBB it had me make a DB, that db is [username]_MyBB should I upload the file I download into that DB? The raw SQL file, or do I do something else to it to get it to the proper state?

Nevermind, I figured it out. But I'm getting this error, and I can't get most of my stuff back, I can only run like 4 operations.

Error:
MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1054 - Unknown column 'group_single_user' in 'where clause'
Query:
SELECT COUNT(*) as count FROM phpbb_groups WHERE group_id > 2 AND group_single_user != '1'
[Image: eJwryMhPzcusSC5KTCvRSytKTM9LLdEDYi4jU1Mz...8jPw~~.png]


Messages In This Thread
No Remote MYSQL Access - by PhoenixCraftGaming - 2012-07-06, 05:51 AM
RE: No Remote MYSQL Access - by pavemen - 2012-07-06, 05:53 AM
RE: No Remote MYSQL Access - by crazy4cs - 2012-07-06, 06:21 AM
RE: No Remote MYSQL Access - by crazy4cs - 2012-07-06, 06:25 AM
RE: No Remote MYSQL Access - by PhoenixCraftGaming - 2012-07-06, 06:29 AM
RE: No Remote MYSQL Access - by pavemen - 2012-07-06, 02:07 PM
RE: No Remote MYSQL Access - by Josh H. - 2012-07-07, 01:21 AM
RE: No Remote MYSQL Access - by Ariana - 2012-07-07, 11:19 PM
RE: No Remote MYSQL Access - by Ariana - 2012-07-07, 11:33 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)