Moved domain, can't install database

[burnttoast22]

Hi Guys,

I've been moving a website from one domain to another for a client and everything has gone swimmingly until it comes to uploading the database to the new server.

I have followed the guide for moving domains.  but when I try to import the database.sql file in phpmyadmin it gives me an error and says no database is selected.

I can't remember whether I got the sql file from a myphpadmin backup or the backup facility in website baker itself, when I view the file in notepad it looks correct and is 119kb in size.

Any ideas?

many thanks

Alex

Picture of the error

[pcwacht]

last line of the error,
#1046 - No Databsase selected

Select a database, then import, don't import from phpmyadmin-home

John
 

[burnttoast22]

OK I have selected the database (doh simply clicking on its name on the left hand side) but when I try to import now I get an error saying that addons table already exists



EDIT: OK fixed that by deleting all the tables.  import now works but all the picture links are broken.

[pcwacht]

Does the new site works?

Then it might be easier (in this case) to copy paste from old to new

Otherwise, you should
1 - make a backup of the database as it is now
2 - empty the database (do NOT drop!!!! the database)
3 - import SQL

Again, when it is only a few pages, say less then 20 might be better to copy paste.

John

[burnttoast22]

I give up.

I'm gonna delete everything and start again from scratch.  Will report back in a bit.

[burnttoast22]

Right,

The site is now working and database imported but I cannot access the backend   the username and password I xreated for Server A for WB admin access does not work for Server B WB admin access or more worryingly the original user and password I set up for server B fsils to work now either.

All of the pictures just show broken link placeholders, but I've verified it's looking in the right place and that the files are there.

I'm guessing the picture thing at least is a file permissions issue?

I tried to see whether I could set the global permissions in phpmyadmin but couldn't find anything other than the option to set everything to 777 when installing WB.

rather stumped  

[pcwacht]

The site is now working and database imported

Ok so far.

but I cannot access the backend

You imported the database from the old server, in the database is allso login and pass for admin. That's the one you should use.
Try clearing cache from browser and retry. Or take another browser (firefox/chrome)

All of the pictures just show broken link placeholders

These where created on the old server, so there is a url issue, http://www.oldserver.com/media/picture.jpg instead of http://www.newserver.com/media/picture.jpg
Just re-edit those

I'm guessing the picture thing at least is a file permissions issue?

Nope, see above

I tried to see whether I could set the global permissions in phpmyadmin but couldn't find anything other than the option to set everything to 777 when installing WB

Not needed!

Hope this helps?

John

[burnttoast22]

Yes we're getting there 

The address for the pictures shows up as the new server address.   as for the pics The page loading bar gets to about four fifths and then stops for 30 odd seconds before declaring the pics broken links.

hence me hinking it was a permission issue.

Only problem is I've now been locked out of the WB backend completely because I've apparently tried to log in too many times   

Will this reset anytime soon or will I have to reinstall the whole again?

the weird thing is I had a look at the sql file in notepad and pulled the username and password out manually and it still wouldn't let me login.

there was what looked like an IP address associated with each username, is it possible the login has been locked down to a specifec ip? and if so is it possible to edit it out of the sql file?



 

[pcwacht]

login reset -> Try clearing cache from browser and retry. Or take another browser (firefox/chrome) or try from different computer, there is no hard lockout, only through sessions

The password in the sql file is a hash, the password is encrypted

What you can do:
login to your database using phpMyAdmin and open the DB table: user
Search for the DB fields remember_key and last_reset and remove the entries in it (simply set blank).
Then replace the existing password with: 098f6bcd4621d373cad e4e832627b4f6

The string above is the md5 encrypted hash for the plain password: "test". WB does store password in MD5 encrypted format.


Then clear the browser cache and sessions and try to login with username (check DB field username) and the new password test.

After that CHANGE PASSWORD!!!!

Other option:

Inside your database, go into the table users and edit the line with the user_id 1.
This are your admin user settings.
Change the value of the field with the name password and select as Function MD5.
The value should be a cryptic character string. Here type in your new passwort in plain text.
Pleas ensure, that your password is not to short.
Save the changes and take a look at your password. Now it should be a cryptic character string, also.

Now you can login with your new password into your WebsiteBaker Installation.

ps, is on our helppages : http://www.websitebaker2.org/en/help/frequently-asked-questions.php#acc
look at the third question.

Good luck,
John

[burnttoast22]

That sounds brilliant!  Thanks John I will give it a try tomorrow and report back.

regards

Alex

[burnttoast22]

Yay that did the trick, everything is up and running, John I can't thank you enough for your help with this!

[pcwacht]

lol


Glad it worked for you.