Welcome to the Question2Answer Q&A. There's also a demo if you just want to try it out.

is it possible to create a new q2a site and copy my db from the previous one?

+3 votes
asked Jun 12, 2015 in Q2A Core by univ211b
will I have the same users and questions as the old site?
Q2A version: 1.7

1 Answer

+3 votes
answered Mar 1, 2017 by Yogendra Basnet
Yes this is possible. Log in to the control panel and download your DB using backup option.
Now upload it in using Restore option.
commented Mar 24, 2017 by arend.danielek
Could you  be a bit more specific? You say log into the control panel. Do you mean the admin tab? If what sub-tab is it under?
commented Mar 24, 2017 by pupi1985
@arend.danielek He means you need to query your database directly. This is not something you can do from Q2A itself. You need to access your MySQL instance directly, usually done by means of PHPMyAdmin which most hosting companies provide in some kind of control panel.
commented Mar 24, 2017 by ProThoughts
@arend.danielek, Which hosting service you are using? do you have cPanel? or site is hosted on dedicated server?
commented Mar 27, 2017 by arend.danielek
@pupi1985 Yes, I realized this shortly after forgetting I asked this question. I ended up manually dumping and importing th database.

@ProThoughts We are hosting on aws, on a dedicated VM. I figured out what I was missing earlier, not sure what cPanel is but not sure I need it at this point.
commented Mar 28, 2017 by ProThoughts
@arend.danielek, good to know it is working. I asked above question so that I can guide you. I also use Amazon AWS servers, You export db (using mysqldump command) and then import db should work.

Most of the shared hosting provider use cPanel, it is easy user interface. You can click and export db from control panel.