fazlionline Posted August 23, 2009 Report Share Posted August 23, 2009 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. Quote Link to comment Share on other sites More sharing options...
Andrea Posted August 23, 2009 Report Share Posted August 23, 2009 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. Quote Link to comment Share on other sites More sharing options...
bishwadeep Posted August 24, 2009 Report Share Posted August 24, 2009 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. Quote Link to comment Share on other sites More sharing options...
fazlionline Posted August 24, 2009 Author Report Share Posted August 24, 2009 (edited) 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 Quote Link to comment Share on other sites More sharing options...
Wickham Posted August 24, 2009 Report Share Posted August 24, 2009 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. Quote Link to comment Share on other sites More sharing options...
BeeDev Posted August 27, 2009 Report Share Posted August 27, 2009 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? Quote Link to comment Share on other sites More sharing options...
fazlionline Posted August 29, 2009 Author Report Share Posted August 29, 2009 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? Quote Link to comment Share on other sites More sharing options...
Andrea Posted August 29, 2009 Report Share Posted August 29, 2009 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. Quote Link to comment Share on other sites More sharing options...
falkencreative Posted August 29, 2009 Report Share Posted August 29, 2009 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. Quote Link to comment Share on other sites More sharing options...
Andrea Posted August 29, 2009 Report Share Posted August 29, 2009 Thelma has the idea correct, but just switched "import" and "export."Indeed!!! Quote Link to comment Share on other sites More sharing options...
akurtula Posted September 4, 2009 Report Share Posted September 4, 2009 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 Quote Link to comment Share on other sites More sharing options...
fazlionline Posted September 26, 2009 Author Report Share Posted September 26, 2009 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 Quote Link to comment Share on other sites More sharing options...
falkencreative Posted September 26, 2009 Report Share Posted September 26, 2009 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. Quote Link to comment Share on other sites More sharing options...
fazlionline Posted September 27, 2009 Author Report Share Posted September 27, 2009 Oh! this is localhost, but i have my database online now. i want to download that, and upload it to my new server Quote Link to comment Share on other sites More sharing options...
Andrea Posted September 27, 2009 Report Share Posted September 27, 2009 Localhost in relation to where you're signed in - which is the ONLINE database. Quote Link to comment Share on other sites More sharing options...
falkencreative Posted September 27, 2009 Report Share Posted September 27, 2009 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). Quote Link to comment Share on other sites More sharing options...
falkencreative Posted November 15, 2009 Report Share Posted November 15, 2009 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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.