How do I import a database? Also how to preview site before NS is pointed?

cbiweb

I've been trying the past half hour to import a database. I created one in my dashboard, and want to import my db from WF (after exporting from there and uploading to the OS server). I've tried the following commands vis SSH (italics in place of real info for this post):

mysql -p -u [mydbuser] [mydb] < [mydb].sql
and got "no such file or directory".
Then I tried this:
mysql -p -u [mydbuser] [mydb] < /path/to/server/ [dbfilename.sql]
and got "Usage: mysql [OPTIONS] [database]", with a log list of default options.

I tried a couple other commands as well, but no luck.

What am I missing?

sean

Your command seems OK to me, feel free to email support with the specific details if you're still have trouble with it.

cbiweb

sean Thanks. I was able to import it in Adminer, and now I just have to get the NS done so I can see if everything works, lol. Speaking of which - is there a way to preview my site before it's changed over to the new NS's?

sean

cbiweb Speaking of which - is there a way to preview my site before it's changed over to the new NS's?

You can either:

Test your site using your free user.opalstacked.com subdomain (or sub-subdomains of that). If you do this and need SSL then you'll need to use the server's shared certificate since we don't issue individual LE certs for opalstacked.com subdomains. Note that your browser will show a SSL error for sites using the shared cert on sub-subdomains like site.user.opalstacked.com but if you're just testing you can accept the warning and get on with it.
Add entries to your own computer's hosts file like:
```
   23.108.108.219 domain.com
   23.108.108.219 www.domain.com
```
(replaced with your server IP and domain)
With this, your system will bypass DNS and instead go directly to your Opalstack server IP. If you do this do not enable Let's Encrypt for your site, it will fail. If you need SSL for testing in this scenario then you'll need to get your old SSL cert (if you have one), add it as a manual cert, and then assign it to your site.