How to transfer database from older website to newer one

[fazlionline]

Hi everyone

I have a database with some tables in a website.

Now our company decided to open a new website and permanently delete the old one.

Will anyone tell me how to transfer that database form older site to the newer one?

The data is too important and I do not want to lose it anyway.

[Andrea]

What do you mean by new site? A new server, or the exact same url/server, just a new template/look? At any rate, periodic back-ups of your database will enable you to restore it at any time anywhere.

[bishwadeep]

Hi fazlionline

If you are using mysql as a database then you can export your database using phpMyadmin. after you export the database you will get the sql queries of your database, save it somewhere and then import the sql script to the new database.

[fazlionline]

What do you mean by new site? A new server, or the exact same url/server, ...

I have to delete my website form the current server which and make a new website with the same name in another server.

Edited August 24, 2009 by fazlionline

[Wickham]

You should be able to download all the MySQL files from the current server using your ftp (it can download as well as upload) to a cd, or several cds.

 

Then upload it all to the new server. Make sure it works on the new server before deleting everything from the old server.

 

Keep the cds as a backup.

 

You will need usernames and passwords for both servers.

[BeeDev]

If you have MySQL server you don't really need to Export your data, you can just use the same database on the new website?

[fazlionline]

If you have MySQL server you don't really need to Export your data, you can just use the same database on the new website?

 

But I want to delete the older site.

Will anyone tell me the whole process how to shift my data from old to the new server/website?

[Andrea]

Use phpMyAdmin, import from the old one (that gives you a copy onto your computer) then export to the new one. After that, you may have to update the database access info to the new database name, username, and password, if they change.

 

I cannot tell you step-by-step, but I know practically nothing about this stuff, and I've done it before - it's easy. Just look around your phyMyAdmin, it usually comes with a help section, too.

[falkencreative]

Thelma has the idea correct, but just switched "import" and "export."

 

Here are the steps:

-- log in to PHPMyAdmin on your current host

-- select the database you want to save from the left column

-- in the right column, there should be a tab called "export". Click it.

-- once the export page loads, you shouldn't need to change any settings, just click "go".

-- PHPMyAdmin will create a text file that contains the necessary SQL commands to rebuild the database. Copy that text into a text file on your desktop.

 

-- log in to PHPMyAdmin on your new host

-- all the way at the bottom of the column named "Localhost", there should be a link to "Import". Click it.

-- on the next page, browse to your text file that contains your saved database, and click "go".

-- you have successfully transferred databases from one server to another.

[Andrea]

Thelma has the idea correct, but just switched "import" and "export."

Indeed!!!

[akurtula]

hi

 

this topic seems to have been answered, though i have started to you a program called SQLyog, which seem to make it very easy to handle databases, and the transferring seems to be very easy to carryout with this program - especially if you are new at these matters

[fazlionline]

falkencreative, thanks

i am Following the steps you told me, I going on?

But I got a problem now,

I have logged in to my CP, select PHPMyAdmin, after that, (there is a box, asking my database name), but the database was designed by a developer before me. How can I find the database name to download it?

Actually, I want to download all my tables in database(s)

Need help

[falkencreative]

I'm not sure what your PHPMyAdmin looks like... it should be pretty standard though. You will select the database name from the column on the left (here is what mine looks like as an example:)

 

 

I don't know which one it will be if you have more than one database set up... Hopefully the developer named it something that makes sense. If you can't figure it out, just download them all.

 

My instructions cover how to download all of the tables in the database, just continue to follow my instructions.

[fazlionline]

Oh!

this is localhost, but i have my database online now.

i want to download that, and upload it to my new server

[Andrea]

Localhost in relation to where you're signed in - which is the ONLINE database.

[falkencreative]

this is localhost, but i have my database online now.

i want to download that, and upload it to my new server

 

That was a screenshot of my PHPMyAdmin on my web hosting (online).

[falkencreative]

Thought I'd point out... I recently posted a screencast on how to export a local database using PHPMyAdmin. The same basic procedure would apply if you are trying to transfer a database between web hosts.

 

http://www.falkencreative.com/resources.php