Let’s say you want to move all website files from database A to database B, here’s how to do that:
Step 1: Export Database A
- Log into phpMyAdmin for website A via your web-host dashboard
- Once there, click on Export at the top
- On the next page, select the following:
- Export Method: Quick
- Format: SQL
- Click Export
- This will download an sql file to your downloads folder
Step 2: Import Database A onto Database B
- Log into phpMyAdmin for website B via your web-host dashboard
- Once there, click on Import at the top
- In the File to import section, click Choose File
- Select the sql file from website A
- Scroll to the bottom, click Import
- This may take a moment but when complete, website A will be imported onto website B
Step 3: Run Backups
- Once this process is complete, run an account backup
- When the backup is complete, download and store the backup files in a timestamped folder
- Wait until disk usage updates on database B, which could take a few days or more depending on the size of the database
- After disk usage on database B reflects the same figure as that on database A, delete database A
- When that’s done, run another backup to bring everything to current
