create backup
<pre><code class="lang-php">sudo mysqldump -u root -p dbname &gt; backup.sql
</code></pre>
I believe the format is:
<pre><code class="lang-bash">mysql -u username -p database_name &lt; /path/to/file.sql
</code></pre>
From within mysql:
<pre><code class="lang-bash">mysql&gt; use db_name;
mysql&gt; source backup-file.sql;
</code></pre>

create backup

```php
sudo mysqldump -u root -p dbname > backup.sql
```

I believe the format is:

```bash
mysql -u username -p database_name < /path/to/file.sql
```

From within mysql:

```bash
mysql> use db_name;
mysql> source backup-file.sql;
```

How can I create and import a database using command line ?