tranferring database

Use your host’s database management tools (probably PHPMyAdmin) to export and import the database.

But my question now is: If i just simply export and import it to the new server will my website work or i have to change some settings in wordpress dashboard?

Use https://www.ads-software.com/extend/plugins/wp-migrate-db

The site URL settings.

See https://codex.www.ads-software.com/Changing_The_Site_URL

Just to clarify. My page sits on tekstine.no domain and server which is the way it should be. Problem is that it uses the database from server that lucidguitars.com sits on. So i dont wanna transfer the page itself. I just wannt it to use database from the server it sits on.
So logically i dont have to do anything with links right?

That’s right.

So you mean your tekstine.no is using a remote database that on lucidguitars.com? If yes, then you just need to transfer the database from tekstine.no to lucidguitars.com and change the database connection string in wp-config.php. No links need to be changed.

From your description, that’s what seems to be going on.

Just try it and see if it works.

codingpet.com yes. That is exactly what is happening. Now i saw that in my phpadmin i have option to export and import database so it shouldnt be a problem. But can somebody explain me how to change database connection string i wp-config.php file? Dont wanna mess it up and waste all those hours i spent building the page :/

What you need to change are:
1. Database Name
2. Database Username
3. Database Password
4. Database Host

Check https://codex.www.ads-software.com/Editing_wp-config.php Configure Database Settings section. You’ll get a clear idea from there.