I have a site with a database and now I am trying to move that site to a different domain. I need to somehow save all the database files so I can reinstall the database on the domain. I am using phpmyadmin. Can anybody tell me the exact way to do this? Where to go in phpmyadmin and what to click on. Thanks really appreciate it
just download everything off of ur DB onto ur computer from your myphphadmin, then upload it again onto a different DB
go into phpmyadmin and click the database you want. on the right will be an export link, click this. make sure you save the data as well as the structure. you can choose an sql download or gzipped. up to you.
i would email your old host and ask them to backup the database and them send you a copy of it. you then go into your new phpmyAdmin, now here sometimes its tricky. The least problematical way I've found is to click the 'first-from-the-left' sql button in the left column, which should pop up a query window. then i open the old sql file in something like bbedit, copy and paste into this window. then click 'go'. the 'import' button seems to sometimes time out with big files.
oh, you'll need to find your config.php (or equivalent) file and change the database login details (server, username, password) for the new site. but you knew that already right