Anton_FA Posted April 21, 2003 Share Posted April 21, 2003 Greetings I am moving my store from on server to another and would appreciate it if someone could tell me how I tranfer the mysql data. thanks Link to comment Share on other sites More sharing options...
budgetsubs Posted April 21, 2003 Share Posted April 21, 2003 Assuming you have access to phpmyadmin on each server. Select the database on your old server and select the export tab on the top. When the export box comes up, select all tables (data and structure). Then, check the Add 'drop table' and save as file check boxes. This will not damage your database in any way. It will export (dump) your database into a file which should be downloaded automatically to your computer. This file will be named xxx.sql where xxx is your database name. Then go to your new server. Create a new database in phpmyadmin. Select the SQL tab from the top menu. Click on the browse button and select the new dump file you created. Click the GO button and the old database will automagically be dumped into your new database. Hope this helps. Backup any and all data that is important before doing this. God Bless, Russell "On the plains of hesitation lie the blackened bones of countless millions who at the dawn of victory lay down to rest, and in resting died." -A. Stevenson Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.