Database mySql error

Permalink
Hi - I'm getting a database error on importing a database to overwrite a new C5 install default database . The install was done by Softalucious.

Database: `redbackd_xxx`
--
CREATE DATABASE IF NOT EXISTS `redbackd_xxx` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
MySQL said: Documentation
#1044 - Access denied for user 'thegrump'@'localhost' to database 'redbackd_xxx'


Any ideas what might be going on the database is there so not sure why its asking for it?

chassa2556
View Replies:
ronyDdeveloper replied on at Permalink Reply
ronyDdeveloper
Well you have exportd the database from localhost. It has a user called "root" or something else. But in live server the username is something different. So try to open the SQL file which you have exported. Then delete the first few lines which is the definition to create database along with database users. You need to delete up to the first occurrence of the below line.
"CREATE TABLE <TABLE_NAME> ..... ".

Rony
chassa2556 replied on at Permalink Reply
chassa2556
Rony - that worked - thank you so much however I now have any error if you scroll to the bottom of the page

http://thegrumpybadger.co.uk/

mysqlt error: [1054: Unknown column 'isScheduled' in 'where clause'] in EXECUTE("SELECT jID FROM Jobs WHERE isScheduled = 1 ORDER BY jDateLastRun")


Any ideas on this as well??
chassa2556 replied on at Permalink Reply
chassa2556
Guys thanks for your help have resolved this by updating the install using this link

http://www.yourwebsite.com/index.php/tools/required/upgrade?source=...

Bingo message gone...
hansmonasso replied on at Permalink Reply
hansmonasso
That worked for me too! Thanks a lot!
bobaudio replied on at Permalink Reply
bobaudio
Hi,
Can you tell me what you did? That link is no longer valid and I am not a back-end savvy person. I am trying to get the web host to resolve it but if they cannot I will be trying myself. I am with Powweb and had to have them fix something so I could get latest update installed and errors were there after update. Site is generic w no add ons or customization- just a slightly modified stock template. Thanks-
B
bobaudio replied on at Permalink Reply
bobaudio
Hi,
Can you tell me what you did? That link is no longer valid and I am not a back-end savvy person. I am trying to get the web host to resolve it but if they cannot I will be trying myself. I am with Powweb and had to have them fix something so I could get latest update installed and errors were there after update. Site is generic w no add ons or customization- just a slightly modified stock template. Thanks-
B
bobaudio replied on at Permalink Reply
bobaudio
Hi,
Can you tell me what you did? That link is no longer valid and I am not a back-end savvy person. I am trying to get the web host to resolve it but if they cannot I will be trying myself. I am with Powweb and had to have them fix something so I could get latest update installed and errors were there after update. Site is generic w no add ons or customization- just a slightly modified stock template. Thanks-
B
JohntheFish replied on at Permalink Reply
JohntheFish
Most live server environments set the SQL permissions such that you cant do database level SQL, you can only do table level SQL.

You may need to use your host control panel to create the new database.

You can then use a SQL file to create all the tables and import the site in to the database.
bobaudio replied on at Permalink Reply
bobaudio
FIXED my issue might help here:

JohnTheFish in another unrelated thread suggested simple direct database/C5 upgrade:

"http://yoursitehere.com/index.php/tools/required/upgrade"

This showed I could upgrade from earlier ver to 5.6.2.1 for some reason- ran it- errors gone!!

thread I found fix:
http://www.concrete5.org/community/forums/installation/table-jobset...