Problem with migrating/moving

[nordhagen]

Hello!

 

For starters, I am very new with oscommerce and any SQL service. So if you care to answer the following questions, I beg you to do it in a very detailed matter. If you write me a text including some codes, I am surely not going to understand it.

 

I have got an oscommerce sql-database from a friend. And the question is that follows:

 

How can I move the sql-database(server?) from one webhotel to another webhotel? And with that I mean the very simplest way of moving, as I stated I don't know much about this. But still I need to get it moved.

 

If you are kind enough to help me, I thank you in advance. I've been trying all weekend with not a file transfered yet.

[sharma.atul85]

Hello!

 

For starters, I am very new with oscommerce and any SQL service. So if you care to answer the following questions, I beg you to do it in a very detailed matter. If you write me a text including some codes, I am surely not going to understand it.

 

I have got an oscommerce sql-database from a friend. And the question is that follows:

 

How can I move the sql-database(server?) from one webhotel to another webhotel? And with that I mean the very simplest way of moving, as I stated I don't know much about this. But still I need to get it moved.

 

If you are kind enough to help me, I thank you in advance. I've been trying all weekend with not a file transfered yet.

 

 

 

Its very easy to do ..

just follow the steps...

1) make sure your database file has extension .sql(like database.sql).

2)then open phpmyadmin . To open this type http://localhost/phpmyadmin/ (if phpmyadmin is installed)

3) There will be an option to "create new database". under this enter the name for your database and click "create".

4)Once your database has been installed click "import" at the top.

5) Here you'll have option to upload file by entering the location of file or click browse and select file and then click "go" at the end .

thats it!!!

[nordhagen]

Its very easy to do ..

just follow the steps...

1) make sure your database file has extension .sql(like database.sql).

2)then open phpmyadmin . To open this type http://localhost/phpmyadmin/ (if phpmyadmin is installed)

3) There will be an option to "create new database". under this enter the name for your database and click "create".

4)Once your database has been installed click "import" at the top.

5) Here you'll have option to upload file by entering the location of file or click browse and select file and then click "go" at the end .

thats it!!!

 

 

Thanks for your reply. However, I do not understand how I can "get" the database file (like you said database.sql). I can not find a solution to how I am to proceed to "set it up" for export (or something like that), from the webhotel I am going to move from. Will I be able to do this also in myphpadmin? Please help :rolleyes:

[nordhagen]

To add even more info I am sitting remotely from both servers. Don't know if that has anything to do with it though :)

[nordhagen]

I have now managed to get the .sql-file you mentioned from the database. But when I now try to import to the newly created database I get this message. (I got it from a backup generated from the 'previous' webhotel, won't this work perhaps?)

 

Here's atleast my error message from that try, am I getting close(or like very very far off? :blink: ):

 

 

"

SQL query:

 

--

-- Create schema 'nordhagen'

--

CREATE DATABASE IF NOT EXISTS nordhagen;

 

 

 

MySQL said:

 

#1044 - Access denied for user 'morten'@'localhost' to database 'nordhagen'

 

"

 

Can't understand why I am denied as I have just created the user(me) myself.

[Guest]

remove this one

 

CREATE DATABASE IF NOT EXISTS nordhagen;

 

from the sql dump then save. then import then you're done