Unable to connect to database. A database error occurred while processing this request.
Things I have done -
exported and imported the database ( phpmyadmin )
Created database user
I have set all the permissions for folders to 777 ( folders mentioned in the moving a site )
Cleared all the cache files - then copied to Archive ( zip ) all files
Uploaded Archive and decompressed.
Changed config/site.php to show new changes
(top 4 defines)
Site doesn't work ( soccerelectronics.com)
Unable to connect to database
I think that migration from local to server should be way simpler - Is there an Add-on to collect everything from local and then do clean install on server? This is very frustrating. I have done this before by doing Concrete install first then going through and re-adding all packages and importing ( drop tables ) and I have had it work before but that is a lot of work where copying the exact files should work.
In cPanel for example, there is a section in the database page 'Add User To Database'.
You need to make sure that the user has permission to actually access the new database.
The steps are:
- Create new database, take note of name, import dump
- Create new database user, take note of username and password
- Add the new user to the new database, giving them permissions to do everything
- Upload your files (best way is a zip of everything, and uncompress on the server)
- Edit /config/site.php with the new database name, username and pass
Migrations should feel pretty quick/short to be honest (you couldn't really do anything more automated), but I appreciate they are frustrating when they don't work!
What worked for me was to use a concrete database backup file instead,
Try this, log into your mamp concrete site and create a database backup and when it has completed, click the download button,
This will place a copy of the backup on your hard drive,
Go to your live server and drop all tables in your current database (make a backup first) and then import the database file from your hard drive..
It worked for me, maybe it will for you,
Is all now working as expected.
Also - sorry about the multiple posting of this problem - The forum ajax post seems to hang on my Mac and I thought it wasn't working.
thanks for those who made suggestions. very much appreciated.