Dumping a large database can be a daunting task. With millions of records you worry something may be missed or a small mistake could cost you hours of time.
I've found the easiest way to dump a database(s) is to use a simple script. This script uses the mysqldump program with the option "tab". This option "tab" will split the each databases's table into two files.
The first file is a "sql" files and contains all the sql used to generate the table. The second table is a "txt" file which is tab delimited row data.
Monday, June 19, 2017
Thursday, April 16, 2015
Go Programming Language working with Nested JSON elements
Working with JSON in the go programming can be very easy if use Structures to hold your data.
Thursday, September 18, 2014
Setting up Amazon Linux Instance - Extending User Timeout
If you are tired of logging into your EC2 instance and your connection dropping because of a timeout, the solution is simple.
Extend your timeout or turn it off all together.
To do this you must:
- Login to your ec2-instance
- From your home directory edit ".bash_profile"
- Add an export of the "TMOUT" environment variable.
- Save your file
TMOUT settings are set in seconds. So you can choose how long before your session expires. Setting TMOUT to 0 will make your session not expire, however setting it to any other number will expire your session the seconds you indicated after inactivity.
Example
- TMOUT to = 0 then your session will not expire.
- TMOUT to = 36400 then your session will expire in a day.
vi ~/.bash_profile
Subscribe to:
Comments (Atom)