> For the complete documentation index, see [llms.txt](https://charliepage.gitbook.io/book/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://charliepage.gitbook.io/book/mysql-tips.md).

# MySQL Tips

#### Import SQL via Command Line

```
mysql -u root -p database_name < file.sql
```

#### Export SQL via Command Line

```
mysqldump -u root -p database_name > database.sql
```

#### Import .sql.gz file via Command Line

```
gunzip < production.sql.gz | mysql -h hosturl -u username -p db_name
```

#### Import sql.gz file via Command Line with progress bar

```
sudo apt-get install pv
pv mydump.sql.gz | gunzip | mysql -u root -p
```

#### Find most common value in table

```
SELECT column, COUNT(*) AS magnitude 
FROM table 
GROUP BY column 
ORDER BY magnitude DESC
LIMIT 1
```