Dev Blog | Web development | Consulting | Magento Extensions Development | arsit.ru

JavaScript seems to be disabled in your browser.
You must have JavaScript enabled in your browser to utilize the functionality of this website.

arsitm.com

0

You have no items in your shopping cart.

0

Home

Home >
Dev Blog >
Tagged with "mysql"

×

Login Form

E-mail address *

Password *

Forgot Password ?

or registration

×

Registration

Profile Informations

First Name *

Last Name *

Subscribe to Newsletter

Login Datas

E-mail address *

Password *

Password confirmation *

I accept the Terms and Coditions

Create DB backup via cli with filename based on date and time
10/6/2016 5:19 AM
Tags:
- mysql
- shell
```
mysqldump -u user -p dbname | gzip -c | cat > ~/backup/db-dev-$(date +%Y-%m-%d-%H.%M.%S).sql.gz
```
Read More
MySQL dumping and loading with process indicator
6/10/2014 3:12 PM
Tags:
Dumping with on-the-fly gzip and speed indicator*.
```
$ mysqldump -u root -p database | pv | gzip -c > database.sql.gz
```
Loading with on-the-fly gunzip and speed indicator*.
```
$ pv database.sql.gz | gunzip | mysql -u root -p database
```
* Package pv should be installed
Read More