# Issue for q2a import

**URL:** <https://meta.discourse.org/t/issue-for-q2a-import/128529>\
**Category:** Migration\
**Created:** [September 14, 2019, 12:13am UTC](https://meta.discourse.org/t/issue-for-q2a-import/128529 "2019-09-14T00:13:58Z")\
**Posts on this page:** 1\
**Showing post:** 1

<div class="post-metadata">

**Author:** ![sat](https://avatars.discourse-cdn.com/v4/letter/s/22d042/32.png) [@sat](https://meta.discourse.org/u/sat)\
**Post date:** [September 14, 2019, 12:13am UTC](https://meta.discourse.org/t/issue-for-q2a-import/128529/1 "2019-09-14T00:13:58Z")

</div>

I’m importing question2answer site and followed below steps. Script is not able to connect to db. anyone please help me on this.

I took ref from [vBulletin thread](https://meta.discourse.org/t/importing-from-vbulletin-4/54881)

**Docker install Server**

Steps:

1. Installed discourse using [30 min guide](https://github.com/discourse/discourse/blob/master/docs/INSTALL-cloud.md) and it worked perfectly fine.
2. entered app using below commands

> cd /var/discourse  
> ./launcher enter app

1. Installed **Mariadb** as I was not able to install mysql:

> apt-get update && apt-get install libmariadb-dev mariadb-server-10.3

1. After finishing installing Mariadb check its status and started:

> sudo service mysql status  
> sudo service mysql start

1. Install dependencies

> echo “gem ‘mysql2’, require: false” \>\> /var/www/discourse/Gemfile  
> echo “gem ‘php\_serialize’, require: false” \>\> /var/www/discourse/Gemfile  
> cd /var/www/discourse  
> su discourse -c ‘bundle install --no-deployment --without test --without development --path vendor/bundle’

1. Imported database

mysql -uroot -p -e ‘CREATE DATABASE q2adb’  
mysql -uroot -p q2adb \< q2a-old-db.sql

1. exported below variables, I dont have any attachments so not exported that variable. also not set password for root user.

> export DB\_NAME=“q2adb”  
> export DB\_USER=“root”  
> export DB\_PW=“”  
> export TABLE\_PREFIX=“qa\_”  
> export TIMEZONE=“America/Los\_Angeles”
> 
> cd /var/www/discourse  
> su discourse -c ‘bundle exec ruby script/import\_scripts/question2answer.rb’

This is the error I’m getting now after running below command.

/var/www/discourse# su discourse -c ‘bundle exec ruby script/import\_scripts/question2answer.rb’  
root:@localhost wants q2adb  
Loading existing groups…  
Loading existing users…  
Loading existing categories…  
Loading existing posts…  
Loading existing topics…

Access denied for user ‘root’@‘localhost’  
Cannot connect in to database.

Hostname: localhost  
Username: root  
Password:  
database: q2adb

Edit the script or set these environment variables:

export DB\_HOST=“localhost”  
export DB\_NAME=“”  
export DB\_PW=‘password’  
export DB\_USER=“root”  
export TABLE\_PREFIX=“qa\_”

Exiting.

---

_[View the full topic](https://meta.discourse.org/t/issue-for-q2a-import/128529)._