i have a website on www.domain1.com and want to copy the site to www.domain2.com and onto a new server how do i copy the database ? thanks
i will explain it for you using phpmyadmin firstly : open domain1.com database http://i1241.photobucket.com/albums/gg510/NajeebRajabBasha/1_zps23bdc0e8.png secondly : click on export http://i1241.photobucket.com/albums/gg510/NajeebRajabBasha/2_zps61038964.png thirdly : scroll down to the end of the page and click on go : http://i1241.photobucket.com/albums/gg510/NajeebRajabBasha/3_zps8a2482c7.png fourthly : copy all SQL queries that appear to you http://i1241.photobucket.com/albums/gg510/NajeebRajabBasha/4_zps06b2d23f.png fifthly : create a new file , name it with any name , but the extension should be sql , it's important !! http://i1241.photobucket.com/albums/gg510/NajeebRajabBasha/5_zps75d99356.png sixthly : open the file using any text editor , i will open it using Notepad++ http://i1241.photobucket.com/albums/gg510/NajeebRajabBasha/6_zps5c7e83b4.png seventhly : paste what you've just copied http://i1241.photobucket.com/albums/gg510/NajeebRajabBasha/7_zps991a2384.png eighthly : create a new database , then open it http://i1241.photobucket.com/albums/gg510/NajeebRajabBasha/8_zps2c8b1a9c.png ninthly : click on import http://i1241.photobucket.com/albums/gg510/NajeebRajabBasha/9_zpsc9a338a5.png tenthly : choose the sql file that you've just created http://i1241.photobucket.com/albums/gg510/NajeebRajabBasha/10_zpse82244e5.png http://i1241.photobucket.com/albums/gg510/NajeebRajabBasha/11_zps6b5c9ffb.png eleventhly : scroll down and click on go http://i1241.photobucket.com/albums/gg510/NajeebRajabBasha/12_zps7df4e6a3.png Tada !!!!!
hello horseygirl, copy the dump file from one sever to another eg:-shell> mysqldump --databases db1 > dump.sql