I am having a drupal site developed and ready on my local server which is a standard drupal Installation. Back on server I have a multisite setup with 3 sites all using same database with different prefix for each site. Now I want to move this site that is on local server to replace one of the site in the multi-site online.
I am confused with the following things:
- How do I export the db from a single instant and import it on server? I only have phpmyadmin access. And all sites in multisite use same db and is prefixed.
- How do I export the db from localhost with the required prefix.
- Does the multisite db use all the tables I have in single instant?
- Will importing the local tables to multi-site db overwrite the tables thats already there or will I have to delete the tables online first and then import?
What are the best steps to follow for my problem, I saw many conflicting info online and in this community. As I am doing this on a live site, dont wan't to break it.