|
Moving to another host
|
| Pippi |
Posted on 07-11-2012 15:47
|
Member
Posts: 65
Joined: 11/07/2010
|
I have backup of all the files and the DB.
When I upload all the files to the server I canno't connect with MySql, and I realise that I have to change the DB settings, so I do in config.php.
I still can not connect with MySql, because I have to create a table? (I don't know how)
I thought I could just upload all the files, then log in and upload the zipped sql file, but I don1 get the page up running.
Please help me, tell me what to do? |
| |
|
|
| PolarFox |
Posted on 07-11-2012 17:19
|
Admin
Posts: 1480
Joined: 26/08/2008
|
If you have the full backup, do the following:
unzip + upload all the files (eg php-fusion folder)
open your PMA + import your dump into it
change your config.php settings (if needed)
change file/folder-rights (images, uploads, attacmnets etc)
|
| |
|
|
| Pippi |
Posted on 07-11-2012 19:40
|
Member
Posts: 65
Joined: 11/07/2010
|
Thank you SO much, it worked!
Do you have any idea why the letters Æ, Ø, Å suddenly is gone?
http://www.brevdu... |
| |
|
|
| HaYaLeT |
Posted on 07-11-2012 21:53
|
Senior Member
Posts: 276
Joined: 31/10/2008
|
i think going to be okay in few days
|
| |
|
|
| Pippi |
Posted on 08-11-2012 07:32
|
Member
Posts: 65
Joined: 11/07/2010
|
Ok, thank you!  |
| |
|
|
| icb |
Posted on 30-11-2012 17:30
|
Member
Posts: 50
Joined: 01/11/2010
|
PolarFox wrote:
If you have the full backup, do the following:
unzip + upload all the files (eg php-fusion folder)
open your PMA + import your dump into it
change your config.php settings (if needed)
change file/folder-rights (images, uploads, attacmnets etc)
I kinda have the same problem. But the point is my other host makes me use different db name and username then it was before. So it seems I cant just load it in phpmyadmin so easily. it says:
"SQL query:
You DO NOT have access TO thatdatabase( brainwas_ ) !
MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'You do not have access to that database (brainwas_)!' at line 1 "
Any help how to actually load backup db into mysql ?
Help is appreciated. |
| |
|
|
| icb |
Posted on 30-11-2012 18:19
|
Member
Posts: 50
Joined: 01/11/2010
|
icb wrote:
PolarFox wrote:
If you have the full backup, do the following:
unzip + upload all the files (eg php-fusion folder)
open your PMA + import your dump into it
change your config.php settings (if needed)
change file/folder-rights (images, uploads, attacmnets etc)
I kinda have the same problem. But the point is my other host makes me use different db name and username then it was before. So it seems I cant just load it in phpmyadmin so easily. it says:
"SQL query:
You DO NOT have access TO thatdatabase( brainwas_ ) !
MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'You do not have access to that database (brainwas_)!' at line 1 "
Any help how to actually load backup db into mysql ?
Help is appreciated.
Actually I fixed it, included wrong dump. But now for some reason, pics doesn't load although all paths seem correct and files are there.
Any idea what could be the problem ? |
| |
|
|
| Gillette |
Posted on 01-12-2012 00:20
|
Admin
Posts: 291
Joined: 09/04/2012
|
File permissions are set correctly?
All directories / content uploaded? |
| |
|
|
| icb |
Posted on 01-12-2012 09:27
|
Member
Posts: 50
Joined: 01/11/2010
|
Gillette wrote:
File permissions are set correctly?
All directories / content uploaded?
All content is there, yes. File permissions were set up on the old host appropriately , and backup was made, so it should be ok too, since this is restore from that backup.
Only thing that have changed is domain name. |
| |
|
|
| PolarFox |
Posted on 01-12-2012 12:44
|
Admin
Posts: 1480
Joined: 26/08/2008
|
so it should be ok too please check them.
|
| |
|
|
| icb |
Posted on 01-12-2012 12:46
|
Member
Posts: 50
Joined: 01/11/2010
|
Found the problem. .htaccess in images folder had some restrictions, allowed only for former domain name.
Thanks for the help anyway  |
| |
|
|
| PolarFox |
Posted on 01-12-2012 12:55
|
Admin
Posts: 1480
Joined: 26/08/2008
|
wow something new, thanx for your solution also!
|
| |
|
